Home >Database >Mysql Tutorial >mysql数据库添加用户及分配权限具体实现_MySQL
mysql数据库添加用户及分配权限具体实现_MySQL
- PHP中文网Original
- 2016-05-27 14:12:061489browse
bitsCN.com
创建用户并分配权限；
insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));//创建用户
grant all privileges on dbname.* to 'username'@'%' identified by 'password';//创建用户并分配所有权限
grant select,update on phplampDB.* to phplamp@localhost identified by '1234';//创建用户并分配权限
update mysql.user set password=password('新密码') where User="phplamp" and Host="localhost";//修改用户密码--删除用户指定权限
revoke insert,update,delete,select ON *.* from 'xbb'@'localhost' IDENTIFIED BY '123';
以上就是mysql数据库添加用户及分配权限具体实现_MySQL的内容，更多相关内容请关注PHP中文网（www.php.cn）！
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
Previous article：linux服务器清空MySQL的history历史记录 删除mysql操作记录_MySQLNext article：Mysql的longblob字段插入数据问题解决_MySQL