se1zure Posted January 22, 2007 Share Posted January 22, 2007 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 databaseif (mysql_query("CREATE DATABASE se1zure_postdata",$con)) { echo "Database created"; }else { echo "Error creating database: " . mysql_error(); }// Create table in se1zure_postdata databasemysql_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] Quote Link to comment Share on other sites More sharing options...
printf Posted January 22, 2007 Share Posted January 22, 2007 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.