mysql database SELECT privileges

stephenmahood

• July 15, 2015 05:16

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

• 

  cPanelMichael

  • August 21, 2015 18:57

  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.

  0
• 

  stephenmahood

  • August 21, 2015 19:01

  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

  0
• 

  cPanelMichael

  • September 08, 2015 16:42

  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.

  0

Please sign in to leave a comment.