Home  >  Article  >  Database  >  How to change the path of the log file in mysql?

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

青灯夜游
青灯夜游Original
2020-10-05 09:54:453154browse

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

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

Then connect to the database in the CMD command window

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

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

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

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

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

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn