Remote MSQL Setup Hashing Wrong Remote Root Password

n0risc

Member
Sep 24, 2013
6
0
1
cPanel Access Level
Root Administrator
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 [email protected] [email protected] has a different hash. How is this possible?

When manually modifying the table with the correct hashed password for [email protected], 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

Member
Sep 24, 2013
6
0
1
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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.