I'm fairly new to Wordpress and looking for some help.
Goal: I would like to stream data from my personal computer's Mysql database and display it on a webpage in my offsite Wordpress hosted site. ie. an updated inventory as items are sold.
I am using windows 7 on my personal computer and have already created a user in my database with the appropriate privileges, I also added "%" to allow the connection from any ip. (I understand the security risks, I am just trying to make connection at this time) I am able to connect to my database as this new user locally, and last but not least I have opened firewall and router ports to get this connection working.
My problem is that when I try to connect to my pc from my website ie.
$con = mysql_connect( 'my.ip,xx,xxx', 'user_name', 'password' );
$db = mysql_select_db( 'database_name' ) or die("cannot connect php3");
I get the cannot connect error displayed on my page.
I should also mention that I am using a plugin called "Allow PHP in posts" which I use for my code.
I have searched the internet to find solutions with no success. I'm guessing there is something special about doing this with wordpress because nothing seems to be working.
Any help would be GREATLY appreciated. If it would be easier to Skype me let me know and we can talk.
Thanks