您的位置:宽带测速网 > mysql教程 > 如何测试phpmyadmin创建在mysql上的用户

如何测试phpmyadmin创建在mysql上的用户

2025-06-24 08:04来源:互联网 [ ]

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;