You do not control a MySQL user

[HostSEO LLC]

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?

 

[SysSachin]

Hi,
Please let us know the version of cPanel installed on your system

cat /usr/local/cpanel/version

 

[HostSEO LLC]

Both server is using :

11.54.0.8

 

[cPanelMichael]

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.

 

[Duplika]

We are having the same problem, MySQL usernames are not being migrated using the Transfer Tool.

Any idea on what could be causing this?

 

[cPanelMichael]

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:

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.

 

[Duplika]

So should I run that command at the source server, to later use the Transfer Tool again?

Source server has all MySQL users fine, only problem is they are not transfered to the destination server after the Transfer Tool finish the migration.

 

[cPanelMichael]

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.

 

[Duplika]

That solved the problem Michael, thanks for your help.

 

[cPanelMichael]

I am happy to see the workaround was helpful. Thank you for updating us with the outcome.