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]
