"Cameron Fitzhugh" <com> wrote:
You did not specify a hostname. A MySQL account is always userhost
where the host part may contain wildcards. Just user is synonym for
Why didn't you copy the *complete* error message? I guess it reads:
Access denied for user 'WCuser''localhost' (using password: YES)
The problem is the 'localhost' part. A host '%' matches any host when
the user connects via the network. It does not match connections from
localhost (using the UNIX domain socket) if you have an anonymous
account for localhost.
"A very common error is to insert a new entry with Host='%' and
User='some_user', thinking that this allows you to specify localhost
to connect from the same machine. The reason that this does not work
is that the default privileges include an entry with Host='localhost'
and User=''. Because that entry has a Host value 'localhost' that is
more specific than '%', it is used in preference to the new entry when
connecting from localhost! The correct procedure is to insert a second
entry with Host='localhost' and User='some_user', or to delete the
entry with Host='localhost' and User=''."
Axel Schwenke, Support Engineer, MySQL AB
Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/