jawinn Posted October 1, 2006 Share Posted October 1, 2006 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. Link to comment https://forums.phpfreaks.com/topic/22677-cant-use-php-to-create-table-in-mysql/ Share on other sites More sharing options...
fenway Posted October 1, 2006 Share Posted October 1, 2006 I don't know how much help I can be -- you don't seem to have the right credentials. Link to comment https://forums.phpfreaks.com/topic/22677-cant-use-php-to-create-table-in-mysql/#findComment-101966 Share on other sites More sharing options...
nickholt1972 Posted October 2, 2006 Share Posted October 2, 2006 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. Link to comment https://forums.phpfreaks.com/topic/22677-cant-use-php-to-create-table-in-mysql/#findComment-102244 Share on other sites More sharing options...
Daniel0 Posted October 2, 2006 Share Posted October 2, 2006 You do not have the required permissions to access the database dbname_dbname Link to comment https://forums.phpfreaks.com/topic/22677-cant-use-php-to-create-table-in-mysql/#findComment-102415 Share on other sites More sharing options...
jawinn Posted October 2, 2006 Author Share Posted October 2, 2006 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. Link to comment https://forums.phpfreaks.com/topic/22677-cant-use-php-to-create-table-in-mysql/#findComment-102562 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.