I restarted the server and now I can't start MySQLd service

galal3336 Try to delete ./mysql-bin.000025 from the content of this /www/server/data/mysql-bin.index file, and then restart mysql. Can it be solved? It can be operated in the "File" interface of the panel cp /www/server/data/mysql-bin.index /www/server/data/mysql-bin.index_ /etc/init.d/mysqld restart

galal3336 Hi Use the ssh tool to execute the command and check the mysql error log: cat /www/server/data/*.err|grep -i -C 10 error

aaPanel_Kern mysqld: File './mysql-bin.000025' not found (OS errno 2 - No such file or directory) 2023-07-25T02:42:46.623943Z 0 [ERROR] [MY-010958] [Server] Could not open log file. 2023-07-25T02:42:46.625214Z 0 [ERROR] [MY-010041] [Server] Can't init tc log 2023-07-25T02:42:46.627527Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-07-25T02:42:47.662117Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.

aaPanel_Kern solved by deleting ./mysql-bin.000025 thanks again

I have the same problem This is the log /www/server/mysql/bin/mysqld(+0x66df6e)[0x558e0d302f6e] /www/server/mysql/bin/mysqld(+0x66e453)[0x558e0d303453] /www/server/mysql/bin/mysqld( Z20buf_page_io_completeP10buf_page_tb+0x2d6)[0x558e0df67b56] /www/server/mysql/bin/mysqld(+0x12fca0c)[0x558e0df91a0c] /www/server/mysql/bin/mysqld( Z13buf_read_pageRK9page_id_tRK11page_size_t+0x73)[0x558e0df921b3] /www/server/mysql/bin/mysqld( Z16buf_page_get_genRK9page_id_tRK11page_size_tmP11buf_block_tmPKcmP5mtr_tb+0x46f)[0x558e0df65c9f] /www/server/mysql/bin/mysqld( Z31trx_rseg_get_n_undo_tablespacesPm+0x13d)[0x558e0df0063d] /www/server/mysql/bin/mysqld(+0x1238523)[0x558e0decd523] /www/server/mysql/bin/mysqld( Z34innobase_start_or_create_for_mysqlv+0x2bd4)[0x558e0ded0c14] /www/server/mysql/bin/mysqld(+0x110185e)[0x558e0dd9685e] /www/server/mysql/bin/mysqld( Z24ha_initialize_handlertonP13st_plugin_int+0x59)[0x558e0d3905c9] /www/server/mysql/bin/mysqld(+0xc7d656)[0x558e0d912656] /www/server/mysql/bin/mysqld( Z40plugin_register_builtin_and_init_core_sePiPPc+0x1ec)[0x558e0d914a8c] /www/server/mysql/bin/mysqld( Z11mysqld_mainiPPc+0xb90)[0x558e0d33c380] /lib/x86_64-linux-gnu/libc.so.6(+0x29d90)[0x14fb0a658d90] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x80)[0x14fb0a658e40] /www/server/mysql/bin/mysqld(_start+0x25)[0x558e0d3316f5]

Hello, use the ssh tool to execute the command to see if there is any error? cat /www/server/data/*.err|grep -i -C 10 error jaac

Hello, this is not the latest log, the time of your server is incorrect? jaac

aaPanel_Kern Im not sure I was just run the command you gave to me

I suggest you check whether you have modified the mysql log configuration? Check the mysql log for errors jaac

MySQLd service failed to start (after restarting server)

aaP_sabbirhossen1357928046

help me sir

aaPanel_Kern

Hello, what problem did you encounter? Mysql cannot be started?
Is it normal to use this command to start once: /etc/init.d/mysqld start
If it is abnormal, please check the log: cat /www/server/data/*.err|grep -i -C 10 error

aaP_sabbirhossen1357928046

aaP_alimousa13

im delete ./mysql-bin.000025 from the content and i still have that issues

aaP_alimousa13

hello its stop every 5 mints after restart why its not running what is the issues

aaP_hareeshnarayan1982

aaP_alimousa13 you should check the logs for details.

aaP_alimousa13

its no any error in logs

aaP_alimousa13

hello any solutions for that ?

aaP_hareeshnarayan1982

aaP_alimousa13 you have to check log tab not slow log tab.

aaP_alimousa13

hello any solutions for that ?

aaP_alimousa13

aaP_hareeshnarayan1982

aaP_alimousa13

if you don't know on how to setup DB, better to consult an expert or refer mysql document. You are using * as your bind address? if you want to allow all host, bind it with 0.0.0.0. and then try to restart

aaP_alimousa13

????

aaP_hareeshnarayan1982

aaP_alimousa13
MySQL will stop, if there is any issue in configuration. Check thoroughly your configuration and make sure they all are valid by referring with Mysql docs.

aaP_alimousa13

i tired i try everything thing and i still have that issues

aaP_hareeshnarayan1982

aaP_alimousa13

What is your bind address in the configuration?

aaP_alimousa13

how i check that

aaP_alimousa13

we in trouble here 3 week we cant setup WordPress !

aaPanel_Kern

aaP_alimousa13

aaPanel_Kern

Hello, what specific problem did you encounter? It can be seen from the log that it is running normally.
Running multiple mysql programs using different ports

aaP_alimousa13

« Previous Page Next Page »