Recovering a lost root password for MySQL
Once in a while (hopefully not to often) you need to recover the root password of a mysql database. Here is a quick guide how I do this normally: 1. Stop the running database (if it isn’t stopped already) /etc/init.d/mysql stop 2. Start the database with the ‘skip-grant-tables’ option mysqld_safe –skip-grant-tables & 3. Open the [...]