Problem connecting to Mysql through php.

[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]





[attachment deleted by admin]

[se1zure]

bump,  can anyone help?

[smc]

Edit:

Your not able to connect to the database since you have no user assigned to it since it's not created in the first place. It's an unfortunate loop

What you need to do is create the database in cPanel and then you can add tables to it.

Your problem is your trying to connect to a database that doesn't exist, when creating a user in cPanel it is nothing until it is associated with a database.

You *MIGHT* be able to do what you want by using your root cPanel username and password to attempt to login

[se1zure]

php is able to create databases, I thought?

[smc]

It is, but not if you cannot login to it. Please read the entirety of my post

[Nhoj]

Those screenshots LOOK like they came from cPanel, if that's the case. Use your cPanel information as your mySQL user information.

cPanel Username = mySQL username
cPanel Passoword = mySQL password