The Funtoo Linux project has transitioned to "Hobby Mode" and this wiki is now read-only.
Difference between revisions of "Package:MySQL"
m |
m (Added support for ZFS) |
||
| Line 39: | Line 39: | ||
To automatically remove future history: | To automatically remove future history: | ||
<console>###i## ln -s /dev/null /root/.mysql_history</console> | <console>###i## ln -s /dev/null /root/.mysql_history</console> | ||
== ZFS == | |||
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> | |||
== Media == | == Media == | ||
Revision as of 01:44, October 15, 2014
MySQL
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