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
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 data
[EMAIL PROTECTED]
Subject: Re: mysql remote access on
linux
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 PROT
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 e
Mark,
That's not really that way you work with RDBS engines. It's not a desktop
database like Access or FoxPro. (mmFox Pro!)
What is the problem you are trying to solve? Is the remote connection too
slow?
You can always use mysqldump to create a MySQL script that will rebuild the
datab