MySQL 授权

MYSQL远程连接只能看见部分数据库解决方法

http://www.cnblogs.com/gengsc/p/6905536.html

http://www.2cto.com/database/201204/127236.html

授权登录命令:

grant all privileges on *.* to '用户名'@'%' identified by '密码' with grant option;

授权增删改查命令

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON 数据库.* TO 用户名@'%' identified by '密码';

 

转载于:https://www.cnblogs.com/JNUX/p/7028392.html