Drop database not working

tripwater

I know this has to be something simple.

I have a form in a project tracker that allows admin to create a DB and add a user to it so we can quickly sell and add people.

Beside each Current DB is a remove link that passes the same page the global DB ID and if clicked, should remove the entries from the global db and globalusers table as well as drop the created DB and all its records. Right now what I have is removing the records from the first two tables I mentioned but will not drop the DB.

if (!empty($_GET["id"]))
{		
//first we get the DB name
$query	= "select DB from globaldbs where ID = ".$_GET["id"];

$result	= @mysql_query($query);

$row	= @mysql_fetch_array($result);


//now we delete the record from the globalusers table
$query	= "delete from globalusers where DB = '".$row["DB"]."'";

$result	= @mysql_query($query);

//now we delete the record from the globaldbs table
$query	= "delete from globaldbs where DB = '".$row["DB"]."'";

$result	= @mysql_query($query);



//now we drop the DB
$query	= "DROP DATABASE ".$row["DB"];

//tried this mysql_drop_db($row["DB"]); and it did not help
//echo $query;

$result	= @mysql_query($query);

if (!$result)
   echo "Nope";
}

If I echo the drop DB query and paste it into MYSQL, it works. But I can not get it to from the web interface. I have removed the @ symbol and I do not have any errors.

Any ideas?

Thank you for any help.

konsu

does the DB user that you use from your PHP code have the right permissions?

MikeSnead

Where ever you have

@mysql_query($query);

change it to...

mysql_query($query) or die(mysql_error());

It'll tell you what's wrong from mysql's point of view... rather than PHP's

tripwater

Thanks for the replies.

I changed my code to show

$result	= mysql_query($query) or die(mysql_error());

and it gave this error

Access denied for user: 'softekso_taskusr@localhost' to database 'softekso_test'

When I create the db softekso_test this is the command I use for privileges

$query  ="grant select, insert, update, delete, alter, create, drop on ".$dbname.".* 
to softekso_taskusr@localhost identified by 'passgoeshere';";

$result	= @mysql_query($query);

SO I went back and granted drop privileges to not only my global_db user but to the user of the DB I am currently using to create the DB and I still get this error.

Not sure what I am doing wrong

kburger

Did you reload the MySQL permissions?
-- eg. FLUSH PRIVILEGES or mysqladmin reload