Getting Access denied error while installing phpmyadmin in ubuntu11.4

Question

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.

Accepted Answer

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
```

Getting Access denied error while installing phpmyadmin in ubuntu11.4

Solution

Problem