Thanks for the reply: The only entry in the .ini file is Server=C:/mysql/bin/mysqld-max-nt.exe
I did a telnet xx.xx.xx.xxx 3306 from the remote computer and the conection went through so my computer is accepting from port 3306 This is a dump from SELECT * FROM mysql.user. Does it look right?. I really can't tell if only localhosts have access? Thanks again -----+-----------+------------+-----------------+------------+---------- --+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_ priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+------+------------------+-------------+-------------+----- -------- +-------------+-------------+-----------+-------------+---------------+- -------- -----+-----------+------------+-----------------+------------+---------- --+ | localhost | root | 03f2916825e4a59a | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | +-----------+------+------------------+-------------+-------------+----- -------- +-------------+-------------+-----------+-------------+---------------+- -------- -----+-----------+------------+-----------------+------------+---------- --+ 4 rows in set (0.01 sec) -=Bryan=- -----Original Message----- From: Jindo [mailto:[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 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 should give you the answer. Check if root is only allowed to connect from 127.0.0.1 (localhost) Hope this helps. SolNET Digital Jindo <[EMAIL PROTECTED]> Tel: +886 2 26547645 Fax:+886 2 26515005 Cell: 0922706509 -----Original Message----- From: Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 4:00 PM To: [EMAIL PROTECTED] Subject: Connect to Database over the Internet Hello All: I would appreciate some help on how to configure my application code or the computer which mysql resides on so it can be accesed over the intenet. Putting aside the obvious security concerns how can I achieve this. The application is written in VB using ADO to access the database. Currently this is the connect string I currently use to connect to the database. .ConnectionString = "Data Source = REGIONAL;SERVER=xx.xx.xx.xxx;User ID = root; Password " It works fine connecting to the database when run on the same computer which contains the MYSQL database. When I try the application from a remote computer configured it does not connect. No firewall is involved. I suspect I need to configure certain networking protocols on the host/ server machine, but am lost as to what I should be doing. The operating system is XP professional. Any suggestions. Thanks -=Bryan=- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php