Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: d6hq on May 20, 2004, 04:46:14 PM

Title: Upgrade to 6.01 causes phpmyadmin problem
Post by: d6hq on May 20, 2004, 04:46:14 PM

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 ?

Title: phpmyadmin
Post by: CKConsulting on May 21, 2004, 02:50:40 PM

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

Title: Upgrade to 6.01 causes phpmyadmin problem...
Post by: CAM on May 21, 2004, 02:55:50 PM

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!

Title: Sorted
Post by: d6hq on May 22, 2004, 01:35:59 PM

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