MYSQL start issue in panel version 7.0.21

aaP_meet.wrteam

sites php
/www/server/panel/class_v2/projectModelV2/safe_detectModel.py:354: SyntaxWarning: invalid escape sequence '\c'
8YoRHZutL8KcT0AZb8zVLoVCETkb84tYz8g94BdY9eAUWAiRRLG2WFEQIPGFh3Lj
/www/server/panel/class_v2/projectModelV2/safe_detectModel.py:494: SyntaxWarning: invalid escape sequence '\d'
UbJuac0dxLiN+5ocS3w2vcQpkn8dApwQCSpUNJvVL4ki6d0aJA//Ac2SPkyYIwfAgUf6JBVCcCT98bY+ZE2IFQ==
/www/server/panel/class_v2/projectModelV2/safe_detectModel.py:2282: SyntaxWarning: invalid escape sequence '\ '
VmVrGQo2zRokW/ZuO9bN64ZTCtjiSIe1Vj/8GYr6HklsXgqIFm1rvMQ60shX/doOVrVv8WO3cooD2wcKDC96q9a2zmQ5c5L9/Bzc+WOnKeYJ5cBoV2/le4Rbqo5HQXPYVfe3Rs3i1Ip6C5LJr+JIlEQl3E/TCPCtNaE7jAWTGg9xqjUWtR/WM9zyuYXQrXhEV9X9pF4HekyneP4KQ/NTNuYuVtr1AxUnEimY9Hjdmq70enAQbOpNnF9drCTzL++N
/www/server/panel/class_v2/database_v2.py:736: SyntaxWarning: invalid escape sequence '\s'
rep = "datadir\s=\s(.+)\n"
/www/server/panel/class_v2/database_v2.py:1968: SyntaxWarning: invalid escape sequence '-'
import_p = public.ExecShell("ps -ef|grep mysql|grep '--force'|grep '{}$'".format(db_name))
/www/server/panel/class_v2/database_v2.py:2712: SyntaxWarning: invalid escape sequence '\s'
mysql_cnf = re.sub("\n#\slog-bin", "\nlog-bin", mysql_cnf)
/www/server/panel/class_v2/database_v2.py:3353: SyntaxWarning: invalid escape sequence '\s'
"GRANT\s([^.]+)\sON\s([^.]+).([^.]+)\s*TO", access_item[0], flags=re.IGNORECASE

gettings this issue unable to start or restart mysql my sites are down please support
aapanel version = 7.0.21
mysql version = 8

here is mysql.service status
root@srv789865:~# sudo systemctl restart mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
root@srv789865:~# ^C
root@srv789865:~# sudo systemctl status mysql.service
× mysql.service - MySQL Community Server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: enabled)
Active: failed (Result: exit-code) since Sat 2025-07-26 05:53:03 UTC; 11min ago
Process: 102392 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Process: 102400 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Main PID: 102400 (code=exited, status=1/FAILURE)
Status: "Server shutdown complete"
CPU: 429ms

Jul 26 05:53:03 srv789865 systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Jul 26 05:53:03 srv789865 systemd[1]: mysql.service: Start request repeated too quickly.
Jul 26 05:53:03 srv789865 systemd[1]: mysql.service: Failed with result 'exit-code'.
Jul 26 05:53:03 srv789865 systemd[1]: Failed to start mysql.service - MySQL Community Server.

aaPanel_Kern

Hello, I suggest you check the mysql log, what is the reason
You can also use this command to check: curl -k https://www.aapanel.com/script/mysql_check.sh | bash

aaP_meet.wrteam

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

mysql-server-8.0/noble-updates,noble-updates,now 8.0.42-0ubuntu0.24.04.2 amd64 [installed,auto-removable]
mysql-server-core-8.0/noble-updates,noble-updates,now 8.0.42-0ubuntu0.24.04.2 amd64 [installed,auto-removable]
There exists mysql installed using apt-get.
panel cannot be managed apt-get installed mysql/mariadb
If you do not use it, please delete it. Before this, please do a server snapshot backup.
Delete command: apt-get remove mysql-server*
rm -f /etc/systemd/system/mysqld.service /etc/systemd/system/mysql.service

i had sudo apt-get remove mysql-server
still not working

aaPanel_Kern

Hello, is it normal now? Is there an error log in startup? You can also reuse this command to check

aaP_meet.wrteam

aaPanel_Kern

aaPanel_Kern Hello, is it normal now? Is there an error log in startup? You can also reuse this command to check

You can also use this command to check: curl -k https://www.aapanel.com/script/mysql_check.sh | bash

aaP_meet.wrteam

Still not working i has backup file of database and tables in .frm & .ibd files i have move to it data directory with proper permissions still not working

Still am waiting for you response.

aaP_meet.wrteam

Are you @Aapanel any support

Or just normal text reply ??

I am waiting for positive reply from past 4 days still nothing helpful support.

aaP_meet.wrteam

curl -k https://www.aapanel.com/script/mysql_check.sh | bash

root@srv789865:~# curl -k https://www.aapanel.com/script/mysql_check.sh | bash
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 4858 100 4858 0 0 32829 0 --:--:-- --:--:-- --:--:-- 33047
mysql data dir: /www/server/data
mysql port: 3306
mysql version: 10.11.10-MariaDB
panel mysqld_safe is not running.
mysql 367105 0.0 2.2 1887032 183768 ? Sl 06:39 0:01 /www/server/mysql/bin/mariadbd --basedir=/www/server/mysql --datadir=/www/server/data --plugin-dir=/www/server/mysql/lib/plugin --user=mysql --skip-grant-tables --log-error=/www/server/data/srv789865.err --open-files-limit=65535 --pid-file=srv789865.pid --socket=/tmp/mysql.sock --port=3306
root@srv789865:~# curl -k https://www.aapanel.com/script/mysql_check.sh | bash
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 4858 100 4858 0 0 13968 0 --:--:-- --:--:-- --:--:-- 14000
mysql data dir: /www/server/data
mysql port: 3306
mysql version: 10.11.10-MariaDB
panel mysql is running

I am unable to open any tables in the database from my side. Could you please try to recover the data and share the .sql backup files with me if possible?

This will help avoid further issues if something goes wrong again.

aaPanel_Kern

Hello,
Database recovery is recommended to find a professional recovery company.
If you have backups, you can try to restore after making a server snapshot backup

aaP_meet.wrteam

The tables that were fixed earlier are still not accessible from my side. I am unable to open any of them.

Could you please check this from your side and, if possible, share the recovered .sql files for all databases with me?

aaPanel_Kern

Have you enabled backup? There will be backup files if it needs to be enabled and run normally
The default backup directory is: /www/backup/database

aaP_meet.wrteam

I cannot access the data in any of the tables