Difference between revisions of "Package:MySQL"

From Funtoo
Jump to navigation Jump to search
m
(Undo revision 6272 by Jwpierce3 (talk))
Line 41: Line 41:


== ZFS ==
== ZFS ==
If you are a ZFS user, add the following to the mysql configuration file (/etc/mysql/my.cnf):
If you are a zfs add the following to the mysql configuration file (/etc/mysql/my.cnf).
<console>###i## echo "innodb_use_native_aio = 0" >> /etc/mysql/my.cnf</console>
<console>###i## echo "innodb_use_native_aio = 0" >> /etc/mysql/my.cnf</console>



Revision as of 01:56, October 15, 2014

MySQL

   Tip

We welcome improvements to this page. To edit this page, Create a Funtoo account. Then log in and then click here to edit this page. See our editing guidelines to becoming a wiki-editing pro.

MySQL is the M in the lamp/lemp/llmp stack. It is a popular & common database that accepts SQL statements.

Installation

root # emerge mysql

First Run

MySQL requires configuration upon instillation.

To deploy MySQL:

root # emerge --config dev-db/mysql

Init

to start mysql:

root # rc-service mysql start

to start upon boot:

root # rc-update add mysql

Secure

Lockdown

MySQL is by default insecure.

to lock down your MySQL install:

root # mysql_secure_installation

Logging

By default MySQL logs every action, including leaving plain text passwords in its history file.

To remove the history file:

root # rm /root/.mysql_history

To automatically remove future history:

root # ln -s /dev/null /root/.mysql_history

ZFS

If you are a zfs add the following to the mysql configuration file (/etc/mysql/my.cnf).

root # echo "innodb_use_native_aio = 0" >> /etc/mysql/my.cnf

Media