My sql connection string suggestion!

[naga harish]

Hi,

First I would like to say thanks to x10hosting.

And my suggestion is please add sample connection string for my sql data base. It new to my sql. I just thing of database host! finaly I added localhost as database host. if sample database connection is provided, then it will be helpfull to users. I feel!!!

Thanks.

 

[techairlines]

Are you looking for a way to test the connection?

To test the connection, create a database in cPanel and the database user/pass. Then create a new PHP file with the following code:

<?php
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("test") or die(mysql_error());
echo "Connected to Database";
?>

Replace admin with your database user.
Replace 1admin with your database password.
Replace test with your database name.

Keep all quotes in place.

If all goes well, it should display both Connected to MySQL and Connected to Database.

Source: http://www.tizag.com/mysqlTutorial/mysqlconnection.php

 

[henderson791]

It is really a great site.Thanks for your positive comments

---------------------------------------------
Wine Investment
Fine Wine Investment

 

[naga harish]

Are you looking for a way to test the connection?

To test the connection, create a database in cPanel and the database user/pass. Then create a new PHP file with the following code:

<?php
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("test") or die(mysql_error());
echo "Connected to Database";
?>

Replace admin with your database user.
Replace 1admin with your database password.
Replace test with your database name.

Keep all quotes in place.

If all goes well, it should display both Connected to MySQL and Connected to Database.

Source: http://www.tizag.com/mysqlTutorial/mysqlconnection.php

Thanks for you reply. It is working form me