What is the mysql server name

Problems with the Windows version of XAMPP, questions, comments, and anything related.

What is the mysql server name

Postby skibikegolf » 08. January 2009 15:10

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
skibikegolf
 
Posts: 2
Joined: 08. January 2009 14:47

Re: What is the mysql server name

Postby glitzi85 » 08. January 2009 15:51

Windows Firewall running on the Laptop?

glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: What is the mysql server name

Postby dmphotography » 08. January 2009 15:52

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.
For great video and written tutorials and guides on creating your own web server and installing things such as forums, blogs, etc., visit http://myownhomeserver.com
dmphotography
 
Posts: 191
Joined: 15. December 2008 14:25
Location: Columbus, MS
Operating System: Windows 7

Re: What is the mysql server name

Postby glitzi85 » 08. January 2009 15:56

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
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: What is the mysql server name

Postby skibikegolf » 08. January 2009 16:37

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

Thanks
skibikegolf
 
Posts: 2
Joined: 08. January 2009 14:47

Re: What is the mysql server name

Postby dmphotography » 08. January 2009 21:13

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.
For great video and written tutorials and guides on creating your own web server and installing things such as forums, blogs, etc., visit http://myownhomeserver.com
dmphotography
 
Posts: 191
Joined: 15. December 2008 14:25
Location: Columbus, MS
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 39 guests