Terry, mysql>>GRANT ALL ON Security.* to [EMAIL PROTECTED] Identified by > 'password'; > Query OK, 0 rows affected(0,00 sec)
Try to rewrite that as follows: GRANT ALL ON Security.* TO 'newbuddy'@'network.srv' ... The dot in "network.srv" could otherwise cause problems. After granting, do: SHOW GRANTS FOR 'newbuddy'@'network.srv'; If "newbuddy" still isn't granted access, you should check your DNS. Alternatively, you could also issue the following, which should work in any case (even if your DNS isn't set up correctly): GRANT ALL ON Security.* TO 'newbuddy'@'192.111.111.111' ... Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
