how to connect to database server that isnt on 'localhost'

jumphopper

how to connect to database server that isnt on 'localhost'.

are you suppose to replace 'localhost' with the ip address?
i keep on getting a 'connect to error. could not find/connect to database'.

thanks in advance for your replies.

jumphopper

Doug_G

What kind of database?

I connect to my remotely hosted mysql server by the url of the server, but the IP address also works. The default mysql server port is 3306 and that must be open through any firewalls.

Use a tool like MySQLAdministrator to verify the connection from the computer that will be running your PHP code, it's easier to work out connection problems that way.

jumphopper

How can i configure the port?
i am using phpmyadmin server btw.

jumphopper

i keep getting this msg
"Could not connect to database Lost connection to MySQL server during query"

Doug_G

Best I can offer is to check with your network admin. There mysql port must be open from the computer running phpmyadmin.

justsomeone

Your mysql connection string contains a selection from 5 parameters

server identifier ("localhost", IP address, url, etc)
port number (not required, most mysql installs use the default)
username
password
database name

You just need to replace the "localhost" with the address (IP/URL etc) of the remote server.

Rule out any PHP confusion and try connecting to the mysql server from the command line
"mysql - h 123.123.123.123 -u username -p databasename"
(if I recall correctly)

(Replacing 123.123.123.123, username and databasename with your details)

This will prompt you for the password and should let you in.

If not, see what error you get, and check with your sysadmin.

thread_PHP

give the ip address of the machine and mysql username and password along with