Help me with Error

Antonio878 · #1 07-19-2008, 08:53 PM

I want to create a database from my site, and i have the php code for it.

PHP Code:

  <?php$con = mysql_connect("localhost","***","****");
if (!$con)  {  die('Could not connect: ' . mysql_error());
  }if (mysql_query("CREATE DATABASE ***_officer",$con))
  {  
echo "Database created";
  }
else 
 {
  echo "Error creating database: " . mysql_error();
  }mysql_close($con);
?>

everytime i try and create the database by using this code, it always saysError creating database: Access denied for user '***'@'localhost' to database 'oieieais_officer'Account Id (server name) Voda22 can anyone help me, please?

navaldesign · #2 07-19-2008, 10:08 PM

In VH you can NOT create a database from script. You need to create the Database through your CP. After that you can create the necessary tables using a script.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)