phpMyAdmin modify MySQL password with phpMyAdmin Unable to sign in solution _php Tutorial

There are many ways to modify the MySQL password method, the most commonly used is to use phpMyAdmin to change the password, if such as we do not command and also in the command mode to modify the MySQL password feel very difficult, I would like to introduce phpMyAdmin to modify the MySQL password method introduced.

Modify Password method

First, through the browser login phpMyAdmin console, click "Permissions",

Second, check the root user, and click on the following "Edit Permissions",

Third, in the middle of the open page, find the "Change Password" column, enter two times the new password, and click the "Execute" button;

Note that you will be prompted when you change your password and then log in with phpMyAdmin

After repairing the MySQL password in phpMyAdmin, phpMyAdmin can not login, the error prompt is:

Welcome to use PhpMyAdmin 2.9.0
Probably reason of this is so you do not create a configuration file. You might want to use the setup script to create one.
Error

MySQL return:

#1045-access denied for user: ' Root@localhost ' (Using password:no)

The solution is

Enter the XAMPP installation directory, modify the xampp/phpmyadmin/config.inc.php file, locate and set the password to start the change, such as $cfg[' Servers ' [$i] [' password '] = ' 8888 ';

In addition, we can click "Permissions" to see the entire database of users as follows, you can click "Action" to modify the user password, modify config.inc.php accordingly.

http://www.bkjia.com/PHPjc/630685.html www.bkjia.com true http://www.bkjia.com/PHPjc/630685.html techarticle There are many ways to modify the MySQL password method, the most commonly used is to use phpMyAdmin to change the password, if such as we do not command also in the command mode to modify the MySQL password feel very laborious ...

