[thelist] any phpMyAdmin experts out there?

Tony Crockford tonyc at boldfish.co.uk
Mon Apr 26 16:40:54 CDT 2004


At 22:14 on Monday, 26 Apr 2004, Tom Dell'Aringa wrote:

> "phpMyAdmin tried to connect to the MySQL server, and the server
> rejected the connection. You should check the host, username and
> password in config.inc.php and make sure that they correspond to the
> information given by the administrator of the MySQL server."
> Error

did you set up config.inc.php in the phpmyadmin folder with a valid user  
name and password?

here's what I have:

$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or  
IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave  
blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket  
- leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to  
MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed  
protocol for the MySQL connection
                                                     // (requires PHP >=  
4.3.0)
$cfg['Servers'][$i]['controluser']   = '';          // MySQL control user  
settings
                                                     // (this user must  
have read-only
$cfg['Servers'][$i]['controlpass']   = '';          // access to the  
"mysql/user"
                                                     // and "mysql/db"  
tables)
$cfg['Servers'][$i]['auth_type']     = '***http***';    // Authentication  
method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = '***mymysqluser***';      // MySQL  
user
$cfg['Servers'][$i]['password']      =  
'***mymysqluserspassword***';          // MySQL password (only needed
                                                     // with 'config'  
auth_type)

****you need to replace these****.

I've used http for authorisation so probably don't need the mysqluser and  
password as Apache asks for them on pHPmyadmin's behalf.

if you set $cfg['Servers'][$i]['auth_type'] to 'config' you'll need a  
valid MySQL user and password pair, the default for MySQL is 'root' with  
no password - something that PHPmyAdmin will warn you about and should be  
changed.

(I hope your firewall is good enough to prevent all these evolters trying  
to hack your MySQL!)

hth

Tony



More information about the thelist mailing list