Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to change the Root password of MySQL/MariaDB under Linux, which has a certain reference value, and interested friends can refer to it. I hope you can learn a lot after reading this article.

Modify the root password of MySQL or MariaDB

You know the root password, but you want to reset it. In this case, let's first make sure that MariaDB is running:

-CentOS/RHEL 7 and Fedora 22 +-# systemctl is-active mariadb- CentOS/RHEL 6 and Fedora-# / etc/init.d/mysqld status

Check MysQL status

If the above command returns without the keyword active, then the service is stopped, and you need to start the database service before moving on to the next step:

-CentOS/RHEL 7 and Fedora 22 +-# systemctl start mariadb- CentOS/RHEL 6 and Fedora-# / etc/init.d/mysqld start

Next, we will log in to the database server as root:

# mysql-u root-p

To be compatible with different versions, we will update the user table of the mysql database with the following declaration. Note that you need to replace YourPasswordHere with the new password you selected for root.

MariaDB [(none)] > USE mysql;MariaDB [(none)] > UPDATE user SET password=PASSWORD ('YourPasswordHere') WHERE User='root' AND Host =' localhost';MariaDB [(none)] > FLUSH PRIVILEGES

To verify that the operation was successful, enter the following command to exit the current MariaDB session.

MariaDB [(none)] > exit

Then, hit enter. You should now be able to connect to the server with the new password.

Thank you for reading this article carefully. I hope the article "how to change the Root password of MySQL/MariaDB under Linux" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.