Home  >  Article  >  Database  >  创建仅能访问一个数据库的用户

创建仅能访问一个数据库的用户

WBOY
WBOYOriginal
2016-06-07 14:55:001080browse

无详细内容 无 CREATE USER 'username'@'%' IDENTIFIED BY 'password';GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'%';FLUSH PRIVILEGES;

CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'%';
FLUSH PRIVILEGES;
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn