You probably already have the answer to this but there is another way too.<br><br>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@localhost.<br><br>--Douglas Wagner<br><br><div><span class="gmail_quote">On 5/13/07, <b class="gmail_sendername">Karl E. Jorgensen</b> <<a href="mailto:karl@jorgensen.org.uk">karl@jorgensen.org.uk</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On Sat, May 12, 2007 at 07:36:38PM -0400, A JM wrote:<br>> I just finished re-installing Ubuntu and was creating the DB when I
<br>> accidentaly deleted the root@localhost user... yikes!<br>><br>> Any known procedure for recreating root since I can't log back into mysql?<br><br>There are always a way. Just use the debian-create admin userL
<br><br> $ mysql -u debian-sys-maint -p<br> Enter password:<br> ... and use the password from /etc/mysql/debian.cnf<br><br> mysql> create user 'root'@'localhost';<br><br>Hope this helps<br><br>
--<br>Karl E. Jorgensen<br><a href="mailto:karl@jorgensen.org.uk">karl@jorgensen.org.uk</a> <a href="http://www.jorgensen.org.uk/">http://www.jorgensen.org.uk/</a><br><a href="mailto:karl@jorgensen.com">karl@jorgensen.com
</a> <a href="http://karl.jorgensen.com">http://karl.jorgensen.com</a><br>==== Today's fortune:<br>That's odd. That's very odd. Wouldn't you say that's very odd?<br><br>-----BEGIN PGP SIGNATURE-----
<br>Version: GnuPG v1.4.6 (GNU/Linux)<br><br>iD8DBQFGR26Ni+PVvwZpXJgRAhHWAJ9EML23MJgtXttTiV/1Yd+r9AdsSgCeItuL<br>HLATAFe3CcDByB2ywzdRa2Y=<br>=zAKk<br>-----END PGP SIGNATURE-----<br><br>_______________________________________________
<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
</a><br><br></blockquote></div><br>