Mysql | Forgot root password in Mysql

If you forget mysql root password these are few easy steps to regain access:

1. shell> mysqld_safe –skip-grant-tables

2.Open another terminal shell> mysql -u root -p (hit enter and use blank password)

3. mysql>UPDATE mysql.user SET Password=PASSWORD(‘NewPassword’)WHERE User=’root’;

4. mysql>FLUSH PRIVILEGES;

5. mysql>exit

6. shell>service mysqld restart

Webner Solutions is a Software Development company focused on developing CRM apps (Salesforce, Zoho), LMS Apps (Moodle/Totara), Websites and Mobile apps. If you need Web development or any other software development assistance please contact us at webdevelopment@webners.com