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

[santosh]

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

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

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

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:

/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:

{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:

/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.

[santosh]

If you have any further questions, please let me know.