dmkmedia

Registered
Jul 19, 2019
1
0
1
United Kingdom
cPanel Access Level
Root Administrator
i am moving from one cento 7 server to another centos 7 servers with whm on both using the transfer tool but getting so many errors i managed to move some account but some just won't go over

here is just one of the errors

The system failed to grant privileges on the database “clerkenw_wp115” to the user “clerkenw_wp148” because of an error: (XID zsccxn) This system will not add the database user “clerkenw_wp148” to the database “clerkenw_wp115” because this user does not have a password.
{"type":"warn","contents":{"time":1563270027,"msg":["The system failed to grant privileges on the database “clerkenw_wp91” to the user “clerkenw_wp148”

and also

RESTORE: Account “handyman”: Account Restore Failed: “Account failure: Failed to create the account: A database owner with the name “handyman” already exists in the database map (/var/cpanel/databases/handyman.*). at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 1224. ”

please help


i do have a backup of the server in Acronis and wondering would it be easier to restore this but not sure if I restore the home dir and sql dbases would it show the accounts after i restore it

as i have only ever used this for file restores only
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,220
463
Hello @dmkmedia,

Can you run the following commands on both the source and destination server and report the output here?

Code:
cat /usr/local/cpanel/version
mysql --version
Thank you.
 

Naila

Member
Jun 20, 2017
18
0
1
Indonesia
cPanel Access Level
Root Administrator
I have same issue with this on transfer account from old to new server


Code:
The system failed to grant privileges on the database “user_wp340” to the user “user_wp340” because of an error: (XID p6mj4r) This system will not add the database user “user_wp340” to the database “user_wp340” because this user does not have a password.

Any solution to fix all "user does not have a password" issue?
 
Aug 22, 2016
7
0
1
Manchester
cPanel Access Level
Root Administrator
I've had the same issue. Solution was to;

1) Delete cPanel account completely from new server
2) Re-transfer cPanel account from old server to new server

Don't want to say this would work for others as cPanel is a bit of a mystery in the background in a lot of areas. So just sharing my experience of what worked in my situation (but I had a LOT of other errors throughout the transfer process in general, so it's difficult to pinpoint issues.)
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,030
313
cPanel Access Level
Root Administrator
It's hard to say exactly what the cause may be. In some cases if you are moving from a server running an older MySQL version it could be using an old-style password, and that could cause this error. If you're seeing the issue, it would be helpful to know the MySQL version of both systems using the commands that Michael provided above as that might get us more details.