Cannot connect to MySQL with PMA

[ArcAiN6]

For some reason i cannot connect to MySQL using PMA.

i know i'm using the correct username / password combonation and still it says:
Error
Cannot log in to the MySQL server

is there any way of re-configuring PMA for a different password?

[rbtux]

is the login possible on console?

mysql -u user -p ?

[ArcAiN6]

rbtux Wrote:is the login possible on console?

mysql -u user -p ?

yes.. i can login within the console using mysql -u user -p

[ArcAiN6]

hrm... appears there is no database for PMA? that or i cannot see it as root..

[joximu]

Hi

AFAIK pma does not use any mysql user to check the login (I just renamed user pma in the pma-config and I still could login with pma).

So, maybe there are other errors in you config.inc.php from pma?

[joximu]

ArcAiN6 Wrote:hrm... appears there is no database for PMA? that or i cannot see it as root..

what database are you looking for?

[ArcAiN6]

joximu Wrote:

ArcAiN6 Wrote:hrm... appears there is no database for PMA? that or i cannot see it as root..

what database are you looking for?

any database that would be related to phpmyadmin or pma..

only databases i currently have are:

information_schema
ispcp
maia
mysql
subd (going to be website's db)

[joximu]

pma has no database for itself.

pma uses the normal mysql users to decide what to shouw and who can log in...

[ArcAiN6]

then i don't know waht the problem is, i can login to mysql from shell, as well as from a remote machine. But when i try to login via PMA, it states it cannot.

is there a convienient way of re-installing PMA, and it's sql information i.e. database entries, and username / password?

[ArcAiN6]

even if i change the username / password in "/var/www/ispcp/gui/tools/pma/config.inc.php"
to match what i use to connect to mysql, the PMA will still not connect.