I've successfully dropped all tables but I can't remove the database itself.Here's the printout from phpmyadmin:
DROP DATABASE mydb_generic
Have you checked to see if you have permission?
Do you have cpanel and phpmyadmin ? if so i would suggest using that GUI its scads easier.
Yes, I'm logged in as the root mysql user.But no, it's not a cPanel/WHM server.
look in that directory and remove any stray files.
If so you can still install a gui. Im running on a windows web server at work.
try removing strays like longneck says, if that doesn't work 2x check permissions and syntax and if all else fails install a gui.
Thanks longneck, that turned out to be the problem.