mysql 用户

1.删除用户:drop user 'name'@'localhost';    @前后的''或者""不可少

  drop不了,使用delete:delete from mysql.user where user='name' and host='localhost';

  flush privileges;

2.grant all privileges on *.* to 'root'@'10.0.0.%' identified by 'pass';

 

posted @ 2017-06-26 20:39  wangxingg  阅读(39)  评论(0)    收藏  举报