Browsing Category
MySQL
65 posts
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter My, and “SQL”, the acronym for Structured Query Language.
How to Use MySQL Database with Node.js
I still remember the first time I connected a Node.js app to MySQL. I had built plenty of…
How to Use MySQL Database with Python
I’ve written a lot of Python code that talks to MySQL — everything from small ETL scripts to…
How to Use MySQL Database with PHP
PHP and MySQL are practically siblings — I’ve been pairing the two since my early freelancing days building…
How to Configure MySQL Database for High Availability
I still remember the night a single MySQL server going down took our entire product with it for…
How to Monitor MySQL Database Performance
I’ve lost count of how many “the app is slow” tickets have turned out to be MySQL problems…
How to Revoke Privileges in MySQL Database
Granting privileges gets all the attention, but in my experience as a DBA, revoking them properly is where…
How to Grant Privileges in MySQL Database
Granting privileges is where MySQL security either holds up under pressure or quietly falls apart. I’ve inherited databases…
How to Create User Accounts in MySQL Database
Every security incident I’ve ever reviewed involving a database had one thing in common: user account management that…
How to Use the ORDER BY Clause in MySQL Database
Of all the SQL clauses I use daily, ORDER BY looks the simplest and yet quietly causes more…
How to Use the BETWEEN Operator in MySQL Database
BETWEEN is one of the first operators I teach anyone learning SQL, because it reads almost like plain…