Softaculous


Topic : MYSQL starts then stops ver 3.9


Posted By: aldridgeb on June 16, 2020, 4:47 am
When I open AMPPS and try to start MYSQL it starts then 2 minutes later it stops.

LOG FILES:

2020-06-16T04:38:54.029773Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 3084
2020-06-16T04:39:32.178171Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:39:32.182563Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:39:32.185413Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:39:32.796042Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:43:52.791509Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 3640
2020-06-16T04:44:34.238213Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:44:34.253800Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:44:34.255135Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:44:34.953925Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:47:05.619467Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 1348
2020-06-16T04:47:20.732323Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:47:20.734411Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:47:20.735686Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:47:21.366901Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:47:57.251765Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 1804
2020-06-16T04:48:07.890688Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:48:07.892847Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:48:07.894139Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:48:08.438205Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.
2020-06-16T04:48:18.342913Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe (mysqld 8.0.18) starting as process 5528
2020-06-16T04:48:28.099683Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').
2020-06-16T04:48:28.101792Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-06-16T04:48:28.103065Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-06-16T04:48:28.692026Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps_A\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18)  MySQL Community Server - GPL.

Posted By: aldridgeb on June 16, 2020, 4:51 am | Post: 1
And FYI I have already tried the innodb_force_recovery = 1

Powered By AEF 1.0.8 © 2007-2008 Electron Inc.