MySQL 8.0.36 service status says STOPPED not running

Ricosoft

Hello, kindly help check why mysql is not running after installation. i have tried reloading and restarting but still same. see error logs

ed_packet': unsigned value 107374182400 adjusted to 1073741824.
2025-11-13T04:44:36.724053Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2025-11-13T04:44:36.724149Z 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.
2025-11-13T04:44:36.724237Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-11-13T04:44:36.724250Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 188435
2025-11-13T04:44:36.729390Z 0 [Warning] [MY-010161] [Server] You need to use --log-bin to make --binlog-format work.
2025-11-13T04:44:36.754511Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.
2025-11-13T04:44:36.756064Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-11-13T04:44:37.041813Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-11-13T04:44:37.266687Z 0 [Warning] [MY-010161] [Server] You need to use --log-bin to make --binlog-expire-logs-seconds work.
2025-11-13T04:44:37.267644Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-11-13T04:44:37.267668Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-11-13T04:44:37.267906Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use
2025-11-13T04:44:37.267914Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ?
2025-11-13T04:44:37.267925Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-11-13T04:44:38.368074Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.

aaPanel_Kern

Hello, is the problem solved? you can use the ssh tool to execute the command to check it:
curl -k https://www.aapanel.com/script/aapanel_check.sh | bash

Ricosoft

aaPanel_Kern This is what i got
eric@mail:/www$ curl -k https://www.aapanel.com/script/aapanel_check.sh | bash
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- 0:00:09 --:--:-- 0

aaPanel_Kern

It is recommended that you check what program is occupying port 3306
netstat -tulnp|grep 3306

Ricosoft

eric@mail:~$ netstat -tulnp|grep 3306
(No info could be read for "-p": geteuid()=1000 but you should be root.)
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN -
tcp6 0 0 :::3306 :::* LISTEN -

Ricosoft

eric@mail:~$ sudo netstat -tulnp|grep 3306
[sudo] password for eric:
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 52813/mariadbd
tcp6 0 0 :::3306 :::* LISTEN 52813/mariadbd

aaPanel_Kern

Ricosoft
Did you install mariadb using apt/yum command?

ps aux|grep 52813

Ricosoft

No, i installed from aapanel app store, MYSQL

Ricosoft

mysql now running.
This is what i get after successfully added a new roundcube email site

if i tried accessing it via web browser, e.g mail.example.com, i get this below
Oops... something went wrong!
An internal error has occurred. Your request cannot be processed at this time

aaPanel_Kern

Please check what program is running

Ricosoft

aaPanel_Kern eric@mail:~$ sudo netstat -tulnp|grep 3306
tcp6 0 0 :::33060 :::* LISTEN 306912/mysqld
tcp6 0 0 :::3306 :::* LISTEN 306912/mysqld

please can i give you my panel login details so you can look into this

aaPanel_Kern

Ricosoft
Please check what program is running

ps aux|grep 306912

Ricosoft

i am presently trying to reinstall mysql and its taking forever just showing installing..

Ricosoft

re-installation done

eric@mail:~$ sudo ps aux|grep 306912
eric 323676 0.0 0.0 7076 2048 pts/1 S+ 10:34 0:00 grep --color=auto 306912