mysq创建用户并分配到某个数据库上_MySQL
- WBOYOriginal
- 2016-06-01 13:32:25944browse
bitsCN.com
mysq创建用户并分配到某个数据库上
Sql代码
create user 'kent'@'%' identified by 'kentpassword';
create user 'kent'@'localhost' identified by 'kentpassword';
grant all privileges on kentdb.* to 'kent'@'%' with grant option;
grant all privileges on kentdb.* to 'kent'@'localhost' with grant option;
bitsCN.comStatement：
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
Previous article：mysql工具备份脚本_MySQLNext article：数据库系统概念读书笔记――实体-联系模型_MySQL