That’s all folks and feel free to contact us in case if you have any query. We have cover one of the best solution which you can use to reset the password. You can also join the conversation if you have any other solution or idea which we can use to make it more attractive and easy. Using above example we can reset MySQL root password easily and provide a way to manage user account on MySQL. Start the MySQL server and login with blank password mysql -u root -p Create New User CREATE USER IDENTIFIED BY 'admin123' GRANT ALL PRIVILEGES ON *. mysql -u root Update new MySQL root passwordĮxecute the following command to update the MySQL root password: update user set password=PASSWORD('') where User='root' update user set plugin='' where User='root' update user set authentication_string='' where User='root' flush privileges exit Stop the MySQL service sudo /etc/init.d/mysql stop Login with Blank a password Leave the current terminal as it is, and open a new terminal tab and login into MySQL root password. Stop the MySQL service sudo /etc/init.d/mysql stop Start up safe mode sudo mysqld_safe -skip-grant-tables & Connect to MySQL This process may vary according to the operating system. If you want to reset or change MySQL password or have forgotten the password for accessing phpMyAdmin then just follow the below step to reset the password or change the password. I’d like to share it with you a quick, simple, well written and easy method with will explains how you can reset the MySQL root password. Don’t panic it can be recovered, there is a quick and easy way to get back up and running. Have you forgotten your MySQL root password? How can you retrieve it back? What’s should you do now? Is this recoverable or not? What happens with my Databases? These are some common question which comes to our mind whenever we lose our MySQL root password. Steps are create a mysql-init.txt file containing UPDATE er SET PasswordPASSWORD ('newpass') WHERE User'root' FLUSH PRIVILEGES I saved it as C:\me\mysql-init and in command prompt I wrote- C:\wamp\bin\mysql\mysql5.5.8\bin\mysqld -init-fileC:\me\mysql-init.txt I tried with double backslashes also.but it is not working.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |