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.
– 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
Add Comment