Connecting to a mySQL database remotely via PHP

Volte6

Is there ANY way to set up a php script to access a mySQL database remotely?
For certain reasons I would like to run a maintenance script from my personal computer at home occasionally, and have the main database accessed located on the web site located on a web host.

Is the only way to connect via PHP with localhost?

Is there a way I could rig it to pass a query and have it connect according to the query entered, and pass the resulting array as though I had just done it locally?

PLEASE help, I'm doing this ideally to keep a cheap server running on the internet, but the time/resource intensive stuff running from home when needed.

Thanks!

cdxrevvved

I dont see why you couldnt.. you should just be able to replace localhost with the address of your mysql server, and the user pass and it should work fine.. Ive done similiar things in the past

phence

ya i am having trouble connection to a remote mysql datadase as well.

i can't seem to connect. i have tried used the servers ip address.. no luck! 🙁 !!

Please help

diego25

Make sure that your account is allowed access from any location. For security reasons, sometimes database administrators only allow people from localhost to connect.

Diego

cdxrevvved

good point diego.. I guess I should mention that I was running my own copy of mysql off my local pc, and the website hosted somewhere else had full access.. but again, probably because I was hosting the mysql server myself..

Volte6

Thank you, I will research and experiment with this further.

All google results pointed to only allowing 'localhost'.
If I can specify otherwise, this pleases me to no end...

diego25

It does allow you to specify anything. In the MySQL documentation, look for the GRANT command.

Diego

phence

As root in mysql, type:

grant all on DATABASE. to 'USERNAME@'

replace "DATABASE" with database name
replace "USERNAME" with mysql user

The above grants premission to connect remotely to the specified database and user.

Hope it's Helpful!!

diego25

I'm not sure about this:

'USERNAME@*'

I remember using

'USERNAME@%'

instead...maybe we can use both? I dunno...

Diego

Volte6

Wow, great information! Thanks!