locked out of mysql database

adcripps · 09-06-2002, 09:28 AM

I'm locked out of mysql database - it seems that all my users can't access it, through lack of privileges, even root. This means that I can't get through and change the privileges.

How can I start with a fresh users database?

I'm only setting the database up at the moment, so there's no data to lose.

I've tried mysqladmin_fix_privileges_tables and I've tried
mysqladmin_install_db

but nothing seems to work.

Also, the actual mysql database itself has no tables. How can I restore that?

Any ideas?

needamiracle · 09-06-2002, 12:42 PM

Did you get hacked? Have you checked your logs? If there are no tables in the mysql db then you have no db. Please tell me you have a backup somewhere? Otherwise you have to start fresh.

adcripps · 09-06-2002, 01:02 PM

Thanks for the tips. I wasn't hacked - this is an internal server at work, and I was starting up mysql and foolishly (somehow, definately not intentionally) changed the permissions using phpmyadmin - however, I've managed to fix it now -the documentation is brilliant, although it tool a while to fix.

I found the files that needed deleting, deleted them and ran mysql_install_db (you should do this as user mysql) -all the necessary databases are set up again, with a user root. Gave root a password and it worked a treat.

needamiracle · 09-06-2002, 01:47 PM

Glad to hear...

As a side note, I find that you can't really loose data...it just takes a while to put it back the way you had it... :-)