Knowledgebase

Tips and Tricks for Moving Databases  Print this Article

When you move databases to our servers, the database name and username may change. This change must be updated in your script code. (The database name and username is clearly displayed in cPanel, in the MySQL area.)

On Shared servers, the database username cannot be changed to something without the cPanel username in it. This is to keep database names and usernames from conflicting with others on the server.

MySQL User Has No Privileges

Since the 11.25 update, we've noticed an occasional bug where adding an IP to the MySQL remote access list results in the corresponding MySQL user having no privileges.

In order to get the correct privileges added:

  1. Go to your MySQL Databases in cPanel.
  2. Re-add the user to each database by selecting the user and the database from the drop-down menus.
  3. Reassign the privileges.
  4. Click Add.

 We have notified cPanel about the issue in hopes of this bug being corrected in newer updates.

Was this answer helpful?

Also Read

I Accidentally Deleted the public_html or www Folder
I Accidentally Deleted the public_html or www Folder: If you delete the www folder, your site...
PHP Configuration Plugin in cPanel
PHP Configuration Plugin in cPanel: If you ever encounter problems with the way your server...
How to Change DNS Zones (MX, CNAME and A Records) in cPanel?
Change DNS Zones (MX, CNAME and A Records) in cPanel: With cPanel, users are granted access to...
How to Upload to an Addon or Subdomain in cPanel?
Upload to an Addon or Subdomain in cPanel: Option 1 In a FTP client enter this information....
How to Connect to the MySQL Database in cPanel?
Connect to the MySQL Database in cPanel:In order for your MySQL database to work as intended, it...