From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.50) id 1EUpMH-0008Fn-7y for garchives@archives.gentoo.org; Wed, 26 Oct 2005 17:46:41 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id j9QHjijH031855; Wed, 26 Oct 2005 17:45:44 GMT Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.204]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id j9QHfjba020632 for ; Wed, 26 Oct 2005 17:41:45 GMT Received: by xproxy.gmail.com with SMTP id t11so255081wxc for ; Wed, 26 Oct 2005 10:41:45 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZrdjGSbxaZKFIfQVyvoMqhNaherhU5naeEjjYqI6U+t+cR9lePPhyrKAp+bnAQ3kN6KPCS2RgmCKNCI+MUGUXSfbujMxBJhFcdKDHEGkvc5cg4boPNYIVPJ9kUsciZX56/aHQHJlAZPXOtxyGrDdn7t77IfPMxoTTzUX6yNz2Bc= Received: by 10.64.208.5 with SMTP id f5mr850798qbg; Wed, 26 Oct 2005 10:41:42 -0700 (PDT) Received: by 10.65.254.14 with HTTP; Wed, 26 Oct 2005 10:41:41 -0700 (PDT) Message-ID: <49bf44f10510261041j259f7eaen71ef8347e1a70a7f@mail.gmail.com> Date: Wed, 26 Oct 2005 10:41:41 -0700 From: Grant To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] MySQL 4.1 upgrade questions In-Reply-To: <200510252047.48249.vivo@gentoo.org> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <49bf44f10510251039p58526eb5sa9308d800fbeb93e@mail.gmail.com> <200510252047.48249.vivo@gentoo.org> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by robin.gentoo.org id j9QHfjba020632 X-Archives-Salt: 42791c41-f295-4880-a375-83e59473b809 X-Archives-Hash: f6b629137949ebbebe96ec02364fb8cd > > Hello, I'm upgrading my server from mysql 4.0 to 4.1 by following the > > instructions here: > > > > http://www.gentoo.org/doc/en/mysql-upgrading.xml > > > > I noticed this piece of instruction: > > > > emerge --config =mysql-4.1. > > > > What does that do? From what I remember, I need to password the > > grant table and create a new table for my data with the proper name, > > username, and password. Does that sounds right? Does the emerge > > --config command take you through any of that or do I need to figure > > out (remember) how to do it manually? > > In it's older (and deprecated) form was "ebuild path/name.ebuild > config" . > > Basically it run the pkg_config() function inside the ebuild itself. > > Specifically MySQL pkg_config() actions are the following: > - check that no mysql server are running on the box or die > - check that datadir (/var/lib/mysql) is empty or die > - ask for a password > - install the databases (mysql & test) > - fill the help tables for command line client > - fill the timezone tables > - set the _mysql_ root password Nice, I was using the database named mysql for my data so that fits like a glove with the other software that accesses mysql. The grant tables are in the mysql database, so passwording that database secures my data and the grant tables right? Is it OK to leave the "test" database as is? - Grant -- gentoo-user@gentoo.org mailing list