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

3D ANALYZER SETTINGS

Settings for Prince of Persia Sands of Time Works with this game, u can try wid others also which are not in above list Performance section: -force zBuffer Hardware limits: -emulate HW TnL caps -emulate Pixel shader caps ANTI-DETECT MODE section: -shaders Z-buffer section: -24 bit zbuffer(with stencil) DirectX DeviceID’s section: NVIDIA GeForce Ti4600 Configuration: VendorID : 4318 Device ID :592 Works well in the following or higher configuration -Intel 865GSA motherboard, -512 MB RAM, -Pentium D dual core 2.66 GHz processor, -No graphics card required…….. have fun.
184 comments
Read more

Choosing the Best Motherboard

We will look at the various factors you should take into account when choosing your gaming motherboard, to ensure that you choose the best motherboard for your needs.If you think of the processor as the brain of a computer, then the motherboard could be described as the central nervous system, responsible for relaying information between all the internal components. In other words, it’s the hub of the computer, where all other components connect to. Since the motherboard is so crucial to your system, buying the best motherboard you can afford is a good investment. Select Your CPU First Before choosing your motherboard, you should have already chosen your CPU. If you haven’t already doneA motherboard will generally only support one type of processor, such as a Pentium 4 or Athlon 64. Different CPUs have connectors that vary physically from one another. So you can’t accidentally plug in the wrong processor into the wrong motherboard. Also, take note that many motherboards
Post a Comment
Read more

Choosing the Best CPU for Your Gaming Computer

Picking the latest, fastest or most expensive processor on the market won’t always result in the right CPU for your particular system. Some processors are designed to work with certain motherboards, so the CPU you choose will limit the type of motherboard you can get. The CPU (Central Processing Unit) is one of the most important components in any computer system. The CPU could be described as the brains of a computer. It contains the logic circuitry that performs the instructions of the software you run. The performance of your games and other applications will be directly related to this tiny little microprocessor. The Major Players: Intel and AMD Two companies dominate the CPU market, Intel and AMD (Advanced Micro Devices). Both companies make a range of different processor models.  For example, Intel have the Core i7 and Core i5 processor models, while AMD have the Athlon and Phenom series.  The Best CPU for Gaming If you’re a basic computer user and you don’t
14 comments
Read more