Plesk to cpanel migration error(MySQL error)

[Total: 3    Average: 5/5]

Plesk to cpanel migration error(MySQL error)Sometime we are getting following error when we migrate account from plesk panel to cPanel.

Error :

 

Unknown option: Compressed
 Unknown option: MySQL
 MySQL error:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) at /tmp/.perl-ppk-kh2FBV/lib/cpanel

Solution:
Please create /root/.my.cnf file on the Plesk server then add below code in the file:
Code:

[client]
 password="REDACTED"
 user=admin

Replace your plesk admin password in above code. The password is found in the /etc/psa/.psa.shadow file.