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

Popular posts from this blog

windows - Single EXE to Install Python Standalone Executable for Easy Distribution -

c# - Access objects in UserControl from MainWindow in WPF -

javascript - How to name a jQuery function to make a browser's back button work? -