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]
