Cannot delete DB. Drop DB query not working

Question

I cannot delete database from raw MySql query here. Is there a better way? Please suggest. Is there a way to write a query to drop database in Zend. I'm using Zend 1.11

// Delete db function
public function deleteDB($dbName){
// For database connection
$config = new Zend_Config( 
    array(
    'database' => array(
    'adapter' => 'PDO_MYSQL',
    'params'  => array(
    'host'     => 'localhost',
    'dbname'   => $dbName,
    'username' => 'root',
    'password' => '',
            )
    )
    )
);
 $db = Zend_Db::factory($config->database);

 //Delete database
 $sql = 'DROP DATABASE'. $dbName;
 $db->query($sql);

Sadikhasan · Accepted Answer · 2014-06-25 06:37:41Z

2

If your configuration is correct then try to put space after DATABASE like

//Delete database
 $sql = "DROP DATABASE `". $dbName."`";

edited Jun 25, 2014 at 6:37

answered Jun 25, 2014 at 5:53

Sadikhasan

18.6k23 gold badges85 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Shirshak Over a year ago

I've tried. It throws error as "Syntax error or access violation"

Shirshak Over a year ago

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Sadikhasan Over a year ago

What is your database name?

Shirshak Over a year ago

It's a fake Db i made. "aaa-test-fake-co_fc". The db name won't matter I guess.

Sadikhasan Over a year ago

I updated my answer please try it. If it will work then I explain why this?

|

leo108 · Accepted Answer · 2014-06-25 05:53:07Z

0

$sql = 'DROP DATABASE'. $dbName;

I think you missed a space

$sql = 'DROP DATABASE '. $dbName;

answered Jun 25, 2014 at 5:53

leo108

8175 silver badges12 bronze badges

6 Comments

Shirshak Over a year ago

I've tried. It throws error as "Syntax error or access violation"

leo108 Over a year ago

@user3386487 it seems your mysql user doesn't have privilege to drop the database

Shirshak Over a year ago

Ive just deleted db from console from same username. It seems like its a Zend issue. Can you help me on that?

leo108 Over a year ago

@user3386487 another possibility is that the mysql user you used in php and in console is different, although they use the same name, It depends on what db hostname you connected.

Shirshak Over a year ago

@hd1-Yes, i can from xampp-shell.

|

Collectives™ on Stack Overflow

Cannot delete DB. Drop DB query not working

2 Answers 2

9 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related