Re: Connecting to remote MySQL server.. nevermind!

2002-09-20 Thread MySQL
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) From: "Richard Fox" <[EMAIL PROTECTED]> Date: Fri, 20 Sep 2002 11:19:37 -0400 X-Priority: 3 X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. News-Group: list.mysql

Re: Connecting to remote MySQL server

2002-09-20 Thread Nestor Florez
IT is working as of yesterday. The problem was that I was granting select, insert, update privileges to the webuser and the change would not appear in the user table of the mysql database. Learn a new one yesterday. I try changing the privileges using the GRANT on an existing user and they do

Re: Connecting to remote MySQL server

2002-09-20 Thread Clayburn W. Juniel, III
On Friday, September 20, 2002, at 08:09 AM, Richard Fox wrote: > Hi, > > I am on the machine 192.168.0 230, and I am trying to connect to the > server > on 192.168.0.10. > >> mysql -h 192.168.0.10 -u username -p > > I get back > >> ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (11

Re: Connecting to remote MySQL server.. nevermind!

2002-09-20 Thread Richard Fox
Ha ha, I changed the remote permissions for the user to 'any host' and now it works. Doh! sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Connecting to remote MySQL server

2002-09-20 Thread Richard Fox
Hi, I am on the machine 192.168.0 230, and I am trying to connect to the server on 192.168.0.10. >mysql -h 192.168.0.10 -u username -p I get back >ERROR 2003: Can't connect to MySQL server on '192.168.0.10' (111) OK, so I tried to connect to the local server >mysql -h 192.168.0.230 -u userna