Turn on Error Logs in MySQL

Q

How To Turn on Error Logs in MySQL?

✍: FYIcenter.com

A

If you want MySQL to write critical errors into a log file, you can use the "--log-error=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option:

>cd \mysql\bin
>mkdir \mysql\logs
>mysqld --log-error=\mysql\logs\error.log

If there is critical errors, your error log will be pretty empty:

>type \mysql\logs\error.log

20:32:21  InnoDB: Started; log sequence number 0 43665
20:32:21 [Note] mysqld: ready for connections.
Version: '5.0.24-community-log'  socket: ''  port: 3306

 

Server Daemon mysqld Administration in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 180👍, 0💬