Hi, Hi, my domain is hosted on godaddy server. I am trying to retrieve data for my site from mysql database which is on another server. Godaddy doesnt allow this? I have entered the IP adddress(of other server i want to connect), database name(of database on other server i want to connect), user and password(of database on other server i want to connect) in my mysql connection php script(uploaded in godaddy server) to connect to mysql database on that other server(also that other server allow remote access and it is enabled as I enabled it) but the script dont retrieve data from that server. Is that godaddy dont allow this or I am doing some mistake?
Are you able to connect to the database? If not, then the error message should give you hint of what's wrong.
Remote access to shared hosting MySQL databases are not allowed for security reasons. 1and1 clearly explains this on their MySQL database setup page and I'm sure it's the same case for GoDaddy. If you need further explanation, you are blocked via GoDaddy's firewall and for good reason.