View, modify MySQL user name and password

First, check the password

Then you need to go into the/etc/mysql directory, execute sudo vi debian.cnf or sudo vimdebian.cnf to view the username and password inside,

Then use the user name and password in this file to enter MySQL,

If the user name in DEBIAN.CNF is Debian-sys-maint, then:

Mysql-u Debian-sys-maint-p Press ENTER, you need to enter the password, copy the password in debian.cnf, you can enter the MySQL database

Second, change the root password

After entering the MySQL client,

mysql> use MySQL;

Database changed

mysql> Update user Set Password=password (' New password ') where user= ' root ';

Query OK, 4 rows Affected (0.00 sec)

Rows Matched:4 Changed:4 warnings:0

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

Mysql> quit

You can check in with your new username and password.

View, modify MySQL user name and password