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怎么增加用户的详细内容!
声明:本文来自网络,不代表【好得很程序员自学网】立场,转载请注明出处:http://www.haodehen.cn/did93538
mysql5.7怎么增加用户
阅读:167次