Shulou(Shulou.com)05/31 Report--

Editor to share with you where to see the mysql error log, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql error log is generally installed under the data directory, is the extension ".err" file, find method: 1, log in to mysql;2, execute the "SHOW VARIABLES LIKE 'log_error'" command to get the path of the error log file.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

Error log (Error Log) is one of the most commonly used logs in MySQL, which mainly records the information in the process of starting and stopping the MySQL server, the failures and anomalies occurred during the operation of the server, and so on.

Location of mysql error log

Under windows, the error log files are usually located in the data directory under the installation directory. Files with .err extension can also be checked by opening the my.ini file in the installation directory.

How to find the error log (get the path)

1. Log in to mysql

Connect to the MySQL database server

C:\ Users\ Administrator > mysql-u root-p

2. You can view the directory and file name information where the error log file is located through the SHOW command.

Mysql > SHOW VARIABLES LIKE 'log_error' +-+ | Variable_name | Value | + -+-- + | log_error | C:\ ProgramData\ MySQL\ MySQL Server 5.7\ Data\ LAPTOP-UHQ6V8KP.err | +-+ -+ 1 row in set 1 warning (0.04 sec)

As you can see, my mysql installation path is "C:\ ProgramData\ MySQL\ MySQL Server 5.7\", so the error log file is under "C:\ ProgramData\ MySQL\ MySQL Server 5.7\ Data\".

The above is all the contents of the article "where to read the mysql error Log". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.