Can't Use PHP to create table in MySQL

[jawinn]

I'm trying to connect to a Godaddy MySQL DB using PHP. This is not a remote connection. This is on a shared account. Here is the code I'm trying to use. I have to be missing something.

<?php

// set your infomation.
$hostname='server.servername.net';
$username='name';
$password='password';
$dbname='dbname';

// connect to the mysql database server.
$link_id = mysql_connect ($hostname, $username, $password);
echo "success in database connection.";

// select the specific database name we want to access.
$dbname=$username."_".$dbname;
if (!mysql_select_db($dbname)) die(mysql_error());
echo "success in database selection.";

// add a table to the selected database
$result="CREATE TABLE address_book (first_name VARCHAR(25), last_name VARCHAR(25), phone_number VARCHAR(15))";
if (mysql_query($result)){
echo "success in table creation.";
} else {
echo "no table created.";
}

?>

I keep getting in the browser:
success in database connection.Access denied for user: 'name@%' to database 'dbname_dbname'

Any help is much appreciated.

[fenway]

I don't know how much help I can be -- you don't seem to have the right credentials.

[nickholt1972]

I think this line is causing you problems, I can't see the point of it. All it seems to do is to take your database connection name and screw it up.

$dbname=$username."_".$dbname;

My advice is to delete this line completely.

[Daniel0]

You do not have the required permissions to access the database dbname_dbname

[jawinn]

Thanks for the quick responses guys.  It turns out that I was confusing my DB name for the table name.  I was using the DB name for both.