[CS-FSLUG] Anybody run mysql server?

[l4c]

David McGlone wrote:
> I'm in a bit of a bind here.
> 
> Somehow I lost all my mysql database tables and now I cannot log into mysql.
> 
> my question is, usually when mysql is first installed, it installs IIRC 2 
> tables and I think these 2 tables are required for storing the administrator 
> username and password etc. so I never did touch these tables.
> 
> Anyway, I tried re-installing everything related to mysql but it does not 
> restore these tables, so I can't log in as root anymore.
> 
> Does anyone know what I need to uninstall, reinstall to get all the settings 
> back to the same as a fresh install? Short of re-installing the whole Ubuntu 
> distro, which I've had to do before :-( So I'm hoping I don't have to do that 
> this time. 
> 
> I also know I lost my tables I created, but I have backups of those, so I'm 
> not worried 'bout that.
> 
> 

It installs 3 databases, mysql, information_schema and test.  The test 
database is unimportant, but the other two contain multiple tables that 
need to be there in order to get things going.

Try doing a full uninstall of mysql-server "sudo aptitude purge 
mysql-server" (all one line there), and then reinstall the same package. 
  This should delete and recreate your default mysql install.  Then you 
can get that running and restore your databases and tables to it.

-- 
-Linc Fessenden

In the Beginning there was nothing, which exploded - Yeah right...