Summary of solutions to why phpmyadmin cannot log in

Summary of solutions to why phpmyadmin cannot log in_PHP tutorial

WBOY

Release： 2016-07-13 10:56:23

Original

1219 people have browsed it

The following summarizes some solutions to the problem that phpmyadmin cannot log in during development. Friends in need can refer to it.

Error

MySQL returns:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

Find the config.inc.php file in the phpmyadmin directory and modify the following location

The code is as follows

代码如下	复制代码
$cfg['Servers'][$i]['user'] = 'user'; $cfg['Servers'][$i]['password'] = 'password';

Copy code

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

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

Prompt error: Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. From the prompt, you can see that it is a PHP problem. Search the Internet to find a solution and try it. Success:

1. In the PHP installation directory, change the value of session.auto_start in php.ini to 1 (start), the default is 0 (disable)

2. Create a folder tmp in the php directory (such as C:/php/tmp), and set the tmp attribute to every one full control

3. Find the session.save_path line in php.ini, set it to session.save_path = “C:/php/tmp”, and remove the semicolon in front of it (the above C:/php/tmp is set according to your actual situation )
4. Restart the computer, everything is OK, and you can log in to both versions of phpMyAdmin

It will be a little different in Linux, the error is as follows.

An error will be prompted when logging in. The error message content is the same, but the code may be different. Because I don’t know where the problem lies, I often change this and that when checking and testing. The error message is as follows:

#2002 Cannot log in to the MySQL server

#2003 Cannot log in to the MySQL server

代码如下	复制代码
cp /usr/share/phpMyAdmin/config.sample.inc.php /etc/phpMyAdmin/config.inc.php

#1045 Cannot log in to the MySQL server

2. Solution

代码如下	复制代码
vim /etc/phpMyAdmin/config.inc.php

I spent a lot of time yesterday but couldn’t figure it out, and I couldn’t find the answer on the Internet. I went out for fun today and solved this problem just after I came back in the evening. It's actually very simple.

Directly cp copy the configuration file sample config.sample.inc.php file in the phpMyAdmin installation directory to the configuration file directory (the following only uses the default directory when using the installation method provided here)

The code is as follows

代码如下	复制代码
$cfg['blowfish_secret'] = '';

Copy code

代码如下	复制代码
$cfg['blowfish_secret'] = 'leosn';

cp /usr/share/phpMyAdmin/config.sample.inc.php /etc/phpMyAdmin/config.inc.php

Then use vim to edit and modify some configurations directly in the system (also recorded in the installation method mentioned above)

The code is as follows

Copy code

vim /etc/phpMyAdmin/config.inc.php Note: If you need to use phpMyAdmin through remote server debugging, you need to add the blowfish_secret content definition cookie and find the line of code:

The code is as follows

Copy code

$cfg['blowfish_secret'] = ''; Set content as COOKIE

The code is as follows	Copy code
$cfg['blowfish_secret'] = 'leosn'; http://www.bkjia.com/PHPjc/632164.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632164.htmlTechArticleThe following summarizes some solutions to the problem that phpmyadmin cannot log in during development. Friends in need can refer to it. Error MySQL returns: #1045 - Access denied for user 'root'@'localh...