2 messages in com.mysql.lists.win32Re: How to specify connection Ports.| From | Sent On | Attachments |
|---|---|---|
| Chris Moffit | 19 Jul 2001 14:01 | |
| Friedhelm Betz | 19 Jul 2001 15:27 |
| Subject: | Re: How to specify connection Ports. |
|---|---|
| From: | Friedhelm Betz (holl...@gmx.net) |
| Date: | 07/19/2001 03:27:13 PM |
| List: | com.mysql.lists.win32 |
Hallo Chris,
Thursday, July 19, 2001, 11:01:35 PM, you wrote:
Hi all. I am having some problems connecting to a MySQL database on another machine in the local Entrant we have set up. My code is run from a Win Me box, the MySQL is on a Linux red hat box. I am unsure wether I should sent this to the Linux group or this one. Let me know.
I know that I need to specify the port to use and MySQL is supposed to use 3306 (according to what I read). I have included the code and the error for the two situations I tried. If any one either has a good resource or an answer please let me know.
FYI: Everything works great with local host. AHH! On your linuxbox. Code is in PHP.
1. Maybe your linuxbox is not set up in that way to accept connections other from localhost. (--skip-networking?) 2. Maybe in the privilegs-table of MySQL the user is not set up to connect from your ME Box? 3. Your DNS is not properly configured and can't resolve the given IP of your Linux box. Try from console ping 192.168.0.2 and see what happens. 4. TCP/IP installed correctly on ME?
Just a few quick thoughts. I don't think its a problem of the port, but just have a look in your linux config. The port 3306 should be open. Red Hat often installs by default some firewalling and you might check this. HTH Friedhelm