[gentoo-user] MySQL 4.1 upgrade questions

[gentoo-user] MySQL 4.1 upgrade questions

[Grant]

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?

- Grant

-- 
gentoo-user@gentoo.org mailing list

[gentoo-user] Re: MySQL 4.1 upgrade questions

[Grant]

> 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?
>
> - Grant

Nevermind, that was ridiculously easy.  All I had to do was run emerge
--config and I'm back in business.

- Grant

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] MySQL 4.1 upgrade questions

[Francesco R.]

Alle 19:39, martedì 25 ottobre 2005, Grant ha scritto:
> 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

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] MySQL 4.1 upgrade questions

[Grant]

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

Re: [gentoo-user] MySQL 4.1 upgrade questions

[Francesco R.]

> 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?

For a security hardened database you should drop the test database and 
all users with "%" access. Also you can play with "bind-address" and 
"skip-networking" in the my.cnf
upstream Docs:
http://dev.mysql.com/doc/refman/4.1/en/security.html

What I've understud from your post is that in your config the "mysql" 
database is used to keep your data, this is a dangerous, that database 
is managed in a special way by MySQL (and never minded to keep 
extraneous data).

create your own database with the "CREATE DATABASE name;" SQL command 
than "USE name" to switch to it.

Cheers
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] MySQL 4.1 upgrade questions

[A. Khattri]

On Thu, 27 Oct 2005, Francesco R. wrote:

> For a security hardened database you should drop the test database and
> all users with "%" access. Also you can play with "bind-address" and
> "skip-networking" in the my.cnf

I think bind-address is 127.0.0.1 by default anyway.


-- 

-- 
gentoo-user@gentoo.org mailing list