Difference between revisions of "Package:MySQL"
Threesixes (talk | contribs) m (add media) |
|||
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 user add the following entry to your mysql configuration file (/etc/mysql/my.cnf). | |||
<console>###i## echo "innodb_use_native_aio = 0" >> /etc/mysql/my.cnf | |||
== Media == | == Media == |
Revision as of 01:38, October 15, 2014
![Ebuild.png](/images/8/8b/Ebuild.png)
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 user add the following entry to your mysql configuration file (/etc/mysql/my.cnf). <console>###i## echo "innodb_use_native_aio = 0" >> /etc/mysql/my.cnf
Media