I have be working on a database creation problem with the following code
<?php//connect to MySQL; note weâ€™ve used our own parameters- you should use//your own for hostname, user, and password$connect = mysql_connect("localhost", "heathwhite", "machead5") or
die("Hey loser, check your server connection.");
//create the main database if it doesnâ€™t already exist$create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite")
//make sure our recently created database is the active onemysql_select_db("moviesite");
//create "movie" table$movie = "CREATE TABLE movie (
movie_id int(11) NOT NULL auto_increment,
movie_name varchar(255) NOT NULL,
movie_type tinyint(2) NOT NULL default 0,
movie_year int(4) NOT NULL default 0,
movie_leadactor int(11) NOT NULL default 0,
movie_director int(11) NOT NULL default 0,
PRIMARY KEY (movie_id),
KEY movie_type (movie_type,movie_year)
$results = mysql_query($movie)
//create "movietype" table$movietype = "CREATE TABLE movietype (
movietype_id int(11) NOT NULL auto_increment,
movietype_label varchar(100) NOT NULL,
PRIMARY KEY (movietype_id)
$results = mysql_query($movietype)
//create "people" table$people = "CREATE TABLE people (
people_id int(11) NOT NULL auto_increment,
people_fullname varchar(255) NOT NULL,
people_isactor tinyint(1) NOT NULL default 0,
people_isdirector tinyint(1) NOT NULL default 0,
PRIMARY KEY (people_id)
$results = mysql_query($people)
echo"Movie Database successfully created!";
But upon running it I get the error shown below. My logins are correct and now I can't pinpoint the problem cause. Plz help I feel like a loser now.
Warning: mysql_connect()[function.mysql-connect]: Access denied for user 'Heath White'@'localhost'(using password: YES) in /Applications/XAMPP/xamppfiles/htdocs/moviedata.php on line 4
Hey loser, check your server connection.
Seems most web hosts do not allow you to create a database directly through a PHP script. Instead they require that you use the PHP/MySQL administration tools on the web host control panel to create these databases. So I decided to be creating and adding tables on databases that I already have....
the host server where the site is hosted has to have mysql. Creating a new database and creating user permissions is actually a bit technical and kind of away from the normal PHP business, involving a lot of researching on the web (or Google more specifically).