The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

You do not control a MySQL user

Discussion in 'General Discussion' started by HostSEO LLC, Feb 2, 2016.

  1. HostSEO LLC

    HostSEO LLC Registered

    Joined:
    Feb 2, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
    #1 HostSEO LLC, Feb 2, 2016
    Last edited by a moderator: Feb 2, 2016
  2. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    329
    Likes Received:
    25
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,
    Please let us know the version of cPanel installed on your system

    cat /usr/local/cpanel/version
     
  3. HostSEO LLC

    HostSEO LLC Registered

    Joined:
    Feb 2, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Dhaka, BD
    cPanel Access Level:
    Root Administrator
    Both server is using :

    11.54.0.8
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
    Infopro likes this.
  5. Duplika

    Duplika Well-Known Member

    Joined:
    Feb 26, 2005
    Messages:
    56
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Buenos Aires, Argentina
    cPanel Access Level:
    Root Administrator
    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?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  7. Duplika

    Duplika Well-Known Member

    Joined:
    Feb 26, 2005
    Messages:
    56
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Buenos Aires, Argentina
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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 likes this.
  9. Duplika

    Duplika Well-Known Member

    Joined:
    Feb 26, 2005
    Messages:
    56
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Buenos Aires, Argentina
    cPanel Access Level:
    Root Administrator
    Twitter:
    That solved the problem Michael, thanks for your help.
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page