Jump to content

Problem connecting to Mysql through php.


se1zure

Recommended Posts

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]
Link to comment
https://forums.phpfreaks.com/topic/35155-problem-connecting-to-mysql-through-php/
Share on other sites

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

Archived

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

×
×
  • Create New...

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.