Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I set up a LAMP server on Ubuntu server. Now the thing is that PHP and Mysql are all properly installed and do work. Now I got phpmyadmin installed and connected to my host. Everything works fine except for the logging in where I get those errors:

2003 Can not login into MYSQL SERVER

Connection for user as defined in your configuration failed

Now the point is that the password and username are absolutely correct. So that's definitely not the problem.

  • I also changed bind-address = 127.0.0.1 (at the my.cnf for mysql) to my internal ip-address after having some issues with that. Because this all began because I did not select apache2 at the installation for phpmyadmin. So I reinstalled and reconfigured it etc. and eventually I did get the phpmyadmin screen.

So now the problem is that I don't know what to do. Can you guys give me some suggestions? Is it an idea to reinstall mysql?

Thanks in advance, I can undestand it's a bit vague so comments with questions are no problem at all.

share|improve this question
    
woops sorry men –  Sjaak Rusma Dec 20 '12 at 21:03
add comment

1 Answer

Problem solved, added my internal ip address beside localhost to:

/etc/hosts

like this:

192.168.x.x      devserver

Hope it helps anyone,

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.