This is an automated archive.

The original was posted on /r/mysql by /u/WorstNormalForm on 2023-07-03 00:18:38+00:00.

I recently installed MySQL Server 8.0.33 from a zip file on Windows 10 and manually went through all the installation steps (creating option file, initializing data directory, etc). Specifically I initialized with

bin/mysqld --initialize --console

and successfully started the server for the first time with

C:\Mysql8\bin\mysqld --console

The problem is that if I simply use “C:\Mysql8\bin\mysqld” without either specifying “–console” or “–log-error” on the command line (for the error log destination) then nothing happens and nothing is written to either the default error log file (Host-PC.err) or the custom path error log file when I explicitly specify one in my config file.

I’m not sure if it’s a syntax issue in the config file or if there’s some other obvious step that I missed.

Config file:

[client]
port=3307 
socket=MYSQL8

[mysqld]
port=3307 
socket=MYSQL8

basedir=C:/Mysql8
datadir=C:/Mysql8/data 
secure_file_priv=C:/Mysql8/mysql-files

general_log=1
slow_query_log=1

log-error=C:/Mysql8/data/mysql8-error.err
general_log_file=C:/Mysql8/data/mysql8-general.log
slow_query_log_file=C:/Mysql8/data/mysql8-slow.log

sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb 
innodb_buffer_pool_size=2032M 
innodb_log_file_size=50M