mysql如何删除HostName账号和localhost账号

语法: Delete from user where user = "user_name" and host = "host_name"

例子：delete from user where user='sss' and host='localhost'

或者： 取消一个账户和其权限

Drop USER user

drop user username@'%'

drop user username@localhost

先在命令行里进去mysql的bin目录，然后输入 mysqld-nt skip-grant-tables

然后重新打开一个命令行，进去到mysql的bin目录，然后输入mysql回车就可以进入到mysql

然后在mysql.user表插入root用户记录

按下列步骤建立 root 用户：

>insert into mysql.user (host, user, password) values ('localhost', 'root', password('密码'))

>flush privileges

>grant all on *.* to 'root'@'localhost

弄好后 然后把窗口够关了 重启mysql服务。

---