Re: MySQL allowing anonymous logins over SSH

[Mark Knecht]

So I found that I could do a

DROP USER ""@localhost;

and I got rid of that user but unless I am doing something wrong so far I cannot get rid of the anonymous@c2RAID6 user.

mysql> SELECT host,user,password FROM mysql.user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *A294441C38B03BE12E32771ADDF7976B0DDB8164 |
| c2RAID6 | root | *A294441C38B03BE12E32771ADDF7976B0DDB8164 |
| 127.0.0.1 | root | *A294441C38B03BE12E32771ADDF7976B0DDB8164 |
| c2RAID6 | | |
| localhost | mark | *E8F1FB8D711EFE40BEE77B5E9EC940D7C1740E15 |
+-----------+------+-------------------------------------------+
5 rows in set (0.00 sec)

mysql>