mario a. spinthiras

This is not something new. Nor is it something super difficult. If you get super lost with mysql passwords , consider this a reminder on how to get your root password back (the mysql root password).

1. Stop the mysqld daemon process.(/etc/init.d/mysql stop)
2. Start the mysqld daemon process with the –skip-grant-tables option (/usr/sbin/mysqld –skip-grant-tables &)
3. Start the mysql client with the -u root option.(mysql -u root -p)
4. Execute the UPDATE mysql.user SET Password=PASSWORD(’newpasshere’) WHERE User=’root’;
5. Execute the FLUSH PRIVILEGES; command.
6. Quit mysql (killall -9 mysqld)
7. Start mysql normally (/etc/init.d/mysql start)
8. Claps claps. Enjoy your new root password.