Mysql远程访问

2014-07-25

Mysql远程访问设置

>use mysql;
>GRANT ALL ON *.* TO root@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
>flush privileges;

MySQL 8 修改密码

>CREATE USER 'super'@'%' IDENTIFIED BY 'MyPass@123';
>GRANT ALL ON *.* TO 'super'@'%' WITH GRANT OPTION;
>flush privileges;
>ALTER USER 'super'@'%' IDENTIFIED WITH mysql_native_password BY 'MyPass@123';