How to enable PHP and MYSQL to work with other computers in a LAN
Posted on 2013-11-23
I have the following situation:
1. A Windows 2008 server with APP Serv (MYSQL and PHP) installed on it.
2. Inside that server there is a virtualized Fedora 18 by VMWare.
3. The IP of windows server is 192.168.1.1 and for Fedora is 192.168.1.2
So the situation is that we want to connect to MYSQL server of Fedora from Windows Server or even any other computer that develop web applications using PHP.
The problem by now is that during a debug of PHP application which tries to connect to Fedora's MYSQL Server we got the following error:
Warning: mysql_connect() [function.mysql-connect]: Host 'winserver' is not allowed to connect to this MySQL server in C:\AppServ\www\myphpapp\conns\db.php on line 13
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\AppServ\www\myphpapp\conns\db.php on line 15
Host 'winserver' is not allowed to connect to this MySQL server
Any ideas guys?