Skip to main content

Reset MySQL Root Password

Today, In this article we are going to learn how to “Reset MySQL Root Password“.

It is a good option to use this method only for resetting the password but it is highly insecure. So make sure after resetting the password, you also revert the changes from my.cnf file.

Note:

For Centos and Fedora Based OS
sudo service mysqld stop
sudo service mysqld start

For Debian and Ubuntu OS
sudo service mysql stop
sudo service mysql start

Steps

Here i am using amazon linux 2 OS (based on centos)

  1. Stop mysql service – sudo service mysqld stop
  2. Open /etc/my.cnf file – sudo nano /etc/my.cnf
  3. Add skip-grant-tables under [mysqld] section
  4. Start MySql Service – sudo service mysqld start
  5. Open terminal and type mysql
  6. and type following query and press enter
    UPDATE mysql.user SET authentication_string=PASSWORD(‘Your new password’) WHERE User=’root’;
  7. Then write FLUSH PRIVILEGES; and press enter
  8. Now type – exit;
  9. Stop mysql service again – sudo service mysqld stop
  10. Open my.cnf file – sudo nano /etc/my.cnf
  11. Remove skip-grant-tables and save the file.
  12. Now Start the mysql – sudo service mysql start
  13. Great!!! You have successfully reset your MySQL root password.

Now you can login as a root user with your new password. To do this Open terminal and type

mysql -u root -p and press enter and type your new password to login.

Also checkout my other mysql tutorial

If you have any questions related to this article. Please leave it in comments.
And if you liked this article then please do like and share this post.

Thanks for reading 🙂 🙂

Labels:

Comments

Post a Comment

Popular posts from this blog

Automation - Update Naukri Profile Using Selenium

Recently one of my friend came to me with a problem. He is looking out for new job but he feels quite boring to update  his profile on daily basis. As some people says updating profile in the morning gives you more calls as it keeps the newly updated profile on top (Although i don’t know whether naukri works this way or not 😀 ). As i was more interested to solve his problem.  After listening his problem i came to solution that instead of updating it manually lets make this job automatic. And it is quite interesting how we can automate our daily boring task with automation. Another day i came with the solution . And the solution was to make it automatic using selenium (Those who are not aware about selenium do check this link) In short, Selenium is a Testing automation Framework. And it is for automating web applications for testing purposes, but is certainly not limited to just that. Boring web-based administration tasks can (and should) also be automated as well....
Post a Comment
Read more

Shut Down the Computer using notepad

Open notepad >> Write @echo off msg * I am tired. shutdown -c “So, Bye Bye dear” -s >> Save the File as AnyName.bat When you will open this file, your Computer will Shut down on its own after showing the message in it. NOTE: FOR EDUCATIONAL PURPOSE ONLY.I AM NOT RESPONSIBLE FOR IF ANYTHING GOES WRONG…. 
Post a Comment
Read more

Android - Show A Dialog From Service

In this article, I will be discussing how you can create a dialog from service. As we all know that service in android does not have any UI and it is intended for long-running background tasks. But sometimes it is required to show some information to the user when your app is running in the background. Today I will show you how you can implement this type of functionality in your application. Before starting the tutorial let me tell you about the special permission that we are going to use. Permission AndroidManifest.xml<uses-permission android:name="android.permission.SYSTEM_ALERT_WINDOW"/> This permission allows the app to use the system level window. AndroidManifest.xml <?xml version="1.0" encoding="utf-8"?><manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.app.dialogfromservice"> <uses-permission android:name="android.permission.SYSTEM_ALERT_WINDOW"/> <appl...
Post a Comment
Read more