Sometimes it may become necessary, to view logs from MySQL, this can include error logs, slow queries and even general queries altogether. They can be used for troubleshooting a system or enhancing performance.
...
#logging
log-error = "c:/mysql_error.log"
lo log = "c:/general.log"
| Info | ||
|---|---|---|
| ||
Note that you can place these files wherever you want, as long as the folder exists before hand, otherwise mysql will fail to start. |
| Info | ||
|---|---|---|
| ||
These changes are for mysql 5.0, if your version is 5.1 log = "c:/general.log" must be changed to general-log-file = "c:/general.log" |
...
| Info | ||
|---|---|---|
| ||
MySQL 5.6 is the current GA version. Use the following under the mysqld configuration. |
...
|