Louis van der Merwe wrote:
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
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
]
Subject: Re: mysql remote access on
linux
12/02/2003 10:14
On Tue, 2 Dec 2003 10:17:24 -0500 [EMAIL PROTECTED] wrote:
You should not need to restart , you will need to 'flush privileges'
though. has that been done?
I was under the impression that the latest versions don't even need
'flush privileges' anymore, that any modifications to the mysql
from what I've read in the docs, if you use 'grant' you don't have to flush, but if
you insert into user tables directly, you do
-Original Message-
From: Skippy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 11:56 AM
To: [EMAIL PROTECTED]
Subject: Re: mysql remote