Mysql 8.0 开启远程连接

-h127.0.0.1 -uroot -p你的密码

use mysql;

CREATE USER 'root'@'%' IDENTIFIED BY '你的密码'; 

GRANT ALL ON *.* TO 'root'@'%'; 

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

FLUSH PRIVILEGES;