Search code examples
mysqlapachephpmyadminlamp

Configure phpMyAdmin with username and password not allows to login

I'm using phpMyAdmin on CentOS v6. Configured it to authentication type: cookie, I set username and password. (in /etc/phpMyAdmin/config.inc.php)

When I browse to http ://my-server/phpMyAdmin/ I get a web login form, I entered the username and password that I worte in the configuration file but it tells:

#1045 Cannot log in to the MySQL server

I looked after the following guide: http://ifzenelse.net/en/install-and-configure-phpmyadmin-centos

Solution

  • There was a conflict: the phpMyAdmin configuration that says to not allow login without a password ($cfg['Servers'][$i]['AllowNoPassword']= FALSE;), but my mysql user (root) had no password so I couldn't login!

    So as mentioned in one of the answers here I had to set password to the root user by:

    # mysqladmin -u root password your-password

    Then restart servers and login again