Jump to content

Archived

This topic is now archived and is closed to further replies.

jawinn

Can't Use PHP to create table in MySQL

Recommended Posts

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.

Share this post


Link to post
Share on other sites
I don't know how much help I can be -- you don't seem to have the right credentials.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
You do not have the required permissions to access the database dbname_dbname

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.