vim /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-adress = 127.0.0.1改成0.0.0.0
否则会拒绝127.0.01以外的所有请求
授权:
update user set host = "%" where user = "root";
更改权限:
grant all privileges on *.* to root@‘%‘ identified by "pwd";
2022-09-26 15:47:07
vim /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-adress = 127.0.0.1改成0.0.0.0
否则会拒绝127.0.01以外的所有请求
授权:
update user set host = "%" where user = "root";
更改权限:
grant all privileges on *.* to root@‘%‘ identified by "pwd";