invertigo Posted March 4, 2007 Share Posted March 4, 2007 Hello, I recently screwed up my entire Mysql install.. and so far i havent found a way to recover it. It appears to be that somehow my root user got deleted, and as far as i know there is no way to create another one. I am using Webmin, and Webmin is allowing me to log in with a 2nd username.. but thisone doesnt have any rights anymore. i can only change a few settings, i cant acces DB control (gives: DBI connect failed : Access denied for user 'admin@'' to database 'mysql' in which admin is my 2nd user.) Username root doesnt work at all anymore. So far i have deleted these packages: mysql-server mysql-client libmysqlclient15-dev But this doesnt solve the problem. I can start / stop the service Is there a way to delete the entire Mysql installation, and therefor allowing me to save my setup? If so, i would really appreciate to know, Tnx Vertigo. - MySQL version 5.0.22 - Apache 2 Running - Webmin 1.330 in use - PuTTY acces (SSH enabled) A read to these directory's gives "directory not found": /var/lib/mysql /usr/local/mysql/lib /usr/bin/mysqlimport And these no acces: /usr/bin/mysqlshow /usr/bin/mysqladmin Quote Link to comment Share on other sites More sharing options...
fenway Posted March 4, 2007 Share Posted March 4, 2007 First, make sure the data files are intact... then worry about the rest. Quote Link to comment Share on other sites More sharing options...
invertigo Posted March 4, 2007 Author Share Posted March 4, 2007 Tnx for your reply, Yes, i managed to recover all data Im glad i didnt loose these.. This is a dedicated server btw, thats why i would like to prevent having to reinstall everything again. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 4, 2007 Share Posted March 4, 2007 So what is your question now? Quote Link to comment Share on other sites More sharing options...
invertigo Posted March 5, 2007 Author Share Posted March 5, 2007 Well, My data files have been saved.. databases are not lost. But backup doesnt seem to work, and the Mysql login is still bugged. it looks like root user has been removed somehow (no idea how this happened) because i cant login as root anymore, and cant change password either. Right now everything is still working, but i cant acces the DB's or change them anymore. (no backup available either, because of this) Thats why i would like to trash the entire Mysql, and do a reinstall. --purge mysql-server doesnt seem to work though. I could go for a full reinstall, but then i will have to configure everything again. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 5, 2007 Share Posted March 5, 2007 You should follow the procedures for resetting the root password.. Quote Link to comment Share on other sites More sharing options...
artacus Posted March 5, 2007 Share Posted March 5, 2007 ...if you have another acct that can add/modify users and such. Otherwise you have no choice but to reinstall mysql. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.