增加用户
(推荐教程:mysql视频教程)
举例:创建test用户,密码是1234
mysql -u root -p create user 'test'@'localhost' identified by '1234'; #本地登录 create user 'test'@'%' identified by '1234'; #远程登录 quit mysql -u test -p #测试是否创建成功
删除用户
mysql -u root -p delete from mysql.user where user=”test” and host=”localhost”; flush privileges; drop database testdb;
删除账户及权限:
drop user 用户名@’%’; drop user 用户名@ localhost;
相关推荐:mysql教程
以上就是mysql5.7怎么增加用户的详细内容。
