MySQL DB creation

matthewzammit

I started tutorials on MySQL and PHP database connection.

I have one problem... I don't know how to create the actual database on the server (and the server is not mine, i just connect to it through ftp username and password).

I know how to create a table but it is unable to connect to the db (I assume that this is so becaue this db is not yet created, and i am trying to create a table on an inexistint db)

<title>CREATE DB</title>
<?php
$user="teenfellowship";
$password="welcome";
$db="mydb";
mysql_connect(localhost,$user,$password);
@mysql_select_db($db) or die("Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(30) NOT NULL,last varchar(30) NOT NULL,phone varchar(20) NOT NULL,PRIMARY KEY (id),UNIQUE id (id))";
mysql_query($query);
mysql_close();
?>

How do I create the DB before creating the table???

thanks in advance,

Matt

laserlight

You might try:
CREATE DATABASE dbname

or use the function [man]mysql_create_db/man, or simply get the server administrator to create it for you.

matthewzammit

hey i didn't get the error now!!

will check later if it has actually worked or not by inputting some data and doing some query on it.

i used >> CREATE DATABASE dbname

thanks a lot lot lot!!

Matt

matthewzammit

no, it didn't work... i had a syntax error... I arranged a bit the code as shown below but the server is giving me the error: Access denied for user: 'teenfellowship@localhost' (Using password: YES)

Is the code correct at least? before I asked the server admin to see why i'm not able to connect to the MySQL server and create a DB...

<html>
<title>CREATE DB</title>
<body>

<?php
// set your infomation.
$dbhost='localhost';
$dbusername='teenfellowship';
$dbuserpass='welcome';
$db='tfdb';

// connect to the mysql database server.
if (mysql_connect ($dbhost, $dbusername, $dbuserpass)){
echo "success in connecting to MySQL.";}
else {die(mysql_error());}

// create the database.
$db=$dbusername."_".$db;
if (mysql_query("CREATE DATABASE $db")){
echo "success in database creation.";}
else {die(mysql_error());}

mysql_close();
?>

</body>
</html>

laserlight

Maybe you dont have the required permissions?