Hosting Articles Technical Articles

ERROR: [“DROP DATABASE” statement is disabled]

 

 

 

ERROR: [“DROP DATABASE” statement is disabled]

Description:

In phpmyadmin while deleting unwanted database it is giving drop database error.Here is the error message,

ERROR: [“DROP DATABASE” statement is disabled]

Solution:

In phpmyadmin if there is any restriction in the functions like DROP, UPDATE these kind of issues will arise.Here is the simple solution to drop the database.
– Login to the system using administrator privileges,

–  Now go to the following path /xampp/PhpMyAdmin/libraries.

How To Add Admin Account To WordPress Via Phpmyadmin02

– Open config.default.php file and check the following ,

$cfg[‘AllowUserDropDatabase’]

This was located in line number 566.Change from false to true.

– Save the file and restart the xampp services.

– Now try to drop the database  it will work.

Tags:DROP,phpmyadmin,SQL,mysqltech news,Hosting articles,Latest hosting article,phpmyadmin configuration

About the author

admin

Add Comment

Click here to post a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.