Mysql | Forgot root password in Mysql

| By Webner

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’;


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

Leave a Reply

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