Revision as of 01:30, August 28, 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.

root # emerge mysql

MySQL requires configuration upon instillation.

To deploy MySQL:

root # emerge --config dev-db/mysql

to start mysql:

root # rc-service mysql start

to start upon boot:

root # rc-update add mysql

MySQL is by default insecure.

to lock down your MySQL install:

root # mysql_secure_installation

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

@@ Line 5: / Line 5: @@
 |Homepage=http://www.mysql.com/
 }}
-MySQL is the M in the lamp/lemp/llmp stack.
+MySQL is the M in the lamp/lemp/llmp stack.  It is a popular & common database that accepts SQL statements.
+== Installation ==
+<console>###i## emerge mysql</console>
+=== First Run ===
+MySQL requires configuration upon instillation.
+To deploy MySQL:
+<console>###i## emerge --config dev-db/mysql</console>
+=== Init ===
+to start mysql:
+<console>###i## rc-service mysql start</console>
+to start upon boot:
+<console>###i## rc-update add mysql</console>
+=== Secure ===
+==== Lockdown ====
+MySQL is by default insecure.
+to lock down your MySQL install:
+<console>###i## mysql_secure_installation</console>
+==== Logging ====
+By default MySQL logs every action, including leaving plain text passwords in its history file.
+To remove the history file:
+<console>###i## rm /root/.mysql_history</console>
+To automatically remove future history:
+<console>###i## ln -s /dev/null /root/.mysql_history</console>
 {{EbuildFooter}}