Daemon News Ezine | BSD News | BSD Mall | BSD Support Forum | BSD Advocacy | BSD Updates |
On 2/2/2006 4:40 PM Peter Giessel wrote:
On Thursday, February 02, 2006, at 03:24PM, Drew Tomlinson <drew@xxxxxxxxxxxxxxxxxx> wrote:I'm frantically trying to recreate 3 users in the mysql.user table after accidentally deleting them. I have the names and the password hashes but don't know the password.Recreate then users with a different password then login to mysql as root and: use mysql; update user set Password="<password hash>" where User="<recreated user>"; flush privaleges;
Thank you very much. That should work! Drew -- Visit The Alchemist's Warehouse Magic Tricks, DVDs, Videos, Books, & More! http://www.alchemistswarehouse.com