The Funtoo Linux project has transitioned to "Hobby Mode" and this wiki is now read-only.
Package:MySQL
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