From: Neil Aggarwal <neil@stripped>
Sent: 10 December 2009 01:19
Subject: RE: Missing Entries
> I was checking my fresh install of MySQL and noticed I had empt spaces
> or missing entries in some sections when I did a search for users on
> the 'mysql' database.
According to this page:
If you want to prevent clients from connecting as anonymous users
without a password, you should either assign a password to each
anonymous account or else remove the accounts.
We I do a MySQL install, I always go into the mysql client as root
and issue these commands:
delete from user where Password='';
Be careful doing this on a fresh install, if you don't set passwords for root first you
will delete all the initial root accounts too!
You really should read the installation section of the manual. Your issue is simple
because the installation has not been secured.
It removes those accounts.
MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer
Telephone: +44(0)1283 537111
Mobile: +44(0)7812 451238
Sent via HP IPAQ mobile device