mysql anonymous user, no password!

Discussion in 'General' started by j2l, Jul 12, 2007.

  1. j2l

    j2l

    Joined:
    Jun 26, 2007
    Messages:
    8
    Likes Received:
    0
    Visiting mysql with webmin, I found an Anonymous user, without password, not limited to localhost and with access to mysql table, "only".

    Is it only my version (0.8.4) or others have the same?
     
  2. eboza

    Joined:
    Mar 27, 2007
    Messages:
    45
    Likes Received:
    0
    If you want to delete anonymous user:

    # mysql -u root -p mysql

    mysql> DELETE FROM user WHERE user = '';
    mysql> FLUSH PRIVILEGES;

    Don't forget mysql root password: eLaStIx.2oo7

    - Edwin
     

Share This Page