How to solve the problem that mysql-front cannot be found and cannot connect to MySQL

Mysql-front cannot find the solution: first run the console program as an administrator and connect to mysql; then enter "ALTER USER..."; finally execute "FLUSH PRIVILEGES".

Recommended: "mysql video tutorial"

MySQL-Front cannot connect to MySQL problem

The reason why some users are unable to connect is that the encryption method of MySQL8.0 version is different from the encryption method of previous versions.

Solution: Change the encryption method

(1) Run the console program as an administrator and connect to mysql:

mysql -u root -p

(2) Enter

ALTER USER 'root'@'database address' IDENTIFIED WITH mysql_native_password BY 'database password';

(3) Finally

FLUSH PRIVILEGES

The above is the detailed content of How to solve the problem that mysql-front cannot be found and cannot connect to MySQL. For more information, please follow other related articles on the PHP Chinese website!