dmkmedia

Registered
Jul 19, 2019
1
1
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:
  • Like
Reactions: ankeshanand

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,250
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
22
0
51
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
11,731
1,864
363
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.
 

ankeshanand

Well-Known Member
Mar 29, 2021
206
60
103
India
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.
Happening with me right now!
Source server is running MariaDB 10.6
Target server is running MariaDB 10.3
Maybe it's a version issue. Any workarounds discovered?
 

ankeshanand

Well-Known Member
Mar 29, 2021
206
60
103
India
cPanel Access Level
Root Administrator

ankeshanand

Well-Known Member
Mar 29, 2021
206
60
103
India
cPanel Access Level
Root Administrator