INSERT INTO mysql.USER(HOST,USER,PASSWORD) VALUES("localhost","testsuer",PASSWORD("1234"));
FLUSH PRIVILEGES;
GRANT SELECT,INSERT,DELETE,UPDATE ON test.* TO 'testuser'@'10.24.%.%' IDENTIFIED BY '1234';
FLUSH PRIVILEGES;
GRANT SELECT ON phpmyadmin.pma_table_uiprefs TO 'testuser'@'10.24.%.%' IDENTIFIED BY '1234';
FLUSH PRIVILEGES;
GRANT INSERT,DELETE ON phpmyadmin.pma_recent TO 'testuser'@'10.24.%.%' IDENTIFIED BY '1234';
FLUSH PRIVILEGES;
FLUSH PRIVILEGES;
GRANT SELECT,INSERT,DELETE,UPDATE ON test.* TO 'testuser'@'10.24.%.%' IDENTIFIED BY '1234';
FLUSH PRIVILEGES;
GRANT SELECT ON phpmyadmin.pma_table_uiprefs TO 'testuser'@'10.24.%.%' IDENTIFIED BY '1234';
FLUSH PRIVILEGES;
GRANT INSERT,DELETE ON phpmyadmin.pma_recent TO 'testuser'@'10.24.%.%' IDENTIFIED BY '1234';
FLUSH PRIVILEGES;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16131092/viewspace-2132370/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
phpmyadmin 的配置
请登录后发表评论
登录
全部评论
