Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: charlic on September 22, 2001, 01:11:10 AM

Title: mysql password and .my.cnf
Post by: charlic on September 22, 2001, 01:11:10 AM

I no it s always the same question ...
I want use mysql with phpmyadmin but i have a mysql connection failed :
Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: YES) in /home/e-smith/files/primary/html/lib.inc.php3 on line 275
Erreur
with password in .my.cnf
 *  phpMyAdmin Configuration File
 */

// The $cfgServers array starts with $cfgServers[1].  Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host'] = 'localhost';           // MySQL hostname
$cfgServers[1]['port'] = '';                    // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = false;             // Use advanced authentication?
$cfgServers[1]['stduser'] = '';                     // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = '';                 // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'root';                // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = 'KVGJTw+8XsSmEyuBR8cu5mmEZVh3qdRjHyPGhpJdeNyPmfC7RA5vWs1mXqAFvgVF9lW0fvBlXybK';

what is the problem please help me

Title: Re: mysql password and .my.cnf
Post by: J-L Boers on September 23, 2001, 09:38:55 PM

I just did it again last night during testing of the new SME 5.

the password is in /root/.my.cnf

#cat /root/.my.cnf

look under the [client] section and you will find something like this

[client]
password=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

be careful of line wrapping. there is only one line under the client section. if it wraps on you, you may be missing some of the password and that will be your problem.

J-L