MySQL开启root远程访问权限
允许任何IP使用 root 账户,口令8个1远程访问
方法1
Sql代码
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘11111111’ WITH GRANT OPTION;
方法2
Sql代码
mysql> use mysql;
mysql> update user set host = ‘%’ where user = ‘root’;
MySQL开启root远程访问权限
允许任何IP使用 root 账户,口令8个1远程访问
方法1
Sql代码
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘11111111’ WITH GRANT OPTION;
方法2
Sql代码
mysql> use mysql;
mysql> update user set host = ‘%’ where user = ‘root’;