use mysql;
GRANT USAGE ON *.* TO ‘user_name‘@‘localhost‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION;//授权user_name用户以密码123456访问数据库
GRANT SELECT,INSERT,UPDATE,DELETE ON db_name.* TO ‘user_name‘@‘localhost‘ IDENTIFIED BY ‘123456‘;//授权user_name用户访问db_name数据库的所有表.访问权限[SELECT,INSERT,UPDATE,DELETE]
FLUSH PRIVILEGES;//必须有
==突然领导说我要访问你的数据.然后悲剧了,如何支持远程连接呢？== 把localhost换成%. localhost表示只能本地访问
use mysql;
GRANT USAGE ON *.* TO ‘user_name‘@‘%‘ IDENTIFIED BY ‘123456‘ WITH GRANT OPTION;
GRANT SELECT,INSERT,UPDATE,DELETE ON db_name.* TO ‘user_name‘@‘%‘ IDENTIFIED BY ‘123456‘;
==妹的,还是访问不了,注意关闭你的防火墙==