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.
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.
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...