MySQL

MySQL is a popular, free software relational database management system. It is often used in conjunction with web applications (such as many PHP sites), but has gained many more enterprise-level features since its start in 1994.

Installation
Before installing, carefully consider the USE flags that influence the package deployment and features. The following table gives an overview of the package' supported USE flags:

Once the proper USE flags have been set, install :

To have the database(s) started automatically at boot, add the mysql init script to the default runlevel:

After configuring the database(s) - which is mentioned later in this document - start the mysql service:

Preliminary configuration
The MySQL package maintainers (in Gentoo) will help you set up MySQL through the configuration option in the ebuild.

The configuration will create a database, set proper permissions on it and assist you in creating a good root password (this is for the MySQL root account, which is not related to the Linux root account).

To purge mysql of anonymous users and test databases.

In-database configuration
When the database is up and running, you can connect to it using the mysql client application.

Once connected, you can launch queries as well as administrative commands.

External resources

 * Official MySQL Community Edition documentation