mysql is not started after restart server

mh_bhatti

please help me I restarted my server after that mysql has not been started I tried many times, and anybody helps me, there are my 2 sites that have been hosted on it, and I am very frustrated about it

aaPanel_Kern

mh_bhatti
Hi, please check the mysql log. What error content is displayed?
cat /www/server/data/*.err|grep -i -C 10 error

mh_bhatti

2022-07-07T18:52:05.173957Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-07-07T18:52:05.173973Z 0 [Note] Shutting down plugin 'MEMORY'
2022-07-07T18:52:05.173979Z 0 [Note] Shutting down plugin 'CSV'
2022-07-07T18:52:05.173982Z 0 [Note] Shutting down plugin 'sha256_password'
2022-07-07T18:52:05.173984Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-07-07T18:52:05.174114Z 0 [Note] Shutting down plugin 'binlog'
2022-07-07T18:52:05.177477Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

mh_bhatti

please fix it

aaPanel_Kern

mh_bhatti
Hello, can you check the error by executing the command as I said? There is no relevant error in the information you gave, so I can't handle it for you.
cat /www/server/data/*.err|grep -i -C 10 error

mh_bhatti

cat: /www/server/data/exandnext-new.err: Permission denied

it shows me this

aaPanel_Kern

mh_bhatti
Please use root user to view

mh_bhatti

2022-07-07T18:52:03.396474Z 0 [Note] Binlog end
2022-07-07T18:52:03.398547Z 0 [Note] Shutting down plugin 'ngram'
2022-07-07T18:52:03.398566Z 0 [Note] Shutting down plugin 'partition'
2022-07-07T18:52:03.398569Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-07-07T18:52:03.398571Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-07-07T18:52:03.398573Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-07-07T18:52:03.398608Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-07-07T18:52:03.398610Z 0 [Note] Shutting down plugin 'MyISAM'
2022-07-07T18:52:03.400601Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
[opc@exandnext-new ~]$

mh_bhatti

there are too many lines there but copied last few lines,

mh_bhatti

what do I've to do now?

mh_bhatti

i only have private key, or can i sent the error file here download from aapanel

aaPanel_Kern

mh_bhatti
You can also use aapanel's File to view

mh_bhatti

i already checked but found the exact error ive the could you please help me

mh_bhatti

sorrry i could not found the exact error

aaPanel_Kern

mh_bhatti
Please copy the content

mh_bhatti

all content not copied

aaPanel_Kern

mh_bhatti
Hi, can you give us your aapanel information? The server makes a snapshot backup first, if possible, please send it to kern@aapanel.com.
It is recommended to fill in the following
Post link:
aapanel login link address and account password:

mh_bhatti

please check your email kern@aapanel.com ive sent the login information, and hope you will with positive response

mh_bhatti

waiting for your fixation bOSS

aaPanel_Kern

mh_bhatti
hello, have you upgraded the mysql version?
Try executing the following commands to upgrade the mysql library, then restart mysql, and check if there are any errors. Change xxxxxxx to your root password, which can be viewed in "Root passwd" in the Databases interface
/www/server/mysql/bin/mysql_upgrade -u root -p"xxxxxxx" --upgrade-system-tables