[thelist] Problems connecting to database on new server

Liz Lawson lizlawson at charitycards.co.uk
Tue Dec 5 03:47:15 CST 2000

By default, when you first set up mysql there is a user at localhost without
a name or password.

When you connect to mysql, it looks for the first user that matches. As this
wildcard user is already in the list, when somename at localhost tries to
connect, it matches somename with the wildcard user even though somename is
in the list, just further down.

However, somename has tried to connect using a password, and the wildcard
user doesn't have a password. So, access denied.

(If you have the mighty fine Paul Dubois MySQL book, this is on pages
464-465 in more detail)

If this is your problem get rid of this wildcard user, not just for this
reason but for security in general.

>Just tried adding it.  No go.  :(

More information about the thelist mailing list