How to change the path of the log file in mysql?

We all know that the MySQL log file is generally located at:/var/log/mysqld.log. The following will teach you how to modify the location of the MySQL log file.

Method/steps:

First use the "win r" shortcut key to open the "Run" window, enter "cmd" and press Enter to open CMD

Then connect to the database in the CMD command window

Then, we will find that the MySQL log bit is specified, in /etc/my I can't change it in .cnf.

chkconfig --list found that it was specified by chkconfig on, which I got from

vim /etc/init.d/mysqld Know that the configuration here

can be changed here~

Recommended tutorial: mysql video tutorial

The above is the detailed content of How to change the path of the log file in mysql?. For more information, please follow other related articles on the PHP Chinese website!