mysql user를 만들고 패스워드도 주었는데 자꾸 패스워드 없이 로그인되길래...
http://dev.mysql.com/doc/refman/5.5/en/access-denied.html
If you cannot figure out why you get Access
denied, remove from the user
table all entries that have Host values
containing wildcards (entries that contain
'%' or '_' characters).
A very common error is to insert a new entry with
Host='%' and
User=',
thinking that this enables you to specify
some_user'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=',
or to delete the entry with
some_user'Host='localhost' and
User=''. After deleting
the entry, remember to issue a
FLUSH
PRIVILEGES statement to reload the grant tables. See
also Section 5.4.4, “Access Control, Stage 1: Connection Verification”.
댓글 없음:
댓글 쓰기