Re: Access to Table from any Host on Internet

2002-07-05 Thread Ron Parker
GRANT SELECT ON DB.TABLE TO serf@'%' IDENTIFIED BY 'readonly'; I did "flush privileges", but still can't acess DB.TABLE with 'serf' unless I use GRANT statement that includes hostname of client from which I am executing command. I get this error using "serf@'%'": * connect() SQLException: ja

Re: Access to Table from any Host on Internet

2002-07-05 Thread Gelu Gogancea
Hi, After every modification in mysql.user table you must do: "FLUSH PRIVILEGES;" Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Me