1. 增加或者修改用户root的host为%,给与所有IP有访问权限。
mysql>use mysql; mysql>update user set host = ‘%’ where user =’root’; 或者: mysql>grant all privileges on *.* to root@'%' identified by "password"; mysql>flush privileges; mysql>quit
2. 检查user的几个值的情况:
mysql> select Host,User,authentication_string from user;
3. 修改mysql的配置,取消本地绑定:
修改 /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 127.0.0.1
为:
# bind-address = 127.0.0.1
按照以上三个步骤即可实现外部访问。
版权所有丨如未注明,均为原创,转载请注明转自:https://whonee.net/mysql-connect-in-internet.html
1 thought on “mysql 外部访问设置”