Mysql help. I'm a noob.

[se1zure]

I decided to try out using mysql with php.

I have mysl on my server, and I login, and create a new user. (the pic below shows the steps I follow). Using username = cory, and pw = 123456.


[URL=http://allyoucanupload.webshots.com/v/2005256806995396933][IMG]http://aycu17.webshots.com/image/10136/2005256806995396933_rs.jpg[/img][/URL]


[code]
<?php
$con = mysql_connect("localhost","se1zure_cory","123456");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create database
if (mysql_query("CREATE DATABASE se1zure_postdata",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

// Create table in se1zure_postdata database
mysql_select_db("se1zure_postdata", $con);
$sql = "CREATE TABLE Person
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);

mysql_close($con);
?>[/code]

That is the code I am using to create a new database, and add a new table to it.

THis is the error I get, can you tell me what i am doing wrong?

[code]Error creating database: Access denied for user 'se1zure_cory'@'localhost' to database 'se1zure_postdata'[/code]

[printf]

You need [b]CREATE[/b] privilege, to create a database, check your [b]mysql[/b] database, table [b]user[/b], column [b]Create_priv[/b]. It should have [b]Y[/b] for it's value!

printf