ADADADADAD

如何测试phpmyadmin创建在mysql上的用户[ mysql数据库 ]

mysql数据库时间：2024-11-26 22:14:48

作者：文/会员上传

如何提高mysql查询效率

简介：

INSERT INTO mysql.USER(HOST,USER,PASSWORD) VALUES("localhost","testsuer",PASSWORD("1234"));FLUSH PRIVILEGES;GRANT SELECT,INSERT,DELETE,UPDATE ON test.* TO '

以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。

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;