Tech Journal Back to Tech Journal

mySQL won't let me do anything after a crash! It keeps saying access denied!

There's a way to force mysql to not read the permission tables and grant access to root. Run mysql with --skip-grant-tables to make it ignore the privlages. Then just check the USER table in the MySQL database. From there, you can fix the permissions and the users.

Last updated on 2004-01-22 14:00:00 -0800, by Shalom Craimer

Back to Tech Journal