[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