简单粗暴（基础知识我就不啰嗦了，自己网上查）
linux 允许mysql用户远程访问
标签：date create trigger linu class upd mysql用户 option super
linux 允许mysql用户远程访问
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‘@‘%‘;