Search code examples
phpubuntuphpmyadminubuntu-17.04

Can not login to phpmyadmin with root user

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.

Solution

  • 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.