Topic: Upgrade to 6.01 causes phpmyadmin problem

[d6hq]

Just upgraded a server from 5.6 to 6.01 all seemed fine until I attempted to access phpmyadmin which now fails with

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

I have seen loads of stuff concerning problems with the mysql db for webmail but nothing on phpmyadmin

Can anyone point me in the right direction ?

[CKConsulting]

I had similar problems with 6.0.1 when I re-ran the setup.  It reset the mysql password and I had to reset it.  I also set phpmyadmin to prompt me for the password and I havn't had any issues.

Rick

[CAM]

Most probably the password specified on your PHPADMIN config.inc.php under the config parameters
$cfg['Servers'][$i]['user']=xxxuser
$cfg['Servers'][$i]['password']=xxxpassword
are not the same as the ones stored in your your MySql users database.

I would create a new user (I always try to avoid using root).

Example:

Modify the config.inc.php

$cfg['Servers'][$i]['user']=phpadmin
$cfg['Servers'][$i]['password']=1234

then login as root to your E-Smith server and type

mysql

mysql>grant all privileges on *.* to phpadmin@localhost identified by '1234' with grant option;

You may want to limit the user rights later but for testing purpouses this should sufise.

Hope it works!

[d6hq]

It was a password issue but I resolved it by upgrading to the latest version of phmyadmin and therefore re-writing config file rather than a manual hack

Thanks all