Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : MySQL not starting



Threaded Mode | Print  

 MySQL not starting, MySQL not starting (3 Replies, Read 20495 times)
WHITELIONX
Group: Member
Post Group: Newbie
Posts: 11
Status:
I had to redownload and install ampps but now mysql won't start error log is as follows

Code
2022-09-15T17:27:01.968814Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2022-09-15T17:27:01.968832Z 0 [System] [MY-010116] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe (mysqld 8.0.30) starting as process 25712
2022-09-15T17:27:01.977449Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-09-15T17:27:02.200614Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-09-15T17:27:02.310919Z 1 [Warning] [MY-011018] [InnoDB] Skip updating information_schema metadata in InnoDB read-only mode.
2022-09-15T17:27:02.311394Z 1 [Warning] [MY-010005] [Server] Skip re-populating collations and character sets tables in InnoDB read-only mode.
2022-09-15T17:27:02.323483Z 2 [Warning] [MY-011018] [Server] Skip updating information_schema metadata in InnoDB read-only mode.
2022-09-15T17:27:02.324948Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode.
2022-09-15T17:27:02.325406Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode.
2022-09-15T17:27:02.432426Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-09-15T17:27:02.432802Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-09-15T17:27:02.437291Z 0 [ERROR] [MY-000067] [Server] unknown variable 'set-variable=max_connections=1500'.
2022-09-15T17:27:02.439878Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-09-15T17:27:03.699113Z 0 [System] [MY-010910] [Server] C:\Program Files\Ampps\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.30)  MySQL Community Server - GPL.
IP: --   

MySQL not starting
WHITELIONX
Group: Member
Post Group: Newbie
Posts: 11
Status:
I am using Windows 11
IP: --   

MySQL not starting
bjorn_ove_bremnes
Group: Member
Post Group: Newbie
Posts: 1
Status:
I have the same issue. Could anyone please update me on this?

Also on Win 11 Pro
IP: --   

MySQL not starting
adeshmrane
Group: AMPPS Team
Post Group: Newbie
Posts: 12
Status:

If your logs also do have the same line as "unknown variable 'set-variable=max_connections=1500'. "

then please remove that line from the configuration file

Due to the configuration error, the MySQL server is aborting.
If you have any different errors then please share your logs here
or you can open a support ticket at https://softaculous.deskuss.com/open.php?topicId=3 for fatser solution of your issue.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
2 guests, 0 users.


All times are GMT. The time now is July 19, 2024, 12:41 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.048