Re: Two Problems with Upgraded from 4.0 to 4.1
Posted by: Erin ONeill
Date: August 25, 2005 03:04PM

Hey Mike -
1. stop mysqld.
2. start mysql with --skip-grant-tables.

you need to run the mysql_fix_privilege_tables script. I just cut out the code I needed, ran it, created a couple of users and then flushed privileges. DO NOT FORGET TO CREATE a couple of users (esp. admin ones and one that phpMyAdmin can use if you use it). Then stop & start mysql without the --skip-grants.

It's not so difficult. You may have some password problems and you may need to turn on old_passwords (I believe that's in the manual/docs).

good luck!

erin

Options: ReplyQuote


Subject
Written By
Posted
Re: Two Problems with Upgraded from 4.0 to 4.1
August 25, 2005 03:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.