Solved MySQL server question

[fred974]

Hello,
I just noticed that I have strange entries in my MySQL database.
If I run mysql> select user,host from mysql.user;, I get

+---------------+--------------------+
| user          | host               |
+---------------+--------------------+
| sqldbadmin    | 127.0.0.1          |
| ossec         | 192.168.1.125      |
| ossec         | 192.168.1.185      |
| sqldbadmin    | ::1                |
|               | holy.trinitech.ltd |
| sqldbadmin    | holy.trinitech.ltd |
|               | localhost          |
| dbbackup      | localhost          |
| sqldbadmin    | localhost          |
+---------------+--------------------+
11 rows in set (0.00 sec)

Does anyone know why I have blank enties in my user and host fields?
Just o clarified, I rename the root user to sqldbadmin but I cannot remember the way I did it..

Should I delete the blank entries? if yes how would I do that?

Thank you
Fred

 

[SirDice]

Those blank entries are default accounts. You can remove them.

use mysql;
delete from mysql.user where user like "";