Apache Friends Support Forum

I am running apache and mysql 5.0 on my laptop. The ip address for my laptop is 182.158.0.127. I've tested and have made sure the mysql server is running on my laptop.

I want to access the mysql database (on my laptop) from my desktop that is connected to my laptop via a LAN. The address to my laptop over the LAN is \\FRANKLAPTOP.

Using ipconfig, I can see that the ip address for my laptop is 182.158.0.127

When I configure the mysql ODBC connector, I use 182.158.0.127 as the server name, but his does not seem to work as when I test the connection via the "test" button on the ODBC connector, I get the following message: "Request returned with SQL_ERROR"

I have also tried;
\\182.158.0.127
\\182.158.0.127:3306
\\182.158.0.127/localhost
\\FRANKLAPTOP

I have also tried all the above but used forward slashes //

What am I doing wrong?

Thanks

Frank

Windows Firewall running on the Laptop?

glitzi

And can you access the web pages on your laptop? Try that first to make sure that a port isn't blocked and that you have the correct address for it.

dmphotography wrote:And can you access the web pages on your laptop? Try that first to make sure that a port isn't blocked and that you have the correct address for it.

He has problems with MySQL, not with the Apache. Even if Websites are working, that only verfies that port 80 is not blocked. But we are talking about Port 3306 here.

glitzi

Problem solved as soon as I opened port 3306 in Windows Firewall on the host computer.

Thanks

glitzi85 wrote:

dmphotography wrote:And can you access the web pages on your laptop? Try that first to make sure that a port isn't blocked and that you have the correct address for it.

He has problems with MySQL, not with the Apache. Even if Websites are working, that only verfies that port 80 is not blocked. But we are talking about Port 3306 here.

glitzi

Right, but my point was to verify the IP by trying to connect to the web pages. Always start with the simplest. If it connects at one point, then that narrows it down quite a bit.