Home  >  Article  >  Database  >  MYSQL删除匿名用户的方法_MySQL

MYSQL删除匿名用户的方法_MySQL

WBOY
WBOYOriginal
2016-06-01 13:42:36932browse

bitsCN.com
删除匿名用户 在MySQL刚刚被安装后,存在用户名、密码为空的用户。这使得数据库服务器有无需密码被登录的可能性。为消除隐患,将匿名用户删除。 [root@sample ~]# mysql -u root -p  ← 通过密码用root登录Enter password:  ← 在这里输入密码 Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 7 to server version: 4.1.20Type 'help;' or '/h' for help. Type '/c' to clear the buffer.mysql> select user,host from mysql.user;  ← 查看用户信息+------+----------------------------+    | user | host         |+------+----------------------------+|   | localhost       || root | localhost       ||   | sample.centospub.com || root | sample.centospub.com  |+------+----------------------------+4 rows in set (0.02 sec)mysql> delete from mysql.user where user='';  ← 删除匿名用户Query OK, 2 rows affected (0.17 sec)mysql> select user,host from mysql.user;  ← 查看用户信息+------+----------------------------+| user | host         |+------+----------------------------+| root | localhost      || root | sample.centospub.com |+------+----------------------------+   作者 亦梦亦真 bitsCN.com

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn