Linux CentOS 开源社区
我们一直在努力与你相伴

MySQL基本优化命令

1、MySQL更改为只能本地登录
# use mysql;
# select user,host,Password from user where user='root';
# delete from user where user='root' and host='%';

2、MySQL授予外网登陆权限

grant all privileges on *.* to 授予外网登陆的用户名@'%' identified by '密码' WITH GRANT OPTION;

# grant all privileges on *.* to root@'%' identified by 'root' WITH GRANT OPTION;
# flush privileges;
赞(2) 打赏
©著作权归作者:linux 开源社区 » http://linux.design/1862.html
标签:

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏