Topic: uninstall mysql?
started by: Spydir Web
Posted by Spydir Web on Feb. 18 2001,18:02
This is gonna sound dumb as hell, but how do I uninstall MySQL? A while back, I installed it with PHP, Apache, and some other webserver related things (I just ran it to test code without having to ftp it to a host), and when I set the password for the root user it messed up. I've goofed with a few things, tried installing on top of the old, but it just won't work. I did a "make uninstall" a little bit ago, and it seemed to work, but when I installed again it just did the same thing. I would really like to have mysql on my system since the webhost I'm getting runs it and I'd rather have about the same setup so I can do proper testing. Any ideas?And please don't give me any buffer over flow "l33t h4x0r" shit... I'd rather not have to crack into my own computer to do something simple.
------------------
Spydir Web - spydirweb@techie.com
Core Arctic - < http://welcome.to/CoreArctic/ >
Posted by DeadAnztac on Feb. 18 2001,21:13
if this is on linux all you need to do is after you uninstall delete /var/db (i.e "rm -rf /var/db") and it should all be gone. It's as easy as that 
tell me if it works.~Anztac
This message has been edited by DeadAnztac on February 19, 2001 at 04:13 PM
Posted by DeadAnztac on Feb. 18 2001,21:14
oh yeah, and you have to be root of course to do this in case you didn't know 
~Anztac
Posted by whtdrgn_2 on Feb. 19 2001,13:22
When you do get the password thing taken care of, backup your mysql db by typeing:mysqldump -u root -p > mysql_db.bak Put this file in a polace where no one will ever be able to read it and chmod 500 it. TO recover the mysql db do a:
mysql -u root -p mysql < mysql_db.bak This will keep you db, host, user, and privileges tables backed up. Also, never add a user without calling the password funciont:
INSERT INTO USER (host, user, password) VALUES('\%', 'bob', password('marley'));
If you forget the password() thing, and run a flush privileges, and restart the db, all hell breaks loose. ALways run a:
SELECT * FROM USERS WHERE user = <username>
and look for the encrypted password:
Just some hints from past experiences of mine
------------------
Wine me, dine me, 1000101 me