phpMyadmin installation errors and their solutions

This article explains phpMyadmin installation errors and solutions.

1. Download and installation:

https://files.phpmyadmin.net/phpMyAdmin/4.7.1/phpMyAdmin-4.7.1-all-languages.zip

Just copy all the files in the phpmyadmin directory to the site directory

Description: Enable the mysqli module

Problem 1:

2002 Unable to log in to the MySQL server

phpMyAdmin cannot log in. After entering the user name and password and clicking "Execute", it keeps reporting "#2002 Unable to log in to the MySQL server".

Solution, change

$cfg['Servers'][$i]['host'] = 'localhost';

in the config.default.php file under the "phpMyAdmin/libraries" folder to

$cfg['Servers'][$i]['host'] = '127.0.0.1';

Question 2:

#1045 Unable to log in to the MySQL service

1. Modify the /phpmyadmin/libraries/config.default.PHP file.

Find the following two lines

$cfg['Servers'][$i]['nopassword'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

Modify to:

$cfg['Servers'][$i]['nopassword'] = true;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

2. If you still cannot log in at this time, try clearing cookies. Or just enter a few characters.

3. Change the password promptly after successful login.

The above is the detailed content of phpMyadmin installation errors and their solutions. For more information, please follow other related articles on the PHP Chinese website!