Connecting MySQL from other website..

helmz

Is there a way one can connect to MySQL database which is located on other website? e.g www.mysite.com wants to connect to database in www.myothersite.com

richie

I believe what you have to do is create a user that can connect from locations other than localhost.

Here are some examples:

Give username full access to all tables from localhost:

grant all on . to 'username'@'localhost' identified by 'password';

Give username full access to all tables from example.com:

grant all on . to 'username'@'example.com' identified by 'password';

Give username full access to all tables from any hostname:

grant all on . to 'username'@'%' identified by 'password';

You can also use ip or network addresses.

cheese

Hi Helmz,

Have a look at this thread as well, it might help.

Cheers,

Neil.

helmz

Thanks Richie & Cheese. As Mike said on the other thread:

yes, you can supply any server you want to mysql_connect(). be advised that some commercial hosting companies (like mine) do not allow remote database connections, meaning you can only connect to their database server from their webserver.

Maybe that's the problem with me, I've tried everyway but can't make connection. I'll paste the email I got from the freehost where my database is, here:

username: myusername
password: password
database name: dbname
database host: freeownhost.com
database port: 5555

now can anyone write me the mysql_connect() using the above data? BTW what's the role of Port?

cheese

Hi Helmz,

Tell you what, email me the code and I will put it on my server and try and access from here, if it will help.

My email address is in my profile.

Regards,

Neil.