[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