mysql允许远程访问
- 应该注意防火墙中3306端口的开放;
- ubuntu中进行设置
grant all privileges on *.* to 'root'@'%' identified by '123456';
flush privileges
去掉:bind-address=127.0.0.1
service mysql restart
1
2
3
4
5
6
2
3
4
5
6
上次更新: 2024/06/16, 12:40:33
Lisy's blog grant all privileges on *.* to 'root'@'%' identified by '123456';
flush privileges
去掉:bind-address=127.0.0.1
service mysql restart