Error Removing Anonymous Accounts

2010-03-11 Thread Carlos Mennens
I installed MySQL 5 today and started by setting up root passwords for all three root accounts: mysql select User, Password, Host, Create_priv from user; +--+---+---+-+ | User | Password | Host |

RE: Error Removing Anonymous Accounts

2010-03-11 Thread Rolando Edwards
-Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Thursday, March 11, 2010 11:21 AM To: MySQL Subject: Error Removing Anonymous Accounts I installed MySQL 5 today and started by setting up root passwords for all three root accounts: mysql select User, Password, Host

Re: Error Removing Anonymous Accounts

2010-03-11 Thread Carlos Mennens
On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards redwa...@logicworks.net wrote: DELETE FROM mysql.user WHERE user=''; FLUSH PRIVILEGES; That worked and I thank you however I am wondering why the MySQL guide was incorrect? Perhaps it's right but I did something wrong. Any thoughts? -- MySQL

RE: Error Removing Anonymous Accounts

2010-03-11 Thread Gavin Towey
: Thursday, March 11, 2010 8:32 AM To: MySQL Subject: Re: Error Removing Anonymous Accounts On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards redwa...@logicworks.net wrote: DELETE FROM mysql.user WHERE user=''; FLUSH PRIVILEGES; That worked and I thank you however I am wondering why the MySQL