phpmyadmin mysql8 加密方式 caching_sha2_password

create user dongxt@'%' identified by 'password';

grant all privileges on *.* to dongxt@'%' with grant option;

alter user dongxt@'%' identified with mysql_native_password by 'password';

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH caching_sha2_password BY 'password';
Query OK, 0 rows affected (0.02 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

改bind 本机ip

重启mysql