拽拽
管理员组

MYSQL设置远程访问

1) 授权法(推荐使用)
* 授权给所有ip
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;

* 授权给某ip
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'your ip' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;


#1楼
发帖时间:2021-5-7   |   查看数:0   |   回复数:0
游客组