RE: Connect to Database over the Internet

2002-09-18 Thread Bryan
EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:49 AM To: 'Bryan'; [EMAIL PROTECTED] Subject: RE: Connect to Database over the Internet Bryan, Hi! Did you specify --skip-networking in my.cnf? Check if MySQL is listening on port 3306 (or the port you specified) for TCP connec

RE: Connect to Database over the Internet

2002-09-18 Thread Mike Hillyer
Hi Bryan; First I would direct you to the MyODBC mailing list, as it is generally the place where we VB programmers converse. At any rate, you need MyODBC installed (check the products heading of the MySQL web site for the MyODBC download), and your connection string is wrong. I would detail it,

RE: Connect to Database over the Internet

2002-09-18 Thread Jindo
Bryan, Hi! Did you specify --skip-networking in my.cnf? Check if MySQL is listening on port 3306 (or the port you specified) for TCP connections. Also, I highly suspect that you forgot to set the proper privilege for connections made from hosts other than localhost. SELECT * FROM mysql.user sh