http://www.mysql.com/doc/R/e/Resetting_permissions.html
after starting mysql with the --skip-grant-tables, you'll have to execute a grant statement http://www.mysql.com/doc/G/R/GRANT.html GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY 'somepassword' WITH GRANT OPTION; then restart mysql without the --skip-grant-tables. thanks, -- Andrew -----Original Message----- From: Lisa Williams [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 10:59 AM To: [EMAIL PROTECTED] Subject: I deleted my root user! Please help. I accidentally deleted the root user and now I can't do anything. How can I recreate this user with super user privileges? I'm new to MySQL so please be detailed. Thanks in advance Lisa --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
