How to modify the MySQL database root password using phpMyAdmin

This article mainly introduces the use of phpMyAdmin to modify the MySQL database root user password method, the need for friends can refer to the

Click on the "SQL" tab at the top to enter the SQL command input interface. Enter the following command:

The code is as follows: Update mysql.user set Password=password (' jb51$123456 ') where user= ' root ';

Then click on the lower right corner of the "execution", no error will indicate the success of the modification.

Also note that if you modify the root password after our phpMyAdmin configuration file password also needs to be modified, otherwise login does not go up oh.

Found it

The code is as follows: $cfg [' Servers '] [$i] [' password '] = ';

Amended to

The code is as follows: $cfg [' Servers '] [$i] [' password '] = ' jb51$123456 ';

Then click on the lower right corner of the "execution", see the following interface, it means that the modification succeeded. (Note: Some MySQL here affect the number of columns is not 2)