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