Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
make the sql open over LAN
Posted by: natherul (---.tbcn.telia.com)
Date: July 16, 2009 07:02PM

how do i make mysql open for LAN network so i can connect to it from my other computer using sqlyog?

Options: Reply•Quote
Re: make the sql open over LAN
Posted by: sTimulated (---.cable.ubr06.cast.blueyonder.co.uk)
Date: July 16, 2009 07:36PM

If it's on your own LAN have you tried 'remote desktop' ?

Options: Reply•Quote
Re: make the sql open over LAN
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: July 16, 2009 07:57PM

To connect to mysql from your LAN you use the LAN IP address for the computer that has WAMP installed.

You use this IP Address as the hostname for MySQL.

Options: Reply•Quote
Re: make the sql open over LAN
Posted by: natherul (---.tbcn.telia.com)
Date: July 16, 2009 08:16PM

well dont i have to do some settings in the sql to make it possible?

Options: Reply•Quote
Re: make the sql open over LAN
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: July 16, 2009 08:36PM

You will need to add a new mysql user for your lan IP address.

To do so open phpMyAdmin click privileges tab. Click the Add User link.

Fill in the Login Information field. For the Host. Select the option labelled as Use Text field. Now type in your computers lan address in the text box.

Scroll down to the Global privileges form. Click the choose all link (or select the ones you want to assign to the user). Now click go button.

When connecting to MySQL from your remote computer. Use the details you just setup.

Options: Reply•Quote
Re: make the sql open over LAN
Posted by: natherul (---.tbcn.telia.com)
Date: July 16, 2009 09:06PM

well i never got phpmyadmin to work since i dont know how to set it up (its failing to connect to the database since it tries to login with no pass while i have a pass

EDIT: when i installed i added a password to the root user... also changing the C:\wamp\apps\phpmyadmin3.1.3.1/config.inc.php
$cfg['Servers'][$i]['password'] = '';

to the pass i use does not help, it still sais:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)



Edited 1 time(s). Last edit at 07/16/2009 09:15PM by natherul.

Options: Reply•Quote
Re: make the sql open over LAN
Posted by: yfastud (Moderator)
Date: July 16, 2009 09:33PM

download resetmysql here
[downloads.jlbn.net]

to setup password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: Reply•Quote
Re: make the sql open over LAN
Posted by: natherul (---.tbcn.telia.com)
Date: July 16, 2009 09:40PM

heh after changing the file from config.inc.php to config.php it worked but adding a new user as you said c2dan does not work and since my other comp sais cant connect to MySQL server on '192.168.0.102' (10060) something tells me that the database itself is not available atm over the LAN.... so its a setting in the MySQL somewhere but i dont know anything about that...

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login