Re: [gentoo-user] MySQL 4.1 upgrade questions

[Grant <emailgrant@gmail.com>]

> > 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.<micro_version>
> >
> > 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