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 :)
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
