MySQL Server Configuration creating error

> systemctl restart mysql Job for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details.

This won’t output anything.

– Logs begin at Tue 2021-12-07 17:27:40 EST. –

Dec 07 18:17:01 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 11.

Dec 07 18:17:02 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:02 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 12.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 13.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 14.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 15.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 16.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:15 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:15 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:15 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:16 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 17.

Dec 07 18:17:16 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:16 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 18.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 19.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:22 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:23 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 20.

Dec 07 18:17:23 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:23 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 21.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:27 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:27 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:27 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:28 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 22.

Dec 07 18:17:28 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:28 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 23.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 24.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 25.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:36 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:36 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:36 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:37 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 26.

Dec 07 18:17:37 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:37 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 27.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:41 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:41 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:41 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:42 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 28.

Dec 07 18:17:42 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:42 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 29.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 30.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:48 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:48 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:48 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:49 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 31.

Dec 07 18:17:49 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:49 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 32.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 33.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 34.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:57 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:57 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:57 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:58 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 35.

Dec 07 18:17:58 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:58 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 36.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 37.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 38.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 39.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 40.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 41.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 42.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 43.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 44.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 45.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 46.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 47.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 48.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 49.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

I just copied part of it, it’s very long.

Pretty sure this is not the Ubuntu MySQL package. Check to see what mysql packages are installed with dpkg -l | grep -i mysql. If it is a third party package (including the one provided by the MySQL team), it is not supported. You’re on your own with third party packages…Virtualmin will support it, but it will not be configured correctly out of the box to use it (and I don’t recommend you use it, if you don’t really know what you’re doing).

If this is not the Ubuntu MySQL package (as I’m pretty confident it is not) you should start with a fresh OS install without third party packages installed, instead of whatever this is.

Huh, actually, it does appear the Ubuntu standard package does refer to itself that way. That’s new-ish, I think.

Nevermind. I dunno what’s going on, if you have the standard mysql-server package.

I still need to see a useful error message. Looks like you can find other logs in /var/log/mysql, probably error.log.

Well, I will have to ask that question to the server provider as they provide the installation software.

OK, I just read this

It’s a red herring, and I’m probably wrong. I tested on a local Ubuntu install, and their MySQL package does now call itself MySQL Community Server. That used to only show up in the MySQL team’s build.

How to access this log and error log?

2021-12-07T23:25:57.172367Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:25:57.349802Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:25:57.465771Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:25:57.465798Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:25:57.466497Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:25:57.466527Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:25:57.468719Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:25:57.469020Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:25:58.941200Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:25:59.423170Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86036
2021-12-07T23:25:59.431670Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:25:59.633293Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:25:59.791194Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:25:59.791221Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:25:59.791831Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:25:59.791859Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:25:59.794168Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:25:59.794432Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:01.226014Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:01.915143Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86086
2021-12-07T23:26:01.923651Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:02.102747Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:02.214471Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:02.214495Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:02.215104Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:02.215131Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:02.217083Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:02.217356Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:03.706447Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:04.175340Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86136
2021-12-07T23:26:04.184503Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:04.364374Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:04.489951Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:04.489975Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:04.490797Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:04.490828Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:04.492823Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:04.493098Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:05.964710Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:06.650081Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86188
2021-12-07T23:26:06.658213Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:06.837134Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:06.950518Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:06.950553Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:06.951488Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:06.951524Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:06.954087Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:06.954412Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:08.425726Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:08.900912Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86239
2021-12-07T23:26:08.909326Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:09.088924Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:09.200770Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:09.200794Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:09.201471Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:09.201499Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:09.203347Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:09.203623Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:10.682694Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:11.146939Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86289
2021-12-07T23:26:11.154934Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:11.330340Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:11.436900Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:11.436925Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:11.437733Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:11.437762Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:11.439505Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:11.439806Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:12.920042Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:13.390190Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86339
2021-12-07T23:26:13.398180Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:13.579291Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:13.697556Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:13.697584Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:13.698273Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:13.698303Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:13.700687Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:13.701025Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:15.186024Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:15.677327Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86389
2021-12-07T23:26:15.686397Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:15.894735Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:16.077398Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:16.077433Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:16.078336Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:16.078374Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:16.080945Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:16.081300Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:17.502328Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:18.154621Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86439
2021-12-07T23:26:18.163031Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:18.341359Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:18.457291Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:18.457319Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:18.458002Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:18.458033Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:18.460006Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:18.460299Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:19.936326Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:20.398864Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86489
2021-12-07T23:26:20.407085Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:20.586352Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:20.714544Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:20.714574Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:20.715244Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:20.715273Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:20.717080Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:20.717413Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:22.204695Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:22.699765Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86539
2021-12-07T23:26:22.708798Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:22.916200Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:23.033022Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:23.033047Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:23.033753Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:23.033783Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:23.035661Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:23.035931Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:24.518123Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:25.192357Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86589
2021-12-07T23:26:25.201548Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:25.402079Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:25.521456Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:25.521491Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:25.522380Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:25.522422Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:25.525128Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:25.525516Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:26.996469Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:27.659930Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86639
2021-12-07T23:26:27.668131Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:27.852423Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:27.974177Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:27.974208Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:27.974927Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:27.974956Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:27.977178Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:27.977495Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:29.454696Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:29.921546Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86689
2021-12-07T23:26:29.930515Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:30.116119Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:30.223451Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:30.223475Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:30.224073Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:30.224100Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:30.225850Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:30.226109Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:31.708985Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:32.169508Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86739
2021-12-07T23:26:32.178083Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:32.363289Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:32.467689Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:32.467714Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:32.468320Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:32.468347Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:32.470226Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:32.470486Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:33.952985Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:34.423155Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86789
2021-12-07T23:26:34.432566Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:34.610948Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:34.728529Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:34.728561Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:34.729340Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:34.729377Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:34.732014Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:34.732309Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:36.212695Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:36.895571Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86839
2021-12-07T23:26:36.903677Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:37.078717Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:37.187850Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:37.187876Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:37.188465Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:37.188493Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:37.190378Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:37.190639Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:38.667548Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:39.138335Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86889
2021-12-07T23:26:39.146522Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:39.326493Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:39.445091Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:39.445115Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:39.445742Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:39.445771Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:39.447845Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:39.448151Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:40.919767Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:41.428343Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86939
2021-12-07T23:26:41.437364Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:41.615788Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:41.733215Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:41.733241Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:41.733892Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:41.733923Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:41.735841Z 0 [ER

I only copied part of the log.

So, there’s the error. This option was removed in MySQL 8.

https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed

The MySQL module in Webmin, I guess, shouldn’t let you set that option since it doesn’t exist…but, since it doesn’t exist you don’t need to set it. So, remove it from your my.cnf and restart mysql.

How do I remove it please?

Should be in my.cnf file

Sorry short break in topic:
To be sure for some information

You did write Contabo , there you did the choice for Operating system and version yes?
Preinstalled yes?
You also choose a Control panel there as for example Webmin preinstalled yes or no?

Only to get things right for the Support from Joe here , that you don’t have some preinstalled things he don’'t expect.

I know Contabo does some if you choose those in VPS…

And yes i know you did write in start topic some. :wink:

Just to be 100% sure you didn’t start with some preinstalled things before you do…
Or you use kind off their (pre) Image (s) for setup ?

I think the problem is understood, @jotst. No need to make it more complicated.

@jfeuzeu edit /etc/my.cnf and remove that line. It’s possible that removing the value you added in the Webmin MySQL module will also remove it, but I’m not confident of that…I don’t remember how it deals with unsetting previously set values…

I’ve filed a ticket for making Webmin’s MySQL module aware of this change, so it won’t make it so easy for users to break their configuration. MySQL 8 removes options · Issue #1561 · webmin/webmin · GitHub

1 Like

No Pre-install things. I wrote down the steps of what I did exactly.

1 Like

Yup that is why i did post the warning here! ( but to be honnest ofcourse i don’t know that part about webmin )

I was once strugling after update Mariadb , that the strict is default on in newer versions, therefore if do update for mainversion , but even other updates it takes more time but better read changelogs and understand them. Even then you could run into things not knowing how APP or plugin Developers programmed some, real live testing after updates of your apps is also important.
Using different versions of Database in restored (if backup is with other version) sometimes so… :frowning:

TIP:
For users and or Server admins, look in your own config files before reading (BIG) changelogs for updates, that saves time to know the things your are using. And after updating or installed newer versions then before check log files also extra.

  1. I entered 16 MB in the Query cache size in bytes field and selected “Default”, 512MB in the Maximum packet size filed and selected “Default”, and 16 kB in the MyISAM sort buffer size field and selected “Default” 2. When I clicked on “Save and Restart my Sql” I got the error below

I asked in other thread if MySQL was working before you made those changes. Looking at your check configuration stats in said thread, it was indeed working as it says ‘MySQL up and running’. So if default install was working. Remove the entries you added!

The error message posted in this thread clearly states the query_cache_size as being invalid.

2 Likes

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.