Can not login to phpmyadmin with root user

Question

I am having trouble to login to with phpmyadmin in Ubuntu system.

Username - root Password - empty

but still it show me error like below

 #1045 - Access denied for user 'root'@'localhost' (using password: NO)

Help me to solve it Thank you.

Answer 1

I sloved it with below steps:

1) Open config.inc.php file

2) Change file permition to write

sudo chmod 777 /etc/phpmyadmin/config.inc.php

3) Add below line to the file

 $cfg['Servers'][$i]['user'] = 'root';
 $cfg['Servers'][$i]['password'] = 'MY_SQL ROOT_USER_PASSWORD';
 $cfg['Servers'][$i]['AllowNoPassword'] = true;

4) Change file parmissions to original again

 sudo chmod 755 /etc/phpmyadmin/config.inc.php

5) Restart server

service mysql start or service mysql start

6) open

http://localhost/phpmyadmin
username: root
password: YOUR_MYSQL'S ROOT USER'S PASSWORD

• Successfully logged in to phpmyadmin.

Answer 2

in terminal, type

sudo gedit '/etc/phpmyadmin/config-db.php'

The user file will get open Just check the username like

$dbuser='phpmyadmin';

And password like

$dbpass='1234';

Just copy this username and password without quotes in login page.

Answer 3

This is the correct answer:

sudo dpkg-reconfigure -plow phpmyadmin