Login Problem with phpMyAdmin and MySQL

[Daveyc]

Hello all,

Okay, I installed EHCP yesterday, and everything was working great after bvidinli helped me with the panel access problem.

I was able to add a website, add the MySQL database and the site is online and working great.

However, I now have the following issue. I added another domain, and added a MySQL db and user. All the connection info is correct, however the site states that access is denied. So i decided to check this out by logging into phpMyAdmin, and I couldn't login there either. No error message, it just redirects me back to the pma login page.

So, i decided to test to see if i could log in on the account i created yesterday, and although the site is working perfectly, phpMyAdmin states: #1045 Cannot log in to the MySQL server

I've checked that the mysql server is running, i've also issued a mysql, apache2, ehcp restart, and still nothing.

Any ideas?

Cheers,

Dave

Restored from old drupal forum, for user uid:3349 usernameaveyc
You may reset your password to access your new account here.

[ehcpdeveloper]

in fact, if your panel working,
and if your website working,
then, most probably your mysql working with right permissions.

However, your second website/mysql user may have broken somehow.
Or, you may have trying something wrong, without knowing that it is wrong.

So, in these kind of (I mean, strange situations) I suggest you to work on very basic tests.

So, try:
<li> is mysqld running? command: ps aux | grep mysql
<li> can you connect using root pass: mysql -p
<li> after connect, select * from mysql.users , what you see ?
<li> try connecting using 1st site's user: mysql -u thatuser -p
<li> prepare a very basic php file, that you know exactly where it is, then, run it in webserver. (Sometime, people and also I even mix files, and call wrong file ! ) Echo something specific in that php, so that you know that it is the file you just worked on.



Restored from old drupal forum, for user uid:3349 usernameaveyc
You may reset your password to access your new account here.