Connecting to MySQL

webinfo

Wondering if it is possible to include the host name in the PHP connect string?

Using telnet at a DOS command prompt, I log into Apache. I then log into MySQL using:

Ex 1:

mysql -u username -h db-mysql -p

When connecting to MySQL in a PHP script I use:

Ex 2:
mysql_connect("webstart.site.ca", "username", "password") or exit();
mysql_select_db("username")

There is no place in the mysql_connect funtion in Ex 2 to write the mysql host (db-mysql). Should this matter?

The mysql host (db-mysql) is different from the host in the URI (webstart). Is this allowed?

Jim

bogu

Is this webstart.site.ca your mysql server or your web domain?

liquorvicar

Telnet? Are you sure you want to be using telnet? Exactly what are you trying to do. If you're logging in to a remote server you should realy be using SSH.

But in answer to your question, when using mysql_connect the first parameter should be the hostname (or IP address) of your DB server. Thus if your DB server is at db-mysql.site.ca then

mysql_connect("db-mysql.site.ca", "username", "password") or exit();
mysql_select_db("db_name")

(You also had "username" as the parameter for mysql_select_db. I assume this was a typo and have corrected it).

webinfo

Problem fixed. Turns out I shoudl have been using

mysql_connect("db-mysql", "username", "password")