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.

mysql database SELECT privileges

Discussion in 'Database Discussions' started by stephenmahood, Jul 15, 2015.

  1. stephenmahood

    stephenmahood Registered

    Joined:
    Aug 7, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I'm hoping to use the mysqldbcopy.exe utility to create a copy of our production database and download it to the development environments. I've built a C# wrapper application to assist with entering credentials.

    It works fine with normal databases but using the cPanel database as the source I'm getting the following error:

    'ERROR: User blah_wp on the Source server does not have permissions to read all
    objects in blah_wp. User needs SELECT privilege on blah_wp.'

    The user that I am trying this with does in fact have full privileges over the database. I think the error is coming from the user not being able to read the mysql system database.

    Is there anyway to grant SELECT privileges to this database?

    Thanks

    Stephen
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Is this script running on a remote server or locally? If locally, have you granted remote host access to the IP address the host is connecting to MySQL from?

    Thank you.
     
  3. stephenmahood

    stephenmahood Registered

    Joined:
    Aug 7, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    Yes, the user has the required permissions as I can manually connect and execute a SELECT of the main WordPress database however doing this using mysqldbcopy does not work as it gathers information from the system 'mysql' database.

    Thanks

    Stephen
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you open a support ticket using the link in my signature so we can take a closer look at this? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page