You can start mysqld with --skip-grant-tables, repair whatever you need to and then restart without the above. On Thu, Jul 25, 2002 at 10:13:53PM -0400, yong8964 wrote:
Hi, My linux version is Suse 8.0. Today, I tried to load a sql script into mysql database. But I forget to change to the right db. So the script is loaded into mysql database. Even worse is that the scirpt has table named 'user', so it drop and recreate this table. Now in mysql database, I mass up with the whole database. I can't login as admin or any account now.
I tried to rerun the /usr/bin/mysql_init_db, but after that, I didn't find that the root password was set to empty. I still can't login as any account. What I should do to recreate a mysql database as the same as it is just installed freshed? I don't have too much useful data in it. The question is that I don't want to reinstall the whole database. I just want to recreate the database.
Please help. Thanks
The lesson I learned: Don't load any sql script using root account!
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com