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?

is the login possible on console?

mysql -u user -p ?

rbtux Wrote:is the login possible on console?

mysql -u user -p ?

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

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

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?

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

what database are you looking for?

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)

pma has no database for itself.

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

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?

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.