好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

mysql5.7怎么增加用户

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怎么增加用户的详细内容!

查看更多关于mysql5.7怎么增加用户的详细内容...

  阅读:167次