Though it's in the manual, you may want to do something like this:
GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'
Of course, you'll want to replace:
- ALL with access privelages that are much safer (assuming you don't completely trust the remote user).
- database with the database that you are actually giving remote access to
- user with the username you want to assign
- domain with the IP address the remote user will be connecting from (or their host and domain name)
- password with the password they'll be using.
I'd point you at this link for more info: http://www.mysql.com/doc/en/GRANT.html
Take care,
Dylan
On Saturday, August 2, 2003, at 11:55 AM, Mary Grace wrote:
I have been using MySQL for awhile, and for the first time someone from outside our portable /16 needs access to some tables. We have given them the server IP address, the dB name, the port 3306, the root username, and the password, but they still can't get access. Of course, no firewalls or other things in the way.
Is it true that MySQL defaults to local access only, and to enable remote access you must do something unusual with grants? If so, how would I do this? (warning, we use the win version, but this question is not a windows-only thing so it is topical for this list:-)
Thanks in advance for reading a post like this with such a dumb question!
Mary Grace
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
