| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 85247 | 2007-12-04 17:13:00 | mysql database issues | Mike (15) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 617892 | 2007-12-04 17:13:00 | I've installed mysql on my home pc (for dev purposes), and imported a couple of databases that I pulled off my website. However it included another database from the site that I have no permissions to modify, and now I can't drop it... How do I get mysql to drop that db? Or how can I find where the db is stored so I can just delete it from my PC? I uninstalled mysql and deleted all reference to it on my HDD (that I could find) and from the registry, but when I reinstall that db is still there. If I do too much fiddling trying to delete that db I somehow kill mysql and have to uninstall/reinstall it. I am wondering if the db I'm trying to remove is actually a default mysql one that can't be dropped? Are there any? I hope there's a mysql guru here :D Mike. |
Mike (15) | ||
| 617893 | 2007-12-04 17:22:00 | Just log in as the root user for MySQL (NOT the same as the root user for the system), and run: DROP DATABASE `DamnHorribleThingYouDon'tWant`; The root user has unlimited priveleges and can do anything to the server. One note: there are two databases internal to MySQL that you should never touch. One is `mysql`, the other is `information_schema`. Don't mess with them unless you know *exactly* what you are doing. |
Erayd (23) | ||
| 617894 | 2007-12-04 17:35:00 | One note: there are two databases internal to MySQL that you should never touch. One is `mysql`, the other is `information_schema`. Don't mess with them unless you know *exactly* what you are doing.ROFL well that might have just answered my question :D the name of the db was information_schema - I thought I'd pulled it off my website so was trying to remove it... obviously it was installed already lol thanks for that - I don't recall ever seeing information_schema in previous versions of mysql I've used. Now I feel stupid :D lol Cheers, Mike. |
Mike (15) | ||
| 617895 | 2007-12-04 19:29:00 | ...I don't recall ever seeing information_schema in previous versions of mysql I've used.It would have been hidden from view, unless you were accessing MySQL with an account allowed to view all databases on the server (which is never the case with shared webhost accounts). | Erayd (23) | ||
| 617896 | 2007-12-04 19:48:00 | It would have been hidden from view, unless you were accessing MySQL with an account allowed to view all databases on the server (which is never the case with shared webhost accounts).I can see it in my standard webhost account using phpmyadmin or whatever its called - I can also see one called "test". When I export from phpmyadmin I get all my databases and those two as well. Mike. |
Mike (15) | ||
| 1 | |||||