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!