Skip to Content

Login Problem with phpMyAdmin and MySQL

Tue, 07/20/2010 - 00:17 — 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

‹ Cannot use links on EHCP Can't access ehcp panel ›
bvidinli's picture

in fact, if your panel

bvidinli - 07/20/2010 - 04:04

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:

  • is mysqld running? command: ps aux | grep mysql
  • can you connect using root pass: mysql -p
  • after connect, select * from mysql.users , what you see ?
  • try connecting using 1st site's user: mysql -u thatuser -p
  • 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.


    • Theme by Dr. Radut.