Differences

This shows you the differences between two versions of the page.

--- server:mysql [2012/08/08 09:23] – external edit
+++ server:mysql [2014/12/12 21:03] (current) – [CentOS 5.6 install mysql 5.6] admin
@@ Line 31: / Line 31: @@
   mysql db_name < ./db_dump_to.sql -u root -p
+==== MYSQL query logging ====
+<note>Logging sollte nach Verwendung wieder deaktiviert werden</note>
+Zeige aktuelle Logging Einstellung
+  show variables LIKE 'general_log';
+Zeige alle verfügbaren Variablen
+  show variables;
+Verwendete Logfile
+  show variables LIKE 'general_log_file';
+Aktivieren des Loggings
+  SET GLOBAL general_log = 'ON';
+Deaktivieren des Loggings
+  SET GLOBAL general_log = 'OFF';
+==== CentOS 5.6 install mysql 5.6 ====
+Sources:
+  * http://www.servermule.com.au/help/linux/install-lemp-mysql-5-6-centos-6/
+  * http://bugs.mysql.com/bug.php?id=70431
+Install mysql repo and disable it by default:
+  rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
+  sed -i s'/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo
+Install mysql 5.6
+  yum -y --enablerepo=mysql56-community install mysql-server
+Add the following in your my.cnf [mysqld] section:
+  skip-grant-tables