can not connect to database

[dskamburapola15]

i tried to connect database from my web page with following code.

$host=\"localhost\";
$username=\"dsk123_test\";
$password=\"789\";
$db_name=\"dsk123_dsk\";

mysql_connect(\"$host\", \"$username\", \"$password\")or die(\"cannot connect to server\");
echo \"Host - Connected - OK <br><br>\";
mysql_select_db(\"$db_name\")or die(\"cannot select DB\");
echo \"Database - Connected - OK <br><br>\";

It display following messages.

Host - Connected - OK

cannot select DB

How to fix this.

 

[descalzo]

$link = mysql_connect("$host", "$username", "$password")or die("cannot connect to server"); 
echo "Host - Connected - OK <br><br>";
mysql_select_db("$db_name" , $link )or die("cannot select DB. Reason: " . mysql_error( $link ));
echo "Database - Connected - OK <br><br>";

Try the above edits to your code.
Always check the error message given by the DB .

You did remember to connect the specific user to the specific database in MySQL Databases and to give it ALL PRIVILIGES ?

 

[dskamburapola15]

thanks. I tried your code.
But I got following error.

cannot select DB. Reason: Access denied for user 'dsk123_test'@'10.33.248.%' to database 'dsk123_dsk'

what to do.

 

[stpvoice]

Hello,

Did you add the user to the database as descalzo said before?
Are you trying to connect from a file on your x10 account?

Thanks.

 

[dskamburapola15]

Hello,

Did you add the user to the database as descalzo said before?
Are you trying to connect from a file on your x10 account?

Thanks.

how to give privileges to user. there is no privileges tab in phpMyAdmin

 

[stpvoice]

Hello,

Please see this page: http://x10hosting.com/wiki/How_to_Create_a_MySQL_Database_and_User
Scroll down to "Creating only a user" and "Adding a user to a database".

Thanks.