Please read "Security" section of the manual to find out how to run mysqld as root

While performing cPanel crash drive recovery or Full Disaster Recovery of WHM panel on AlmaLinux 8 in rescue mode using the following URL:

Full Disaster Recovery | cPanel & WHM Documentation

https://docs.cpanel.net/knowledge-base/general-systems-administration/full-disaster-recovery/

In some circumstances, experienced system administrators may need to completely restore a server from a crashed or failed hard drive.

Normally, we use the following command to start MySQL on CentOS 6 and 7:

Code:

test -f /etc/sysconfig/mysql && source /etc/sysconfig/mysql; /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid ${MYSQLD_OPTS}

For almalinux, we use the following command to start MySQL:

Code:

/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql ${MYSQLD_OPTS}

However, on AlmaLinux system, if you are unable to start MySQL using the above command and encountering the following error while starting MySQL version 8 in rescue mode:

Code:

{24x7}[root@rescue-customer-eu /]#/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql ${MYSQLD_OPTS}
2023-08-02T09:38:07.139036Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2023-08-02T09:38:07.139050Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 23912
2023-08-02T09:38:07.140714Z 0 [ERROR] [MY-010123] [Server] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
2023-08-02T09:38:07.140925Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
2023-08-02T09:38:07.140857Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-08-02T09:38:07.141189Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34)  MySQL Community Server - GPL.

To resolve this, please use the following command to start MySQL and run as the root user:

Code:

/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql ${MYSQLD_OPTS} --user=root

That's it.

Announcement