upgraded 6.2 and mysql lost all privileges

[Noah]

I dont think that is the issue.  the problem is with the mysql virtual 
users

they do not appear in the /etc/passwd or /etc/master.passwd files.

so that is the wrong direction.
cheers,
Noah


Steve Bertrand wrote:
>>> In the last episode (Mar 06), Noah said:
>>>> yeah - I have about 15 other user accounts specific to my mysql
>>>> installation that were not in the /etc/passwd file.  where were those
>>>> stored?
>>>
>>> If you're just talking about mysql users, those are in
>>> /var/db/mysql/mysql/user.* .  An OS upgrade shouldn't have touched
>>> them at all.  Unless you reformatted /var or something :)
> 
> It may be possible that mergemaster was used incorrectly.
> 
> If so, there should be a copy of the updated /etc/master.passwd file in:
> 
> # /var/tmp/temproot/etc
> 
> You can compare that against the new file in /etc. If they are the same, 
> mergemaster hosed the original. I don't know if mergemaster makes a 
> backup of the original, but it may be easier to pull master.passwd from 
> a backup (you did backup /etc right?) and try re-merging if there were 
> any differences.
> 
> Then again, I may be totally wrong with this assessment.
> 
> Steve
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to 
> "freebsd-questions-unsubscribe at freebsd.org"