We have a web server where users connect to mysql in scripts, etc., via
the host name localhost. We would also like for them to be able to
manage their databases from their office dekstops with various
utilities. If we grant rights to [EMAIL PROTECTED], they can connect
from the web/mysql server itself but not from other locations as
expected. However, if we grant rights to username@'%', they can connect
from any host other than the web server. To allow connections from any
host (including the web/mysql server, localhost) we have to try and keep
two sets of permissions synchonized for each user, [EMAIL PROTECTED]
and [EMAIL PROTECTED], effectively doubling the number of users we have to manage.
Is there any way to allow connections from both the localhost and any
other host with one set of permissions per user?
Thanks,
Jason Joines
===========
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]