I've just installed phpmyadmin on my bioLinux. When the logo screen shows http://localhost/phpmyadmin, and I try to log in it appears: #1045 Cannot log in to the MySQL server.
I've tried all posibilities. I install and reinstall it with the Synaptic Package manager, with and without password (using 'root' as username).

Could anyone help me? Thanks

3 questions:

1. Did you install MySQL? phpMyAdmin is just a front end for that.
2. When you installed MySQL, what username and password did you set up as admin?
3. Can you log in from the command line to your MySQL database?

Answering those 3 should help you solve the problem - if not, post back and I'll try to help more.

Is MySQL installed?
Can you login to MySQL from the command line?
Are MySQL and phpMyAdmin on the same machine?

If the solutions from the gurus above don't work.

]# mysql -uroot
>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your password here');
>flush privileges;
\q
then
]# mysql -uroot -p

or
]# mysqladmin -u root password "my new password"


You should have checked(peruse) MySQL out before hand.

I think that MySQL is properly installed, in the terminal:

mysql -h localhost -U root -p xxxxxxx
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
....

I believe that should be mysql -u root -p xxxx

When you do that, your prompt should change to a mysql> prompt that tells you are actually in. Type status at that prompt to confirm all is ok

-U is not the same as -u , but perhaps you typed the post wrong.

Can you open a database or browse a table from the command line? That will also tell you if mysql is working ok.

I'd also recommend giving mysqladmin a go to tell you more about what is going on.

By default, there is no password for root in mysql, so unless you've set it try logging in at the phpMyAdmin login screen with root user and blank for password.

info on setting mysql root password

And is the MySQL server running?

Thanks a lot for the replies!

I just set up a new password

$ mysqladmin -u root password NEWPASSWORD

and login phpmyadmin with 'root' and my newpassword. I don´t know why doing this before, with root as user name and blank for password didn´t work.

Thank you.

Here is a Troubleshooting:

http://install-climber.blogspot.com/...onding-or.html

I installed mysql using synaptic manager. Didn't have to enter a root password.
The command
mysqladmin -u root password NEWPASSWORD

worked. I was able to login into PhpMyAdmin immediately.

I have the same problem,thanks to whk his solution worked!

phpMyAdmin does not allow blank passwords by default. You can change the behavior in config.inc.php but setting up a password for root is secure option. And if you can setup a new user which will have database specific privileges, that would be more secure.

just wanted to add my solution, tried everything without avail.
In the end removing "Require valid-user" from the phpmyadmin.conf file allowed me in to the web ui.