Its very common to forgot the root password for mysql server. Here are simple steps to reset mysql root password.
Step # 1: Stop the MySQL server process.
Step # 2: Start the MySQL (mysqld) server/daemon process with the .skip-grant-tables option so that it will not prompt for password
Step # 3: Connect to mysql server as the root user
Step # 4: Setup new root password
service mysqld stop mysqld_safe --skip-grant-tables & mysql -u root use mysql update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit service mysqld restart
Only drawback is that your application will be impacted while recovering root password my mysql.
No related posts.