phpMyAdmin shared access
Posted by: davids (---.79-161-170.customer.lyse.net)
Date: February 24, 2010 07:14PM

Hi,

I have password protected my phpMyadmin so that you need to authenticate with Apache Password to get access. The database works fine on localhost, however, I want to access the database from another computer.

mysql_connect ('192.168.0.197', 'root, 'mysql_pw');

gives me an connection error. The IP is the computer's IP where the wamp installation is. How can i set phpmyadmin to allow external database connections?

I have added the external computer to the users table in the "mysql" database with "all privileges".
I have checked that MySQL listens to port 3306, and opened this on the host computer.
TCP connections are allowed by MySQL.

So ... when I have done everything by the books.. what's wrong?



Edited 1 time(s). Last edit at 02/24/2010 07:47PM by davids.

Options: ReplyQuote
Re: phpMyAdmin shared access
Posted by: davids (---.79-161-170.customer.lyse.net)
Date: February 24, 2010 07:59PM

Fixed this my adding 3306 as an exception to the windows firewall.

Options: ReplyQuote


Sorry, only registered users may post in this forum.