Access Database of Other domain

[abhi10kumar]

I have a website plus database with details like username, password and database name. Now I want to connect and use this database into another website. I tried to include, for example

include('http://domainname.com/connect/db.php');

but unable to run query. How I can do this ?

[urtrivedi]

to access another server mysql data, you need to have permission to do so in mysql. If you know administrator you can ask him to allow access to the server.

This might be tricky...

http://forums.cpanel.net/f354/can-domain-communicate-database-another-account-186692.html

[urtrivedi]

when you buy any server space, they alwyas provide all 4 parameter like servername , database name, username and password for mysql.

so where is database server, ask them to provide the info. or if u can login to there system. you may find such information somewhere in ur account

[abhi10kumar]

I have cPanel login details.. How I can find database server.. ?

[urtrivedi]

http://x3demob.cpx3demo.com:2082/frontend/x3/index.html?post_login=67057016356023
Here you can see cpanel demo,
In database section click remote mysql

http://x3demob.cpx3demo.com:2082/frontend/x3/sql/managehost.html

Here you can see you can allow IP OF your server to access cpanel mysql db

[abhi10kumar]

The links are asking login details..

[urtrivedi]

no
it is cpanel demo
same way when you login to your cpanel account u find same databae section
on left side you can see "server"
then you have to create users for your mysql database, you have to give privilleages to your user to your database. (this username/pwd/database can be used to login to mysql database)

to allow remote access to mysql you need to give remote (your static ip address if you have)