[mythtv-users] Root user mysql - accidental delete

Karl E. Jorgensen karl at jorgensen.org.uk
Sun May 13 20:01:17 UTC 2007


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?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20070513/49fbca6b/attachment.pgp 


More information about the mythtv-users mailing list