mysql给root开启远程访问权限

打开cmd
找到mysql安装目录
cd  盘符：
cd 安装目录
mysql -u root -p
use mysql
select  User,authentication_string,Host from user;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' ;

flush privileges;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123123';

(密码改成了123123或者你自己的,重新连接成功)