[BlueOnyx:02539] Re: MySQL users

[Gerald Waugh]

  Apologies if this is a real newb question but MySQL in BO and BQ seems to be installed with some default users without passwords:

          User     Host                     Password         Global   privileges      
          Any      %                        --               USAGE    No       
          Any      localhost                No               USAGE    No       
          Any      localhost.localdomain    No               USAGE    No        

  This seems a bit alarming. Can I safely remove these?

  mysql> select User,Host from mysql.user;
  +------+-----------------------+
  | User | Host                  |
  +------+-----------------------+
  | root | 127.0.0.1             |
  | root | localhost             |
  | root | localhost.localdomain |
  +------+-----------------------+
  3 rows in set (0.00 sec)

  the user is root, and that is because on a default install there is no password set.

  Gerald
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20091002/f143e6d5/attachment.html>