Hi try running
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'pass'; where 'hostname' is the one in the error message HTH Peter -----Original Message----- From: Louis van der Merwe [mailto:[EMAIL PROTECTED] Sent: 02 December 2003 15:01 To: [EMAIL PROTECTED] Subject: mysql remote access on linux Hi, Can someone please tell me how to set up a linux mysql server to accept connections from remote machines. I have tried creating users for all of the remote host, and creating users with host '%' and '*', everytime I try to connect using myodbc or mysqlcc, I get the error "host {host name} is not allowed to connect to this mysql server" I really need to resolve this problem soon. Why don't I get the same error when running mysql on windows ? Thanks Louis -- 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]