How to modify the MySQL database root password using phpMyAdmin _mssql

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

Copy Code code 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

Copy Code code as follows:

$cfg [' Servers '] [$i] [' password '] = ';

Amended to

Copy Code code 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)