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”.
댓글 없음:
댓글 쓰기