Skip to main content

Remotely accessing web server, and connecting to local mysql (via php)



I am trying to connect to my local mysql server via php. so my code looks as follows:







$con = mysql_connect("localhost", "user", "password");

mysql_select_db("database", $con) or die('ERROR 4');







ok, we've all seen that before.





So when I run this PHP script on the machine with the mysql database, everything runs fine. But once I access this script remotely (on the server, with the local mysql database) it cannot connect to the database.





Is there any way to make it so the PHP code connects to the mysql database via a local reference? Or do I need to look into connecting to the mysql database through an IP address?





edit: To clarify, when I access the script on the server from somewhere else, it doesn't work





edit 2: When I check the error log it states "Call to undefined function mysql_connect()"


Comments

Popular posts from this blog

Slow Android emulator

I have a 2.67 GHz Celeron processor, 1.21 GB of RAM on a x86 Windows XP Professional machine. My understanding is that the Android emulator should start fairly quickly on such a machine, but for me it does not. I have followed all instructions in setting up the IDE, SDKs, JDKs and such and have had some success in staring the emulator quickly but is very particulary. How can I, if possible, fix this problem?