permissions - Does mysql require two users in the users table for local and remote access? -
i noticed in our databases there 2 copies of every user, 1 "from host" set % , other "from host" set localhost. necessary? seems can cause confusion have different set of permissions user depending on it's coming from.
it seems odd % wouldn't match localhost.
from host@%
allow access locations. from host@localhost
allow access localhost.
just check this: http://dev.mysql.com/doc/refman/5.1/en/connection-access.html
Comments
Post a Comment