PhpMyAdmin attempts to connect to the MySQL server, but the server refuses to connect

Source: Internet
Author: User
Tags phpmyadmin

PhpMyAdmin attempts to connect to the MySQL server but the server rejects the connection--workaround

 

 

PhpMyAdmin attempts to connect to the MySQL server, but the server rejects the connection. You should check the host, user name, and password in the configuration file and confirm that the information is consistent with the information given by the MySQL server administrator.

The reason for this may be because the password for the MySQL database has been modified.

 

Workaround:

1) Modify the $cfg in the config.inc.php under phpMyAdmin [' Servers '] [$i] [' password '] = '; options

2) Modify $cfg[' Servers ' [$i] [' auth_type '] = ' http '; Modify to HTTP
Of course, there may still be an error here, because this is caused by IE cache, choose IE Internet Options, general-"clear browsing history, clear the cache to resolve the problem

 

The following is the configuration information for the database configuration in config.inc.php:

has a config.inc.php in the phpMyAdmin directory, you can open it with Notepad, and then in the
/* Authentication type and Info * * The following
$cfg [' Servers '] [$i] [' auth_type '] = ' config ';
$cfg [' Servers '] [$i] [' user '] = ' root ';
$cfg [' Servers '] [$i] [' password '] = ' ************* ';   //Database password
$cfg [' Servers '] [$i] [' Extension '] = ' mysql ';

 

This file is the PHP admin configuration file, I changed the password is 123, after encryption, tried a few times not, only to find that should enter the encrypted password, verified in the shell can be directly landed.

PhpMyAdmin tried to connect to the MySQL server, but the server refused to connect

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.