玄学酱 2018-01-05 760浏览量
目录
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'] [, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USER 'test'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'your_password';
CREATE USER 'root'@'192.168.1.%' IDENTIFIED BY 'password';
add a new user by grant
GRANT ALL PRIVILEGES ON opencart.* TO 'neo'@'localhost' IDENTIFIED BY 'chen' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'neo'@'localhost' IDENTIFIED BY 'chen' WITH GRANT OPTION; FLUSH PRIVILEGES;
DROP USER user [, user] ...
mysql> drop user admin@'localhost'; Query OK, 0 rows affected (0.00 sec) mysql> drop user admin@'127.0.0.1'; Query OK, 0 rows affected (0.00 sec)
RENAME USER old_user TO new_user [, old_user TO new_user] ...
mysql 5.7 之前的版本
SET PASSWORD FOR 'bob'@'%.loc.gov' = PASSWORD('newpass'); SET PASSWORD FOR 'root'@'%' = PASSWORD('co2uqAMAho1aSOS62146Xoci6ogu4I');
MySQL 5.7
ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password';
原文出处:Netkiller 系列 手札
本文作者:陈景峯
转载请与作者联系,同时请务必标明文章原始出处和作者信息及本声明。
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
分享数据库前沿,解构实战干货,推动数据库技术变革