mysql_create_db()

MatttWithOneT

I am experimenting with creating databases with PHP/MySQL, and I'm 99% sure I have the coding right. The hostname IS 'localserver' for my online account, so that doesnt need to be changed. Here's my code:

<html>

<body>

<?php

$create = @mysql_connect("localhost", "msimattt", "********");
if (!$create)
{ echo( "<P>Unable to connect to the " .
"database server at this time:" ); mysql_error() .
"</p>";}

mysql_create_db("CREATE DATABASE dumb");
if(@!mysql_create_db("dumb"))
{ echo("<P>Error creating database: " .
mysql_error() .
"</P>");}

if(mysql_create_db("dumb"))
{	echo "<p>Database created!"; }

</body>

</html>

and this is the error I get:

mysql_error() = Access denied for user: 'msimattt@localhost' to database 'anything'

I was wondering if anyone had any comments. I have my name/pass correct, (i just deleted my pass) so that isnt it. Thanks for the help!

Elizabeth

Matt, have you checked with your hosts to make sure you can create databases? I know with some hosts- they create it for you, and they have everyone's databases all on one server. You then have the power to add/delete tables to that database, but as far as creating and deleting databases themselves- they won't allow users to do that.

You may want to double check that your account has that permission.

Now, of course if you are hosting your own site, you can kindly disregard my previous statements 🙂

-Elizabeth

MatttWithOneT

Never thought of that, but that's prolly cuz it's common sense. LOL, well thank ya kindly, have a good one.