ispCP - Board - Support
Cannot connect to MySQL with PMA - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Cannot connect to MySQL with PMA (/thread-1972.html)

Pages: 1 2 3

Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 03:39 AM

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?

RE: Cannot connect to MySQL with PMA - rbtux - 12-11-2007 03:40 AM

is the login possible on console?

mysql -u user -p ?

RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 03:45 AM

rbtux Wrote:is the login possible on console?

mysql -u user -p ?

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

RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 03:53 AM

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

RE: Cannot connect to MySQL with PMA - joximu - 12-11-2007 03:55 AM

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?

RE: Cannot connect to MySQL with PMA - joximu - 12-11-2007 03:56 AM

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

what database are you looking for?

RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 04:04 AM

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)

RE: Cannot connect to MySQL with PMA - joximu - 12-11-2007 04:45 AM

pma has no database for itself.

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

RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 05:54 AM

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?

RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 06:06 AM

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.