After reviewing the 2 similar post, it won't help my case: I'm using Debian GNU/Linux 11 x86_64(Py3.7.9) What have I tried? Resetting root password wont help Already uninstall and re-install several times Already check if MySQL is running and it is running. Im using 5.5 Also already added and open port 3306 Already check MySQL logs and I got /usr/sbin/mariadbd, Version: 10.6.9-MariaDB-1:10.6.9+maria~deb11-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /run/mysqld/mysqld.sock Time Id Command Argument Removing MariaDB which I didnt install, removing using apt remove mariadb* wont work, It did removed yet but MySQL to stop state and unable to restart. Any help from the support team. Thanks a lot

ERROR to connect database, pls check database status! MYSQL

Upgrace

After reviewing the 2 similar post, it won't help my case:
I'm using Debian GNU/Linux 11 x86_64(Py3.7.9)

What have I tried?

Resetting root password wont help
Already uninstall and re-install several times
Already check if MySQL is running and it is running. Im using 5.5
Also already added and open port 3306
Already check MySQL logs and I got
/usr/sbin/mariadbd, Version: 10.6.9-MariaDB-1:10.6.9+maria~deb11-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /run/mysqld/mysqld.sock Time Id Command Argument
Removing MariaDB which I didnt install, removing using apt remove mariadb* wont work, It did removed yet but MySQL to stop state and unable to restart.

Any help from the support team. Thanks a lot

aaPanel_Kern

Upgrace
Hello, it is recommended to reinstall mysql again.
The reason is that mariadb already exists in your system, so you need to reinstall mysql after apt remove

Upgrace

aaPanel_Kern Same issue,

Upgrace Already uninstall and re-install several times

The mysql stucked in STOP status, unable to restart and start

Upgrace

aaPanel_Kern
The root password set 45d6cee6d45d3c49 successuful 1 Stopping mysqld (via systemctl): mysqld.service. Changing password... 230508 07:53:46 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect. 230508 07:53:46 mysqld_safe Logging to '/var/log/mysql/error.log'. 230508 07:53:46 mysqld_safe Starting mysqld daemon with databases from /www/server/data 230508 07:53:47 mysqld_safe mysqld from pid file /run/mysqld/mysqld.pid ended ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Starting mysqld (via systemctl): mysqld.serviceJob for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details. failed!

aaPanel_Kern

Upgrace
hello panel start mysql using /etc/init.d/mysqld start command
From the logs, it doesn't look like the mysql installed by the panel. Have you modified the mysql configuration?
view mysql log
cat /www/server/data/*.err|grep -i -C 10 error

Upgrace

aaPanel_Kern Have you modified the mysql configuration?
view mysql log

No.

Upgrace

aaPanel_Kern cat /www/server/data/*.err|grep -i -C 10 error

cat: '/www/server/data/*.err': No such file or directory

aaPanel_Kern

aaPanel_Kern hello panel start mysql using /etc/init.d/mysqld start command

Upgrace