Author - Daniel Guzmán Burgos

Reset MySQL root password without restarting MySQL (no downtime!)

Disclaimer: Reset the MySQL root password at your own risk! It doesn’t apply if you’re using Pluggable authentication and certainly won’t be usable if/when MySQL system tables are stored on InnoDB
Reset MySQL root password with care!
What is the situation?
The situation is the classic “need to reset MySQL root password” but you cannot restart MySQL (because it […]

Read more

Log rotate and the (deleted) MySQL log file mystery

Did your logging stop working after you set up logrotate? Then this post might be for you.
Archive your log files!
Some time ago, Peter Boros wrote about Rotating MySQL Slow Logs safely, explaining the steps of a “best practice” log rotate/archive. This post will add more info about the topic.
When running logrotate for MySQL (after […]

Read more