Centos7: change the password of a specified mysql user, centos7mysql

Centos7: change the password of a specified mysql user, centos7mysql

This document describes how to change the password of a mysql user on Centos7, as follows:

1. log on to mysql or mariadb (either)

[root@localhost ~]# mysql -u root [root@localhost ~]# mysql -uroot -p

2. Switch to the database that stores the user name and password

MariaDB [mysql]> use mysql; press enter to display the following Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with-ADatabase changed

3. Change the password. The password () function is used to encrypt the password. In fact, an SQL statement is executed to update the password of a specified user.

MariaDB [mysql]> update user set password = password ('new password') where user = 'username to update the password'; press ENTER->; Query OK, 0 rows affected (0.00 sec) Rows matched: 5 Changed: 0 Warnings: 0

4. Refresh the user permission list

MariaDB [mysql]> flush privileges; press ENTER Query OK, 0 rows affected (0.00 sec)

5. log out of mysql

MariaDB [mysql]> quitBye

6. Restart mysql or mariadb.

[Root @ localhost ~] # Service mysqld restart (restart mysql) [root @ localhost ~] # Service mariadb restart (restart mariadb)

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.