LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 07-09-2004, 06:53 PM   #1
ivj
Member
 
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, 10:38 PM   #2
th3_d0c
Member
 
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, 11:51 PM   #3
ivj
Member
 
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.
 
  


Reply


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 01:02 AM
MySQL root permissions deleted newuser455 Linux - Software 6 03-20-2005 01:50 PM
root account Deleted chandu Linux - Security 1 06-18-2004 01:47 PM
Fixing MySQL root account permissions. TexasDex Linux - Software 2 02-02-2004 10:39 PM
deleted mysql table in mysql now cant do anything nakkaya Linux - Software 0 03-18-2003 07:03 PM


All times are GMT -5. The time now is 06:28 PM.

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