How to change the mysql password in Centos: centosmysql

How to change the mysql password in Centos: centosmysql

1. Modify MySQL Logon Settings:

# Vim/etc/my. cnf

Add the following sentence: skip-grant-tables.

For example:

[Mysqld] datadir =/var/lib/mysqlsocket =/var/lib/mysql. sock

2. Restart mysql

# Service mysqld restartStopping MySQL: [OK] Starting MySQL: [OK]

3. Change the password

Mysql> USE mysql; Database changedmysql> UPDATE user SET Password = password ('new password') WHERE User = 'root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> quit

4. modify the configuration file.

# Vim/etc/my. cnf

5. Restart mysql

# Service mysqld restartStopping MySQL: [OK] Starting MySQL: [OK]

The above section describes how to change the mysql password in Centos. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!