Mysql | Forgot root password in Mysql

Author - Navneet Kashyap

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

Webner Solutions is a Software Development company focused on developing Insurance Agency Management Systems, Learning Management Systems and Salesforce apps. Contact us at dev@webners.com for your Insurance, eLearning and Salesforce applications.

Leave a Reply

Your email address will not be published. Required fields are marked *

Send your message