Use PHP to Create Database

I am trying to use PHP to create a mySQL database. I can create it using cPanel. I enter the name of the database in the input box and cPanel automatically prepends my account name. So if I enter “my_db”, cPanel creates a database with the name of account_name_my_db.

Here is my code:

[code=php]
<?php

$dbServer = “mysql”;
$dbHostname = “localhost”;
$dbUsername = “account_name”;
$dbPassword = “abc1234”;
$dbName = “account_name_a10000”;

$link = mysql_connect($dbHostname, $dbUsername, $dbPassword);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
} else {

echo “<br>connected<br><br>”;
}

$sql = ‘CREATE DATABASE account_name_my_db’;
if (mysql_query($sql, $link)) {
echo “Database account_name_my_db created successfullyn”;
} else {
echo ‘Error creating database: ‘ . mysql_error() . “n”;
}

$sql = ‘CREATE DATABASE my_db’;
if (mysql_query($sql, $link)) {
echo “<br><br>Database my_db created successfullyn”;
} else {
echo ‘<br><br>Error creating database: ‘ . mysql_error() . “n”;
}

?>
[/code]

His what I ge when I run this code:

[code=html]
connected

Error creating database: Access denied for user ‘account_name’@’localhost’ to database ‘account_name_my_db’

Error creating database: Access denied for user ‘account_name’@’localhost’ to database ‘my_db’
[/code]

Why doesn’t this code work…?

.

Also in #PHP _↴