Unable to log in to phpmyadmin solution

Solution when an error occurs and cannot log in to phpmyadmin:

Find config.inc.php and change the password directly;

If you cannot find it, create it yourself The config.inc.php file is placed in the first folder:

$cfg['PmaAbsoluteUri'] = "";
$cfg['Servers'][1]['host'] = "localhost";
$cfg['Servers'][1]['auth_type'] = 'config';
$cfg['Servers'][1]['user'] = "root";
$cfg['Servers'][1]['password'] = "你的新密码";
?>

1. phpmyadmin cannot log in after changing the password. It is possible that phpmyadmin fails to change the mysql password. You can log in directly using the original password.

mysql reset password:

mysql>use mysql
mysql>set password for 'root'@'localhost'=password('newpasswd');
mysql>set password for 'root'@'%'=password('newpasswd');

2, it is also possible that you have forgotten the password you just changed. You can change the Mysql password again. The steps are as follows

The specific steps are as follows:

1. Close the running MySQL.

2. Open the DOS window and go to the mysql\bin directory.

3. Enter mysqld-nt --skip-grant-tables and press Enter. If no prompt message appears, you're right.

4. Open another DOS window (because the DOS window just now cannot be moved) and go to the mysql\bin directory (cd).

5. Enter mysql and press Enter. If successful, the MySQL prompt will appear>

6. Connect to the permission database>use mysql; (> is the original prompt, Don’t forget the semicolon at the end)

7. Change password: > update user set password=password("123") where user="123";

8. Refresh permissions ( Required steps)>flush privileges;

9. Exit> \q

10. Log out of the system, re-enter, open MySQL, use user name 123 and the new password 123 just set Login.

Related recommendations: phpmyadmin tutorial

The above is the detailed content of Unable to log in to phpmyadmin solution. For more information, please follow other related articles on the PHP Chinese website!