sultanworks Hello i have some problem whit mysql , my aa panel is work a long time , and after log time my msql is down for some reason, i'm try reinstall but i ca'nt run my msql db! Any help?
aapanel_power cat /www/server/data/*.err|grep -i -C 10 error hey, post the screenshot of the execution result. What you are looking at is the slow log, not the error log
sultanworks Here i try to reinstall mysql! not install , something wrong with this ,i'm unistall previveous version , and try install new there is notihg wont install! i have problem now all my work , and my databases go down!
aaP_TN Same problem, it started when I updated MySQL. I managed to force uninstall MySQL and like it says above on someone else's comment, it wouldn't install again. I had to COMPLETELY remove MySQL to get a clean install of it. Now that I installed it again, I'm back to square 1. MySQL won't start. All help is appreciated. Looks like its a common issue now.
aaPanel_thisyear aaP_TN Hello, if it can't be started, the server command line will execute the following command cat /www/server/data/*.err|grep -i -C 10 error
aaP_TN aaPanel_thisyear I typed in " mysqld --initialize " and recieved: 2021-04-13T17:05:05.519464Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824. 2021-04-13T17:05:05.519564Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2021-04-13T17:05:05.519643Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) initializing of server in progress as process 24587 2021-04-13T17:05:05.521961Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2021-04-13T17:05:05.521971Z 0 [ERROR] [MY-013236] [Server] The designated data directory /www/server/data/ is unusable. You can remove all files that the server added to it. 2021-04-13T17:05:05.522102Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-04-13T17:05:05.522251Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
