Home >Database >Mysql Tutorial >MySQL用户操作命令_MySQL
MySQL用户操作命令_MySQL
- WBOYOriginal
- 2016-06-01 13:12:34757browse
create user 'username'@'localhost' identified by 'password';--创建用户set password for 'username'@'localhost'=password('newpassword');--修改用户密码grant all on *.* to 'username'@'localhost';--授权revoke all on *.* to 'username'@'localhost';--撤销授权drop user 'username'@'localhost';--删除用户
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：MySQL表的增操作_MySQLNext article：【MySQL】MySQL锁和隔离级别浅析一_MySQL