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
http://www.mysql.com/downloads/mysql-3.23.html -----Original Message----- From: Dave [mailto:ping.wu@verizon.net] Sent: Friday, July 26, 2002 5:53 PM To: 'Len Rose'; yong8964 Cc: suse-linux-e@suse.com Subject: RE: [SLE] how to recreate mysql database? All, I was looking for a rpm of some sort to get a version of MySQL for my SuSe 8.0, can you give me a pointer as of where I can get a copy of it ? Thanks much. -----Original Message----- From: Len Rose [SMTP:len@netsys.com] Sent: Friday, July 26, 2002 1:35 AM To: yong8964 Cc: suse-linux-e@suse.com Subject: Re: [SLE] how to recreate mysql database? 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: 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
<< File: ATT00000.att >> -- 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