From owner-freebsd-questions@FreeBSD.ORG Tue Mar 6 21:56:33 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 036B516A406 for ; Tue, 6 Mar 2007 21:56:33 +0000 (UTC) (envelope-from admin2@enabled.com) Received: from typhoon.enabled.com (typhoon.enabled.com [216.218.220.21]) by mx1.freebsd.org (Postfix) with ESMTP id DC58813C4A6 for ; Tue, 6 Mar 2007 21:56:32 +0000 (UTC) (envelope-from admin2@enabled.com) Received: from [172.23.10.40] (nat-service4.juniper.net [66.129.225.151]) (authenticated bits=0) by typhoon.enabled.com (8.14.0/8.14.0) with ESMTP id l26LtUWx068616 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Tue, 6 Mar 2007 13:55:31 -0800 (PST) (envelope-from admin2@enabled.com) Message-ID: <45EDE354.8040508@enabled.com> Date: Tue, 06 Mar 2007 13:55:32 -0800 From: Noah User-Agent: Thunderbird 1.5.0.10 (Macintosh/20070221) MIME-Version: 1.0 To: Dan Nelson 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> In-Reply-To: <20070306215038.GH86959@dan.emsphone.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: Vince Hoffman , =?ISO-8859-1?Q?Bj=F6rn_K=F6nig?= , User Questions Subject: Re: upgraded 6.2 and mysql lost all privileges X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 06 Mar 2007 21:56:33 -0000 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 :) >