Re: [cobalt-users] phpMyAdmin with avanced auth

[Glen Scott <glen@xxxxxxxxxxxxxxxxxxxx>]

> Hello!
>
> I have problems with the avanced authentication of phpMyAdmin. I 
> have 30 customers and the directory /phpMyAdmin/ is the alias for 
> all acounts, but when I loggin with oher username (what root) I 
> can´t access. The followin message error display:
>
> MySQL Connection Failed: Access denied for user: 'cybercu@localhost' 
> (Using password: YES)
>
>
> Can some people help me?

You will need to set up a MySQL user that has permissions to read 
from the mysql user and db tables. Try this:

GRANT USAGE, SELECT ON mysql.user to mysql_admin@localhost IDENTIFIED 
BY "password"
GRANT USAGE, SELECT ON mysql.db to mysql_admin@localhost IDENTIFIED 
BY "password"

Edit the phpMyAdmin config file and make sure you have the following lines:

$cfgServers[1]['adv_auth']      = TRUE;
$cfgServers[1]['stduser']       = 'mysql_admin';
$cfgServers[1]['stdpass']       = 'password';

Hope this is helpful.

Regards,

Glen Scott

--
---
  Design Solution Limited
  t: +44 (0)1502 513008
  f: +44 (0)1502 588622
  e: info@xxxxxxxxxxxxxxxxxxxx
  w: http://www.designsolution.co.uk
  Nouvotech House, Harbour Road,
  Oulton Broad, Suffolk, NR32 3LZ, UK
---
DS Knowledge Base http://faq.dessol.co.uk