Modify MySQL password phpMyAdmin cannot log in _php tutorial

Appear phpmyadmin can not log in is I modified my MySQL server password after the cause, and then Baidu has related reasons, originally modified the mysql password we also need in the phpMyAdmin directory to modify the contents of config.inc.php.

Error hints

#1045-access denied for user ' root ' @ ' localhost ' (using Password:yes)

Locate the config.inc.php file in the phpMyAdmin directory and modify the following location

For config.inc.php files, the most important thing is to modify the username and password to join the phpMyAdmin connection to MySQL. Find the line of code:

The code is as follows	Copy Code
$cfg [' Servers '] [$i] [' controluser '] = ' PMA '; $cfg [' Servers '] [$i] [' controlpass '] = ' pmapass ';

Delete the "//" comment number and enter the user name and password configured in MySQL, for example:

The code is as follows	Copy Code
$cfg [' Servers '] [$i] [' controluser '] = ' ids.la '; $cfg [' Servers '] [$i] [' controlpass '] = ' ********* ';

Note: If you need to use phpMyAdmin with remote server debugging, you need to add the Blowfish_secret content definition cookie to find the line of code:

The code is as follows	Copy Code
$cfg [' blowfish_secret '] = ';

Set content to Cookie

The code is as follows	Copy Code
$cfg [' blowfish_secret '] = ' leosn ';

Linux phpMyAdmin can not log in to connect to MySQL, and no prompt problem solving method

The problem is as follows:
PHP environment has been well-equipped, normal. phpMyAdmin can not login, regardless of password input is correct, there is no error prompt, automatically jump back to the login page

Surface.

Workaround:
1, in php.ini find Session.save_path this line, set to Session.save_path = "/var/lib/php/session", and put the front

The semicolon is removed.
The above/var/lib/php/session according to your actual situation set.

2. Modify the permissions and owner of this directory:

The code is as follows	Copy Code
# Chown-r Nobody:nobody/var/lib/php/session

(Nobody permissions are very low, it is best to set it for the Web run account!) ）

The code is as follows	Copy Code
# chmod 777/var/lib/php/session

(Session Directory is set at least 770 permissions above, otherwise phpMyAdmin login will be problematic.) ）

3, restart the related services, if it is Apache, restart the Apache service:/etc/init.d/httpd restart; if it is Nginx, restart the PHP-FPM

Service

The code is as follows	Copy Code
:/etc/init.d/php-fpm Restart

http://www.bkjia.com/PHPjc/632145.html www.bkjia.com true http://www.bkjia.com/PHPjc/632145.html techarticle appear phpmyadmin can not log in is I modified my MySQL server password after the cause, and then Baidu has related reasons, the original is modified MySQL password after we also need in phpMyAdmin eye ...

