HostSEO LLC

Registered
Feb 2, 2016
3
0
1
Dhaka, BD
cPanel Access Level
Root Administrator
Hello,

Im transferring my old server to new server using Transfer Tool. But everything transferred, except database username. This error happens with each and every cpanel account restoration process in Transfer tool. Not a single database username transferred.

Error shown at Transfer Tool:
he system failed to grant privileges on the database “xxxxxx_wp395” to the user “xxxxxx_wp395” because of an error: (XID zxnyk6) You do not control a MySQL user named “xxxxxx_wp395”.

Same error with each and every cpanel restoration process. Not a single database username is transferring.

So I have pause the transfer process and open a ticket: 7452685

Now Im waiting for the ticket escalation since 2 hours. How to solve the problem?
 
Last edited by a moderator:

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello :)

I've moved these posts into their own threads, as the issue appears different than the originally reported problem. We will need to investigate the source server to determine the cause of this problem, so I'll update this thread with information from your support ticket. I do see your support ticket is open, and you will receive a response to the support ticket as soon as possible.

Thank you.
 
  • Like
Reactions: Infopro

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
We are having the same problem, MySQL usernames are not being migrated using the Transfer Tool.

Any idea on what could be causing this?
Hello :)

Internal case CPANEL-4684 is open to address an issue where the transfer tool and /scripts/restorepkg are not properly restoring grants for cPanel users. The original poster addressed this issue by running the following command on the source server to restore the user's database access:

Code:
for user in `/bin/ls -A /var/cpanel/users` ; do /usr/local/cpanel/bin/restoregrants --cpuser $user --db=mysql --all; done
This command is documented at:

How to Restore a User's Database Access - cPanel Knowledge Base - cPanel Documentation

Could you verify if this same workaround addresses the issue on your server?

Thank you.
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
So should I run that command at the source server, to later use the Transfer Tool again?
You should run the command on the source server, and then try using the "Transfer Tool" again to see if the MySQL user copies over successfully. Note that it's possible you are experiencing a different issue than the original poster has reported.

Thank you.
 
  • Like
Reactions: Duplika