Is it possible to connect to a remote databse?
Ie... Running a PHP script on my computer, and connect to the databse on the server from the script?
Thanks
David
MySQL Remote Connection
Moderator: General Moderators
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Re: MySQL Remote Connection
Yes. You just put the first argument of mysql_connect() as the IP or qualified domain name of the remote serverdwessell wrote:Is it possible to connect to a remote databse?
Ie... Running a PHP script on my computer, and connect to the databse on the server from the script?
Thanks
David
Code: Select all
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'IP/HOSTNAME' IDENTIFIED BY 'password'