php n mysql

[bangla]

<?php
$con = mysql_connect("bangla123.db.8390659.hostedresource.com","bangla123","Algnab123%");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE tryDB",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

mysql_close($con);
?>

------------
When I run the code, i get error -"Error creating database:....

Pls advise.

Thx.

[chrishea]

Please use code tags when you include code.
Don't include your Database id and pw for your own protection.
Some web hosts don't allow you to create databases dynamically. You have to use their control panel / PHPMyAdmin. If that isn't a problem, then double-check that your db info is accurate.

[the_traveller]

Plz type the full mysql_error msg

[bangla]

Error creating database: Access denied for user 'bangla765'@'%' to database 'hh'

[divyakrishnan]

This means that your user account does not have the necessary privileges to create a database.Contact the administrator.Try to create the database using phpMyadmin or SQL YOG.