Attempting to start MariaDB as a service results in an error that says:
Windows could not start the MariaDB service on Local Computer
Error 1053: The service did not respond to the start or control request in a timely fashion.
The error log does not show any errors after that start attempt but the server is not started. The error log looks completely normal and contains:
InnoDB: using atomic writes.
2021-02-17 7:05:16 0 [Note] InnoDB: Uses event mutexes
2021-02-17 7:05:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-02-17 7:05:16 0 [Note] InnoDB: Number of pools: 1
2021-02-17 7:05:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-02-17 7:05:16 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2021-02-17 7:05:16 0 [Note] InnoDB: Completed initialization of buffer pool
2021-02-17 7:05:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1051746172,1051746172
2021-02-17 7:05:16 0 [Note] InnoDB: 128 rollback segments are active.
2021-02-17 7:05:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-02-17 7:05:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-02-17 7:05:16 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-02-17 7:05:16 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2021-02-17 7:05:16 0 [Note] InnoDB: 10.5.8 started; log sequence number 1051746283; transaction id 199153
2021-02-17 7:05:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-02-17 7:05:16 0 [Note] InnoDB: Loading buffer pool(s) from c:\ZZ-MariaDB_Data\ib_buffer_pool
2021-02-17 7:05:16 0 [Note] Server socket created on IP: '::'.
2021-02-17 7:05:16 0 [Note] Reading of all Master_info entries succeeded
2021-02-17 7:05:16 0 [Note] Added new Master_info '' to hash table
2021-02-17 7:05:16 0 [Note] c:/mariadb/bin/mysqld: ready for connections.
Version: '10.5.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2021-02-17 7:05:17 0 [Note] InnoDB: Buffer pool(s) load completed at 210217 7:05:17
The INI file being used contains:
[mysqld]
datadir=c:/ZZ-MariaDB_Data
character-set-server=utf8mb4
collation_server = 'utf8mb4_unicode_ci'
default-storage-engine=InnoDB
[client]
plugin-dir=c:/MariaDB/lib/plugin
The Path to executable
setting in Services is c:/mariadb/bin/mysqld --defaults-file=C:/ZZ-MariaDB_Data/my.ini
.
If I run that from a command prompt the server starts properly and everything works as expected. Things only fail when I try to start it from Services.