I can't create users using cPanel interface

[anirakgs]

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:

[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!

 

[kodeslogic]

@anirakgs

You tried to create a different user in the same cPanel account or in another cPanel account.

 

[anirakgs]

@anirakgs

You tried to create a different user in the same cPanel account or in another cPanel account.

In the same account.

 

[kodeslogic]

Can you check if you can create a demo user in another cPanel account or not?

 

[cPanelLauren]

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!

 

[anirakgs]

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!

Done. Request Id. 93668749 Thank you.

 

[anirakgs]

Can you check if you can create a demo user in another cPanel account or not?

Not possible, MySQL cannot be created even if I try in a new-setup account.

 

[cPanelLauren]

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:

mysql -e "uninstall plugin validate_password;"