Re: Problems Creating a New User

[Michael Widenius]

>>>>> "Christopher" == Christopher Hicks <chicks@stripped> writes:

Christopher> Monty wrote:
>> This means that you will insert an entry with host='%' to the MySQL
>> user table.  The problem is that the entry 'host=localhost' and
>> 'user='' is more specific than the above.

Christopher> Why is user='' in there by default?  I've been doing grants then setting
Christopher> host='localhost' to get them to work.

Hi!

The user='' is to allow anyone to connect to the test database.  This
is quite nice for first time MySQL users, even if it may make things worse
for others.

Regards,
Monty