is this safe to: DROP USER ''@'localhost';

[trover]

Hi,

in mysql i have this :

mysql> SELECT User, Host, Password FROM mysql.user;

+------------------+---------------------------+-------------------------------------------+
| User             | Host                      | Password                                  |
+------------------+---------------------------+-------------------------------------------+
| root             | localhost                 | *1112223334445556667778889991112223334445 |
| root             | server.hostname.com       | *1112223334445556667778889991112223334445 |
| root             | 127.0.0.1                 | *1112223334445556667778889991112223334445 |
| root             | ::1                       | *1112223334445556667778889991112223334445 |
|                  | [COLOR=#ff0000]localhost[/COLOR]                 | *1112223334445556667778889991112223334445 |
|                  | [COLOR=#ff0000]server.hostname.com[/COLOR]       | *1112223334445556667778889991112223334445 |
| da_admin         | localhost                 | *1112223334445556667778889991112223334445 |
+------------------+---------------------------+-------------------------------------------+

as you can see in my example, in 2 lines:
@localhost and @server.hostname.com have no any user assigned,

so is this safe if i remove them?

DROP USER ''@'localhost';

or they must stay? or they not important anyway?

Thanks

 

[zEitEr]

Hello,

Those are anonymous users, and you can safely remove them.