How do I Reset the Root password of MySQL Using Linux?
- /usr/local/mysql/bin/safe_mysqld --skip-grant-tables &
- use mysql;
- update user set password = password('.......') where user = 'root' and host='localhost';
- Stop and Start the MySQL server. [2003Oct03 Note] A reader mentioned that it is easier to 'flush privileges' instead of restarting the server.