I have several machines and wander from office to office as part of the job. As I read the MySQL docs, I have two choices for granting privileges:
grant ... to randy@'%' or grant ... to [EMAIL PROTECTED]
The first form is too vulnerable for the folks around here. The second form is too restrictive for me. Will this work?
grant ... to randy@'%.host.name'
According to the manual, yes:
http://www.mysql.com/doc/en/GRANT.html
You can also use wildcards with IP addresses, which may be useful if you want to specify all the machines on a particular subnet.
In other words, I can be on any machine, as long as it's on our network. I'd try it myself but two machines are in the garage and I'm not going anywhere for the next couple of days.
Thanks.
Randy
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
