Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 07-09-2004, 05:53 PM   #1
Registered: Jul 2004
Posts: 61

Rep: Reputation: 15
MySQL deleted root account and can't re-install...

Hey everyone!

Basically, I just installed MySQL, and I was just playing around with it. Somehow I deleted the root@localhost and root@localhost.localdomain accounts. So I tried to run mysql_install_db, but it didn't work.

So I thought to reinstall mySQL. So I went ahead and deleted folder /var/lib/mysql ... Then I realized that mysql came in RPM, so why don't I just try rpm -e ?

SO I tried, and it said that "this package is not installed".

Now if I try to use /etc/init.d/mysql start, it simply doesn't say anything, and the server doesn't start. if I try to do rpm -i on the server package, it tells me that there's conflict with files inside /var/lib/mysql (even though I deleted all those files)...

I have no idea what to do. I think the best solution is to remove everything related to mysql and reinstall it fresh...

HOw would I do that?

Thank you!
Old 07-09-2004, 09:38 PM   #2
Registered: Nov 2003
Location: New Hampshire
Distribution: Slack 9.2
Posts: 39

Rep: Reputation: 15
Did you loose your root account on your box? Or just in mysql? And what distro are you using?
Old 07-09-2004, 10:51 PM   #3
Registered: Jul 2004
Posts: 61

Original Poster
Rep: Reputation: 15
I got the problem fixed.

All I had to do was uninstall MySQL package from a previous version (4.0.x), because it was conficting with the installation of the newer version (4.1.x)..

Then everything started working.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I retain the PATH in the root account even when I switch to root using su? thearchitect Linux - Newbie 1 08-13-2005 12:02 AM
MySQL root permissions deleted newuser455 Linux - Software 6 03-20-2005 12:50 PM
root account Deleted chandu Linux - Security 1 06-18-2004 12:47 PM
Fixing MySQL root account permissions. TexasDex Linux - Software 2 02-02-2004 09:39 PM
deleted mysql table in mysql now cant do anything nakkaya Linux - Software 0 03-18-2003 06:03 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 06:52 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration