CentOS7下WHM创建cPanel账户时mysqld版本检测失败求助

问题描述 #

在CentOS7上安装WHM后，创建新账户时遇到以下数据库错误：

Account Creation Status: failed
Cpanel::Exception/(XID rt23j6) The system failed to determine the “mysqld” version.
at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 193.
Cpanel::MysqlUtils::Version::current_mysql_version() called at /usr/local/cpanel/Cpanel/Mysql/Version.pm line 27
Cpanel::Mysql::Version::get_mysql_version() called at /usr/local/cpanel/Cpanel/Validate/DB/User.pm line 100
Cpanel::Validate::DB::User::get_max_mysql_dbuser_length() called at /usr/local/cpanel/Cpanel/Validate/DB/User.pm line 157
Cpanel::Validate::DB::User::_mysql_dbuser_name_length_check("demo") called at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 1246
Whostmgr::Accounts::Create::_validate_database_config(HASH(0x3670408)) called at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 352
eval {...} called at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 352
Whostmgr::Accounts::Create::_wwwacct("homedir", "", "maxpark", "unlimited", "useregns", 0, "uid", "", ...) called at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 2971
Whostmgr::Accounts::Create::__createaccount("max_emailacct_quota", "unlimited", "maxsub", "unlimited", "dbuser", "demo", "mxcheck", "auto", ...) called at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 3025
Whostmgr::Accounts::Create::_createaccount("max_emailacct_quota", "unlimited", "maxsub", "unlimited", "dbuser", "demo", "mxcheck", "auto", ...) called at whostmgr/bin/whostmgr5.pl line 781
main::wwwacct("wwwacct") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
Whostmgr::Dispatch::_do_call("wwwacct", HASH(0x3210150), HASH(0x3212f80)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
Whostmgr::Dispatch::dispatch("wwwacct", 1, ARRAY(0x3212f38), HASH(0x3212f80)) called at whostmgr/bin/whostmgr5.pl line 257

排查与解决步骤 #

作为刚接触WHM/cPanel的新手，遇到这种数据库相关的错误确实容易卡壳，别慌，我们一步步来排查：

1. 先确认MySQL服务是否正常运行 #

SSH登录到你的服务器，执行命令检查MySQL状态：

systemctl status mysqld

如果显示服务未启动，先启动它：

systemctl start mysqld

顺便设置开机自启，避免下次重启服务器后再次出问题：

systemctl enable mysqld

2. 手动验证MySQL版本是否能正常读取 #

直接在终端执行版本检测命令，看看MySQL本身能不能返回版本号：

mysqld --version

或者通过MySQL客户端查询：

mysql -e "SELECT VERSION();"

如果这两个命令能正常输出版本号，说明MySQL本身没问题，问题出在WHM的检测逻辑上。

3. 清除WHM的MySQL版本缓存并重建 #

WHM会缓存MySQL的版本信息，有时候缓存失效会导致检测失败，执行命令清除并重建缓存：

/usr/local/cpanel/bin/update_db_cache

完成后重启cPanel服务：

/scripts/restartsrv_cpanel

4. 检查MySQL配置文件权限 #

配置文件权限不正确也可能导致WHM无法读取信息，检查my.cnf的权限：

ls -l /etc/my.cnf

确保文件属于root用户和root组，权限为644，如果不对就调整：

chown root:root /etc/my.cnf
chmod 644 /etc/my.cnf

5. 修复cPanel相关的RPM包 #

如果以上步骤都无效，可能是cPanel的MySQL工具组件损坏了，执行命令检查并修复：

/scripts/check_cpanel_rpms --fix

这个命令会自动检查并修复损坏或缺失的cPanel相关包。

6. 手动指定MySQL版本（极端情况） #

如果所有方法都失效，可以尝试手动在cPanel配置文件里指定版本：
编辑/var/cpanel/cpanel.config文件，添加或修改以下行（把X.X.X换成你实际的MySQL版本，比如5.7.42或8.0.33）：

mysql_version=X.X.X

保存后重启cPanel服务即可。

验证解决效果 #

完成上述步骤后，回到WHM面板再次尝试创建新账户，应该就能顺利通过数据库验证了。

内容的提问来源于stack exchange，提问作者P N Jain