GRANT [ALL PRIVILEGES|Appropriate Privileges] *.* TO root@'192.168.1.50' IDENTIFIED BY '<password>' WITH GRANT OPTION;
Or if you want a root user from a subnet GRANT [ALL PRIVILEGES|Appropriate Privileges]ON *.* TO root@'192.168.1.%' IDENTIFIED BY '<password>' WITH GRANT OPTION; http://dev.mysql.com/doc/refman/5.0/en/grant.html -----Original Message----- From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2008 10:17 AM To: mysql@lists.mysql.com Subject: grant user hi all, i have a user that can only access localhost, how do i grant this user permission so that can also be accessed from 192.168.1.50? thanks t. hiep -- 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]
