I have 2 databases.
One called information_schema was created using PHPrunner and I can see it using phpMyAdmin but I cannot see using MySql@databases.
The other one called test was created using MySql@databases which I can see using both MySql@databases and phpMyAdmin. This database can be deleted using MySql@databases.
The information_schema database cannot be deleted using phpMyAdmin when I tried the drop database sql query and the error is that drop database is not allowed. Please advise on how I should delete this database.
Also, why is it that I cannot create database using phpMyAdmin? It seems to be affecting my creating of database using PHPrunner. Is it something to do with the basic, intermediate and advanced php settings in accounts panel? Should I request for higher setting?
Please advise. Thanks.