Aborted connection 3 to db: 'unconnected' user: 'Cpanel::MysqlUtils::Unprivileged' host: 'localhost' (Got an error writing communication packets)

[HaNi Ghaith]

Hi,
A customer tried to install MariaDB to his server, But that corrupted MySQL/MariaDB
And none of the cPanel channels can connect to MySQL anymore so I reinstalled it using the following:


mysqldump –all-database > all_databases.sql
service mysql stop
mv -v /var/lib/mysql{,.Backup.`date +%F.%T`}
mv -v /etc/my.cnf{,.Backup.`date +%F.%T`}
mysql_install_db
chown -R mysql.mysql /var/lib/mysql
service mysql start

Then reset mysql root password through WHM.
WHM >> SQL Services >> Reset MySQL Root Password



/usr/local/cpanel/bin/hulkdsetup
/usr/local/cpanel/bin/leechprotectinstall –force
/usr/local/cpanel/restoregrants –db=mysql –cpuser=USERNAME –all


The databases worked and the server was able to connect to them
But when I try to access phpmyadmin I see a blank page.
When I try to restart mysql I see the following:


/scripts/restartsrv_mysql
Waiting for “mysql” to start ……waiting for “mysql” to initialize ………finished.

Service Status
mariadb (/usr/sbin/mariadbd) is running as mysql with PID 130124 (systemd+/proc check method).

Warning: The unit file, source configuration file or drop-ins of mariadb.service changed on disk. Run 'systemctl daemon-reload' to reload units.
Startup Log
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:27 0 [Note] InnoDB: 10.6.12 started; log sequence number 1260647474; transaction id 14654
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:27 0 [Note] Plugin 'FEEDBACK' is disabled.
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:27 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:27 0 [Note] Server socket created on IP: '0.0.0.0'.
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:27 0 [Note] Server socket created on IP: '::'.
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:27 0 [Note] /usr/sbin/mariadbd: ready for connections.
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: Version: '10.6.12-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
Apr 15 10:58:27 207-231-110-144.cprapid.com systemd[1]: Started MariaDB 10.6.12 database server.
Apr 15 10:58:27 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:27 0 [Note] InnoDB: Buffer pool(s) load completed at 230415 10:58:27
Apr 15 10:58:29 207-231-110-144.cprapid.com mariadbd[130124]: 2023-04-15 10:58:29 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'Cpanel::MysqlUtils::Unprivileged' host: 'localhost' (Got an error writing communication packets)


The contents of the my.cnf file


# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
#
# Remove leading # to revert to previous value for default_authentication_plugin,
# this will increase compatibility with older clients. For background, see:
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin
# default-authentication-plugin=mysql_native_password

[mysql.server]
user=mysql
basedir=/var/lib

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_allowed_packet=268435456
open_files_limit=40000



Any suggestions?

 

[andrew.n]

Have a look at /usr/local/cpanel/logs/error_log to see why PHPMyAdmin is showing blank.

 

[cPRex]

It might be easiest to reinstall PHPMyAdmin to see if that restores the connection:

https://support.cpanel.net/hc/en-us/articles/4406019665559-How-to-reinstall-phpMyAdmin

but that aborted connection likely indicates an issue with the PHPMyAdmin connection strings after the MySQL changes.