Re: [sclug-general] i fscked up!

[Daniel Kuecker]

ok. this is what i got when doing the following command:.. # /etc/rc.d/init.d/mysqld stop # /usr/bin/safe_mysqld --skip-grant-tables # mysql -u root mysql> use mysql; mysql> update user set Password = PASSWORD('pass') where User ='root';   mysql> update root set Password = PASSWORD('password'); ERROR 1146: Table 'mysql.root' doesn't exist mysql> Any ideas? ----- Original Message ----- From: Ryan To: [EMAIL PROTECTED] Sent: Sunday, June 01, 2003 9:33 PM Subject: Re: [sclug-general] i fscked up! At 09:23 PM 6/1/03, you wrote: somehow i can no longer connect to my mysql database! not even as root... what config files do i need to delete so i can reload mysql as if it were new?  thanks Daniel I've had this problem before, but it was years ago and I can't remember exactly what I had to do... I think I might have just backed up the data, reinstalled mysql then put the data back.  This might help  http://www.mysql.com/doc/en/Resetting_permissions.html -Ryan