[mythtv-users] Root user mysql - accidental delete

[Douglas Wagner]

You probably already have the answer to this but there is another way too.

If you've just installed the system and don't need the database the easiest
thing might by to go into your /var/lib/mysql directory and simply blow away
everything in there.  You would then run mysql_install_db and that would
re-generate/put back your base installation tables/users including
root at localhost.

--Douglas Wagner

On 5/13/07, Karl E. Jorgensen <karl at jorgensen.org.uk> wrote:
>
> On Sat, May 12, 2007 at 07:36:38PM -0400, A JM wrote:
> > I just finished re-installing Ubuntu and was creating the DB when I
> > accidentaly deleted the root at localhost user... yikes!
> >
> > Any known procedure for recreating root since I can't log back into
> mysql?
>
> There are always a way. Just use the debian-create admin userL
>
>     $ mysql -u debian-sys-maint -p
>     Enter password:
>     ... and use the password from /etc/mysql/debian.cnf
>
>     mysql> create user 'root'@'localhost';
>
> Hope this helps
>
> --
> Karl E. Jorgensen
> karl at jorgensen.org.uk  http://www.jorgensen.org.uk/
> karl at jorgensen.com     http://karl.jorgensen.com
> ==== Today's fortune:
> That's odd.  That's very odd.  Wouldn't you say that's very odd?
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFGR26Ni+PVvwZpXJgRAhHWAJ9EML23MJgtXttTiV/1Yd+r9AdsSgCeItuL
> HLATAFe3CcDByB2ywzdRa2Y=
> =zAKk
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070513/ad786cea/attachment.htm