create database in mysql through php coding

vivekananth · #1 (**permalink**) January 25th, 2007, 01:16 AM

<?php
$con = mysql_connect("localhost","vivek","vivek");
echo $con;
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }if (mysql_query("CREATE DATABASE vivek1",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }mysql_close($con);
?>
i am using this code iam getting error like this

Resource id #2Error creating database: Access denied for user 'vivelk'@'localhost' to database 'vivek1'

can any body help me

surendran · #2 (**permalink**) January 25th, 2007, 04:23 AM

hai vivekananth,
your user name amd password do not have permission to create databse using your access level.
so, better to use root user name password for create databse query.

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

leefj · #3 (**permalink**) January 31st, 2007, 01:48 AM

need to change the user privilege;
such as:
mysql>grant all privileges on *.* to vivec@localhost

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
entering £ (pound sign) into MySQL database - PHP	crmpicco	PHP Databases	1	November 14th, 2007 02:02 AM
PHP Create Database problem	sweyhrich	Beginning PHP	9	January 29th, 2007 06:39 AM
Create Crystal Report using Php, Mysql	arry004	PHP How-To	0	September 27th, 2006 05:16 AM
Create MySQL database	newlearner	PHP Databases	7	June 15th, 2005 03:26 AM
Interfacing PHP/MYSQL to existing Database...	mekh	Pro PHP	6	February 8th, 2004 06:04 PM