Access access error while installing phpmyadmin in ubuntu11.4

Question

I am new to ubuntu. I get an error when installing phpmyadmin on ubuntu11.4 server. He says

An error occurred while installing the database: ERROR 1045 (28000):Access denaid for user 'root'@'localhost' (using password:YES); 

I am sure that I used the correct password for root. I can enter mysql via putty.
Do I need to do anything with privileges?

Please help me solve this problem.

Answer 1

I suggest:

 mysql -h localhost -u root -p 

and you typed something else. :(

pidof mysqld says what exactly? If nothing, then sudo service mysql start and try

 mysql -h localhost -u root -p 

again.

Reconfigure mysql server:

 sudo dpkg-reconfigure mysql-server 

or

 sudo dpkg-reconfigure mysql-server-5.1 

depending on which one is installed.

Once you reconfigure (and recover) your mysql root password, then Reconfigure phpmyadmin

 sudo dpkg-reconfigure phpmyadmin 

Answer 2

I ran into the same problem and just solved the problem. I used "ü" in my root user password. It looks like PHPMYADMIN cannot handle the utf-8 set. So I changed the password to "abc" and it will work! Just remember to cancel your temporary password :)

Answer 3

I have the same problem and I installed my car again, because although I did something wrong. But the same problem after reinstalling Ubuntu.

What works for me is to install mysql-server and phpmyadmin NOT as root user. I create a new user adduser admin and put him in the sudo group using adduser admin sudo . After that, I exit my ssh connection with the root account and sign up with the new administrator. Now I install both software packages and, suprise, everything works fine.