MySQL Server on Home Machine
Posted: Sat Jul 02, 2005 12:24 pm
I have a mysql and php running on apache on my home computer. Everything works fine and is setup correctly.
I also have a site hosted on servers running php and mysql.
I have a script that connects to a mysql database server and creates a database. it runs fine on both servers.
The problem is trying to connect to my home mysql server from my hosted site on the net. I understand i can't connect to my hosted server from home as my hosting provider does not allow it.
BUT!!how could i connect to my mysql server on my home computer from my web hosted site.
would i connect using my web facing i.p address?
(that can be found using http://www.whatismyip.com/)
when i try to connect using this i.p it returns an error saying:
mysql_connect(): Access denied for user 'root'@'server218-iis641.livedns.org.uk' (using password: YES)
what am i doing wrong, is server218...etc the dns server?
why is access denied i'm sure the password is correct?
i guess it is actually trying to connect to the correct server, but why is access denied?
thanks for any help.
I also have a site hosted on servers running php and mysql.
I have a script that connects to a mysql database server and creates a database. it runs fine on both servers.
The problem is trying to connect to my home mysql server from my hosted site on the net. I understand i can't connect to my hosted server from home as my hosting provider does not allow it.
BUT!!how could i connect to my mysql server on my home computer from my web hosted site.
would i connect using my web facing i.p address?
(that can be found using http://www.whatismyip.com/)
when i try to connect using this i.p it returns an error saying:
mysql_connect(): Access denied for user 'root'@'server218-iis641.livedns.org.uk' (using password: YES)
what am i doing wrong, is server218...etc the dns server?
why is access denied i'm sure the password is correct?
i guess it is actually trying to connect to the correct server, but why is access denied?
thanks for any help.