Buy Percona ServicesBuy Now!

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

 | December 10, 2014 |  Posted In: Insight for DBAs, MySQL

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 What is the situation? The situation is the classic “need to reset MySQL root password” but you cannot restart MySQL (because it is the master production […]

Read More

Log rotate and the (deleted) MySQL log file mystery

 | November 12, 2014 |  Posted In: Insight for DBAs, MariaDB, MySQL, Percona Monitoring Plugins, Percona Server for MySQL

Did your logging stop working after you set up logrotate? Then this post might be for you. 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 proper setting […]

Read More