Topic: phpMyAdmin

[glc]

Installed it but the page doesn't come up when trying to access it, so I tried the standard phpMyAdmin and it returns the following:
Error
MySQL said:


MySQL Connection Failed: Access denied for user: 'regardlessofuser@localhost' (Using password: YES)

How do I get either working?

TIA>

[peter]

It seems you´d have to grant access for that user befor accessing the db.

Have fun,
Peter

[glc]

peter wrote:
>
> It seems you´d have to grant access for that user befor
> accessing the db.
>
> Have fun,
> Peter
How do I do that?

[Richard Whitney]

GRANT ALL ON databasename to 'regardlessofuser, password' ;

or just use root to access the database

[glc]

Richard Whitney wrote:
>
> GRANT ALL ON databasename to 'regardlessofuser, password' ;
>
> or just use root to access the database

Where is this setting located?  config.inc.php?

[Richard Whitney]

login to the server as root

type:  mysql

type:  use database dbname
type:  GRANT ALL ON dbname TO 'username, password';

or, to use root as username, find $username ="";  - put root between the ""

[glc]

Richard Whitney wrote:
>
> login to the server as root
>
> type:  mysql
>
> type:  use database dbname
> type:  GRANT ALL ON dbname TO 'username, password';
>
> or, to use root as username, find $username ="";  - put root
> between the ""
I still get access denied.  Is there a file I need to edit manually on SME?

[glc]

root doesn't work either

[glc]

ok, now it's complaining about the mysql.sock:
ERROR 2002: Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (111)

please help...

[glc]

OK, solved the mysql.sock problem by removing and reinstally the 4 rpms used for mysql.  I can use phpMyAdmin using w/ the user root, but typing mysql at the console yields the following:
ERROR 1045: Access denied for user: 'root@localhost'  (Using password: YES)

How can this be if root can login w/ phpMyAdmin?