Use GRANT ___your_permissions____ on database[s] to 'username'@'%' IDENTIFIED BY 'his/her password'
% will be used if you don't want to restrict that user on a given host or network Otherwise, use 'username'@'host_name_or_ip_address' like 'emery'@'192.168.0.50' if you omit the @ part, MySQL will add 'locahost' for you. Like 'emery'@'localhost' Hope this helps. Thanks Emeyr ----- Original Message ----- From: "m i l e s" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 28, 2003 20:12 Subject: MySQL users. > Hi > > Im a more than a lil confused about how to set up multiple > users for EXTERNAL access to MySQL. > > Ive granted permissions to the Local user, but how to I grant permissions > to external users ? > > Sincerely, > > -- > M i l e s > > President & Toolbox Architect > MagicMiles Software > (413) 374 - 5161 > PO Box 414, Northampton, MA 01060 > > http://www.servicetoolbox.com/ > http://www.workshoptoolbox.com/ > http://www.healingartstoolbox.com/ > http://www.artshoptoolbox.com/ > > We create content management systems for > the rest of us, starting at $25.00 a month, > includes domain registration, web hosting, > email and webmail. Great for Yoga Teachers, > Massage Therapists, Lawyers, Doctors, > and any professional! > > -- > 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]
