Dcunningham: /* In my.conf */

2015-06-11T04:44:57Z

In my.conf

← Older revision		Revision as of 04:44, 11 June 2015
Line 20:		Line 20:
	Use "quit" to exit the mysql console.		Use "quit" to exit the mysql console.

	==In my.conf==		==In my.conf (all Mysql versions)==

	* Create the log file and set permissions:		* Create the log file and set permissions:

Dcunningham: /* On the fly */

2015-06-11T04:44:37Z

On the fly

← Older revision		Revision as of 04:44, 11 June 2015
Line 1:		Line 1:
	==On the fly==		==On the fly (Mysql 5.1 and above)==

	On the mysql client command line:		On the mysql client command line:

Dcunningham: Created page with "==On the fly== On the mysql client command line: touch /var/log/mysql.log chown mysql /var/log/mysql.log mysql -u root enswitch -p At the mysql co..."

2015-02-25T00:38:39Z

Created page with "==On the fly== On the mysql client command line: <code><pre> touch /var/log/mysql.log chown mysql /var/log/mysql.log mysql -u root enswitch -p </pre></code> At the mysql co..."

New page

==On the fly==

On the mysql client command line:

<code><pre>
touch /var/log/mysql.log
chown mysql /var/log/mysql.log
mysql -u root enswitch -p
</pre></code>

At the mysql console type:
<code><pre>
SET GLOBAL general_log_file = '/var/log/mysql.log';
SET GLOBAL general_log = 1;
</pre></code>

Make the test call, and then to disable logging type at the mysql console:
<code><pre>SET GLOBAL general_log = 0;</pre></code>

Use "quit" to exit the mysql console.

==In my.conf==

* Create the log file and set permissions:
<code><pre>
touch /var/log/mysql.log
chown mysql /var/log/mysql.log
</pre></code>

* Edit /etc/mysql/my.conf or /etc/my.conf (whichever exists on your system) and add or uncomment the lines:
<code><pre>
general_log_file = /var/log/mysql.log
general_log = 1
</pre></code>

* Save and exit your text editor.

* Run:
<code><pre>/etc/init.d/mysqld restart</pre></code>

* After you've obtained the information required remember to comment out the logging lines again and restart MySQL, otherwise the log file will grow extremely large. It does not wrap itself.

Enabling Mysql Logging - Revision history

Dcunningham: /* In my.conf */

Dcunningham: /* On the fly */

Dcunningham: Created page with "==On the fly== On the mysql client command line: `touch /var/log/mysql.log chown mysql /var/log/mysql.log mysql -u root enswitch -p` At the mysql co..."

Enabling Mysql Logging - Revision history

Dcunningham: /* In my.conf */

Dcunningham: /* On the fly */

Dcunningham: Created page with "==On the fly== On the mysql client command line: touch /var/log/mysql.log chown mysql /var/log/mysql.log mysql -u root enswitch -p At the mysql co..."

Dcunningham: Created page with "==On the fly== On the mysql client command line: `touch /var/log/mysql.log chown mysql /var/log/mysql.log mysql -u root enswitch -p` At the mysql co..."