Remote MSQL Setup Hashing Wrong Remote Root Password

[n0risc]

I have cPanel WHM 11.38.2 build 12 trying to remote MYSQL to a freshly installed cPanel WHM 11.40.0 build 19.

The Remote MySQL Setup retrieves the remote /root/.my.cnf information via SSH, and successfully sets GRANT PRIVILEGES on the remote MySQL Database. But when it goes to login remotely to fails with Access Denied.

The credentials are being stored on the Remote MySQL Destination, but the hash for the password does not match the hash for root@localhost [email protected] has a different hash. How is this possible?

When manually modifying the table with the correct hashed password for root@localhost, I can then successfully remote mysqladmin from the command line from the host server to the remote server.

Is there a workaround? Obviously I cannot catch in time the table update right before the SETUP retrieval to update the hashed passwords. And everytime to go to repeat the setup process it overwrites or adds more incorrect hashes for [email protected].

Is this a known issue? I'm guessing that the MD5 Key's have changed from cPanel 11.38.2 to 11.40.2 when hashing the mysql passwords?

 

[n0risc]

This issue was fixed.

/root/.my.cnf that is generated with 11.40.0 Build 19 after installation supplies "quotes" around parameters specified in the [client] tag.

The only option under the [client] tag that should have quotes is the pass="password".

WRONG .my.conf

[client]
host="localhost"
user="root"
pass="password"

CORRECT .my.conf

[client]
host=localhost
user=root
pass="password"

 

[cPanelMichael]

Hello

Please open a bug report for this so we can attempt to reproduce the issue and address it in a future build of cPanel if necessary:

Submit A Bug Report

You can post the ticket number here so we can update this thread with the outcome.

Thank you.