I can't create users using cPanel interface

Operating System & Version
CENTOS 7.8
cPanel & WHM Version
v90.0.5

anirakgs

Member
Jun 5, 2020
6
0
1
::1
cPanel Access Level
Root Administrator
Hi there,

When I try to create an user, cPanel says:

The request failed. (Error ID: 25tsgp) Ask your hosting provider to research this error in cPanel & WHM’s main error log.

And the error log shows the following:

Code:
[2020-09-03 19:37:28 -0500] info [cpwrapd] ERROR in Mysql query :(XID qnsdfk) The system received an error from the “MySQL” database “mysql”: 1410 (You are not allowed to create a user with GRANT):
Cpanel::Exception/(XID 25tsgp) Error from MySQL query :(XID qnsdfk) The system received an error from the “MySQL” database “mysql”: 1410 (You are not allowed to create a user with GRANT):
at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 96.
    Cpanel::Admin::Base::DB::CREATE_USER(Cpanel::Admin::Modules::Cpanel::mysql=HASH(0x373d3b8), "testuser", "fsPL34fe99x2Fr") called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 717
    eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 716
    Cpanel::Admin::Base::run("Cpanel::Admin::Modules::Cpanel::mysql", "username", undef, "uid", 1026, "function", "CREATE_USER", "args", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 132
    eval {...} called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 130
    Cpanel::AdminBin::Server::Backend::run_admin_module("perl_module", "Cpanel::Admin::Modules::Cpanel::mysql", "uid", 1026, "args", ARRAY(0x36aed38), "function", "CREATE_USER", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 222
    Cpanel::AdminBin::Server::_request_handler(Cpanel::AdminBin::Server=HASH(0x36ae870), HASH(0x36aeca8), undef) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 123
    Cpanel::AdminBin::Server::__ANON__() called at /usr/local/cpanel/Cpanel/Try.pm line 193
    eval {...} called at /usr/local/cpanel/Cpanel/Try.pm line 193
    Cpanel::Try::try(CODE(0x36ae9c0), "Cpanel::Exception::ProcessNotRunning", CODE(0x36aea38)) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 126
    Cpanel::AdminBin::Server::handle_cpwrapd_request(Cpanel::AdminBin::Server=HASH(0x36ae870), HASH(0x36ae678)) called at /usr/local/cpanel/Cpanel/Server.pm line 2310
    Cpanel::Server::handle_cpwrapd_connection(Cpanel::Server=HASH(0x33f2058)) called at cpsrvd.pl line 1778
    cpanel::cpsrvd::_handle_unix_socket_connection("handle_cpwrapd_connection") called at cpsrvd.pl line 1090
    cpanel::cpsrvd::script() called at cpsrvd.pl line 431
I tried with different users and the problem is the same, I tried to reboot the full server and the MySQL services, and reinstalling MySQL.

Any help will be appreciated. Thanks!
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved.


Thanks!
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
Hello,

I checked in on this ticket this morning and found that the issue is related to the validate_password plugin enabled in MySQL. This is not a plugin that is enabled in our default installation of MySQL. This issue did spawn the case CPANEL-31472 but the case was marked as "won't fix" because this is considered a customization to MySQL. In order to resolve this issue, you must remove the plugin. The workaround in the case notes that the plugin can be removed by doing the following:

Code:
mysql -e "uninstall plugin validate_password;"