MySQL will not start. Error seen when trying to start at the command line.

Products

• Spectrum
• Network Observability

Issue/Introduction

MySQL will not start. No errors seen in the MYSQL.OUT file.

We tried starting MySQl from the command line as follows:

./mysql.exe --defaults-file=../my-spectrum.cnf

We see the following error:

mysqld: Cant read dir of 'E:\win32app\Spectrum\mysql\bin\datadir\' (OS errno 2 - No such file or directory)

Environment

Version: Any
Component: MySQL

Cause

A check of the my-spectrum.cnf file showed the following parameter setting:

secure-file-priv=datadir

The out of the box default parameter setting is as follows:

secure-file-priv=NULL

Resolution

Change the parameter back to the out of the box default setting and MySQl now starts as expected.