You do not control a MySQL user

HostSEO LLC

• February 02, 2016 06:43

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

  • February 02, 2016 12:34

  Hi, Please let us know the version of cPanel installed on your system cat /usr/local/cpanel/version

  0
• 

  HostSEO LLC

  • February 02, 2016 13:09

  Both server is using : 11.54.0.8

  0
• 

  cPanelMichael

  • February 02, 2016 17:05

  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.

  0
• 

  Duplika

  • March 29, 2016 04:54

  We are having the same problem, MySQL usernames are not being migrated using the Transfer Tool. Any idea on what could be causing this?

  0
• 

  cPanelMichael

  • March 29, 2016 14:00

  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.

  0
• 

  Duplika

  • March 29, 2016 16:23

  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.

  0
• 

  cPanelMichael

  • March 29, 2016 17:46

  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.

  0
• 

  Duplika

  • March 31, 2016 01:05

  That solved the problem Michael, thanks for your help.

  0
• 

  cPanelMichael

  • March 31, 2016 01:13

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

  0

Please sign in to leave a comment.