Topic: mysql password and .my.cnf

[charlic]

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

[J-L Boers]

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