Getting Access denied error while installing phpmyadmin in ubuntu11.4

mysql ubuntu phpmyadmin ubuntu-11.04
ASR picture ASR · Jul 5, 2012 · Viewed 13.7k times · Source

Im a newbie in ubuntu. Im getting an error while installing phpmyadmin in ubuntu11.4 server. It 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 login to mysql through putty.
Do I need to do anything with privileges?

Please help me to sort this issue.

Answer

Ajay Bidyarthy picture Ajay Bidyarthy · Jul 28, 2012

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.

Re-configure mysql-server:

sudo dpkg-reconfigure mysql-server

or

sudo dpkg-reconfigure mysql-server-5.1

whichever one is installed.

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

sudo dpkg-reconfigure phpmyadmin

Related questions

MySQL: How to reset or change the MySQL root password?

How do I change the MySQL root password and username in ubuntu server? Do I need to stop the mysql service before setting any changes? I have a phpmyadmin setup as well, will phpmyadmin get updated automatically?

Read More
How to secure phpMyAdmin

I have noticed that there are strange requests to my website trying to find phpmyadmin, like /phpmyadmin/ /pma/ etc. Now I have installed PMA on Ubuntu via apt and would like to access it via webaddress different from /phpmyadmin/. What …

Read More
Remove privileges from MySQL database

Before you think this is a duplicate question, I believe I have a unique, even if it is somewhat dim-witted, case. A few days ago, I upgraded the version of MySQL on my Ubuntu 10.04 server to 5.3.3 (it's ahead of the …

Read More