mysql – Doesn't allow phpMyAdmin

Question:

In Debian 9, when installing MySQL, it did not ask for a password, apparently, the root password was substituted. Then I installed phpMyAdmin, when asked about the password, I just pressed ENTER .

Now, when trying to log into phpMyAdmin with the root username and without a password, it does not start up:

Login without a password is forbidden by configuration (see AllowNoPassword)

Already what passwords and logins have not tried – no result. Then I reinstalled both – it does not help.

Answer:

After installation, you can search the logs /var/log/mysqld.log value of temporary password , or, as they wrote in the comments, start changing the password with the command mysql_secure_installation

Scroll to Top