Thanks for the pointers. We can connect from the Linux box to my PC so we're convinced the network is not an issue, but still cannot connect from my PC to the new MySQL server installed on the Linux box. When we monitor the packets coming in we can see the request to connect and to MySQL at port 3306 followed by the request for an ICMP ping instead of the expected ACK. The ports are enabled in the etc/services file so we're at a loss. Is there a setting to allow remote connections in Linux?
Still lost:-| Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 3:30 PM To: Bartis, Robert M (Bob) Cc: [EMAIL PROTECTED] Subject: Re: Unable to connect to DB Check to make sure the linux box has its port open (do a MySQL "ping"). >From the windows box, telnet to your linux box on port 3306 (or whatever you set your linux server to listen on in your my.cnf file) you should see the version# of the server and a bunch of non-text information. If that fails, your linux box is not listening. Change your server's config file to open a port. Another issue about mixing platforms.... if you are trying to access your MySQL server through the ODBC driver (the most current version I can find is 3.x) and your server is version 4.1 or better, you will have to downgrade your password. Log into the MySQL with admin permissions (root) and run this command: update mysql.user set password=old_password('<your ODBC pwd here>') where user = '<your ODBC user name here>'; Also, make sure you have GRANT-ed the appropriate permission for your user acct to the new tables. HTH, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Bartis, Robert M (Bob)" To: [EMAIL PROTECTED] <[EMAIL PROTECTED] cc: m> Fax to: Subject: Unable to connect to DB 06/11/2004 03:19 PM I have been using a local copy of the current production version of MySQL in a windows environment while we evaluate porting a MS Access front-end to make use of MySQL. We are ready to go prime-time within my team and as part of this exercise installed a LINIX version of MySQL on another machine. We can create a DB, import files etc, etc while on the local LINIX box, but are unable to connect via a remote machine. Any suggestions on how to debug this issue? Networking is not an issue as we can ping the machine. Thanks in advance for you help Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
