Date: Tue, 06 Mar 2007 13:55:32 -0800 From: Noah <admin2@enabled.com> To: Dan Nelson <dnelson@allantgroup.com> Cc: Vince Hoffman <jhary@unsane.co.uk>, =?ISO-8859-1?Q?Bj=F6rn_K=F6nig?= <bjoern.koenig@alpha-tierchen.de>, User Questions <freebsd-questions@freebsd.org> Subject: Re: upgraded 6.2 and mysql lost all privileges Message-ID: <45EDE354.8040508@enabled.com> In-Reply-To: <20070306215038.GH86959@dan.emsphone.com> References: <45EDB82D.2040300@enabled.com> <45EDBBB5.7090600@alpha-tierchen.de> <45EDCBF6.6040704@enabled.com> <45EDD60B.2020006@unsane.co.uk> <45EDE08F.3080707@enabled.com> <20070306215038.GH86959@dan.emsphone.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 :) >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?45EDE354.8040508>