upgraded 6.2 and mysql lost all privileges

[Noah]

Dan,

okay you got me on the right track.
I can see mysql files in that directory.  but mysql is not aware of the 
users in the "user files"

is there something that I need to tell to mysql to use those files to 
reincorporate the mysql related users?


# ls -l /var/db/mysql/mysql
total 648
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 columns_priv.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 columns_priv.MYI
-rw-rw----  1 mysql  mysql    8820 Mar  6 06:49 columns_priv.frm
-rw-rw----  1 mysql  mysql     876 Mar  6 06:49 db.MYD
-rw-rw----  1 mysql  mysql    4096 Mar  6 06:49 db.MYI
-rw-rw----  1 mysql  mysql    9494 Mar  6 06:49 db.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 func.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 func.MYI
-rw-rw----  1 mysql  mysql    8665 Mar  6 06:49 func.frm
-rw-rw----  1 mysql  mysql   20916 Mar  6 06:49 help_category.MYD
-rw-rw----  1 mysql  mysql    3072 Mar  6 06:49 help_category.MYI
-rw-rw----  1 mysql  mysql    8700 Mar  6 06:49 help_category.frm
-rw-rw----  1 mysql  mysql   75254 Mar  6 06:49 help_keyword.MYD
-rw-rw----  1 mysql  mysql   15360 Mar  6 06:49 help_keyword.MYI
-rw-rw----  1 mysql  mysql    8612 Mar  6 06:49 help_keyword.frm
-rw-rw----  1 mysql  mysql    6624 Mar  6 06:49 help_relation.MYD
-rw-rw----  1 mysql  mysql   13312 Mar  6 06:49 help_relation.MYI
-rw-rw----  1 mysql  mysql    8630 Mar  6 06:49 help_relation.frm
-rw-rw----  1 mysql  mysql  269424 Mar  6 06:49 help_topic.MYD
-rw-rw----  1 mysql  mysql   17408 Mar  6 06:49 help_topic.MYI
-rw-rw----  1 mysql  mysql    8770 Mar  6 06:49 help_topic.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 host.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 host.MYI
-rw-rw----  1 mysql  mysql    9416 Mar  6 06:49 host.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 proc.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 proc.MYI
-rw-rw----  1 mysql  mysql    9691 Mar  6 06:49 proc.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 procs_priv.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 procs_priv.MYI
-rw-rw----  1 mysql  mysql    8875 Mar  6 06:49 procs_priv.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 tables_priv.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 tables_priv.MYI
-rw-rw----  1 mysql  mysql    8947 Mar  6 06:49 tables_priv.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 time_zone.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 time_zone.MYI
-rw-rw----  1 mysql  mysql    8636 Mar  6 06:49 time_zone.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 time_zone_leap_second.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 time_zone_leap_second.MYI
-rw-rw----  1 mysql  mysql    8624 Mar  6 06:49 time_zone_leap_second.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 time_zone_name.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 time_zone_name.MYI
-rw-rw----  1 mysql  mysql    8606 Mar  6 06:49 time_zone_name.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 time_zone_transition.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 time_zone_transition.MYI
-rw-rw----  1 mysql  mysql    8686 Mar  6 06:49 time_zone_transition.frm
-rw-rw----  1 mysql  mysql       0 Mar  6 06:49 
time_zone_transition_type.MYD
-rw-rw----  1 mysql  mysql    1024 Mar  6 06:49 
time_zone_transition_type.MYI
-rw-rw----  1 mysql  mysql    8748 Mar  6 06:49 
time_zone_transition_type.frm
-rw-rw----  1 mysql  mysql     208 Mar  6 06:49 user.MYD
-rw-rw----  1 mysql  mysql    2048 Mar  6 06:49 user.MYI
-rw-rw----  1 mysql  mysql   10330 Mar  6 06:49 user.frm






Dan Nelson 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 :)
>