MySQL-MySQL8授权远程连接
说明
- MySQL8.0.15授权远程连接
操作步骤
- 本地登录MySQL后执行以下操作
mysql> use mysql
mysql> select host,user from user;
mysql> update user set host='%' where user='root';
mysql> select host,user from user;
mysql> flush privileges;
mysql> use mysql
mysql> select host,user from user;
mysql> update user set host='%' where user='root';
mysql> select host,user from user;
mysql> flush privileges;