linux 允许mysql用户远程访问
2017-09-16 13:14:24 依然范儿特西阅读(0) 点赞(0) 评论(0)
本文为转载文章，如有侵权，请联系博主。原文链接：http://www.cnblogs.com/richerdyoung/p/6669645.html
搭建服务器。。怎么导入数据库？ 直接来个用户吧
数据库名字(已存在)： table
创建mysql新用户,并指定数据库，允许远程访问
mysql用户： test
mysql用户密码： test666
CREATE USER 'test'@'%' IDENTIFIED BY 'test666'; GRANT GRANT OPTION ON *.* TO 'test'@'%'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'test'@'%'; GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON `table`.* TO 'test'@'%'; GRANT GRANT OPTION ON `table`.* TO 'test'@'%';
简单粗暴（基础知识我就不啰嗦了，自己网上查）