MySQL CLI: From Connection to Maintenance
Updated:
Master MySQL from the command line: connect, query databases, manage users, repair tables, optimize—everything you keep Googling, one reference.
All the articles with the tag "mysql".
Master MySQL from the command line: connect, query databases, manage users, repair tables, optimize—everything you keep Googling, one reference.
MySQL 8.0 broke auth, MariaDB forked hard, and Docker changed how you connect. Here's what still works and what'll bite you.
Automate MySQL/MariaDB backups from a running Docker container using cron and mysqldump — no downtime, no excuses for losing your data.
Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.