Recover MySQL root Password

1. Stop the MySQL server. # /etc/init.d/mysql stop 2. Start the MySQL server process with the –skip-grant-tables option so that it will not prompt for password. # mysqld_safe –skip-grant-tables & 3. Connect to mysql server as the root. # mysql -u root Welcome to the MySQL monitor…. ……….. Type ‘help;’ or ‘\h’ for help. Type … Read more