MySQL Guides
Remote access, backups, and working with dates across the stack.
All guides
Convert Date Formats Between PHP, MySQL, and JavaScript
MySQL, PHP, and JavaScript each default to a different date format — here's exactly how to convert between all three without losing the timezone.
Automate Daily MySQL Backups with Cron
A cron job that dumps your MySQL database every night, compresses it, and automatically deletes backups older than a week.
Allow Remote MySQL Access on Port 3306 (Ubuntu)
Configure MySQL on Ubuntu to accept remote connections safely — bind-address, user grants, and the firewall rule, in the right order.