[BlueOnyx:24331] Re: phpMyAdmin login

[Michael Stauber]

Hi Colin,

> I have created a new vsite on one of our older 5208R CTs.
> I have created a site admin and a database.
> 
> When the site admin logs into the GUI using his credentials and goes to phpMyAdmin he is asked for a login.
> Using the database login details  he gets a #1045 Cannot log in to the MySQL server.
> 
> Have I missed something in the setup?
> 
> I can access phpMyAdmin when logged into the host as the admin.
> Checked the vsite database and the privs look correct.
> 
> Scratching my head.

Yeah, this is unusual. Normally when a Vsite has MySQL active and a
MySQL-user and at least one DB have been created via the GUI, then the
"Programs" / "phpMyAdmin" link on the Vsite GUI page will perform an
auto-login to MySQL using said credentials.

The "Programs" / "phpMyAdmin" link under "Server Management" (only
visible to Server Administrators) will always perform an auto-login
using MySQL-user "root".

If the auto-login fails, only then the form asking for MySQL username
and password will be shown.

>From this behavior we can deduct that the auto-login using the stored
credentials failed. But we don't know why.

For the "hostname" ... did you specify "localhost"? On 5209R and 5210R
that ought to be "127.0.0.1" instead, as the alias "localhost" won't
work there.

-- 
With best regards

Michael Stauber