I am currently moving my content from GoDaddy's Classic Hosting Linux to cPanel.
According to GoDaddy's support staff, the migration path for transferring my databases from one service to the other was to (1) backup each database in my Classic Hosting Linux environment, (2) download the backup SQL file to my local computer, (3) create the new database in cPanel, (4) create and add a database user in cPanel (I kept the usernames and passwords the same for both hosting environments), and finally (5) import the database.
Everything went smoothly, and I was able to verify that the database structure and content is intact. However, when I attempt to access the database -- either through Joomla or through a MySQL JDBC driver -- I receive the following error:
I repeated the process of creating the database and importing several times to minimize the possibility that I may have had a typo in the username and password.
Finally, I noticed that the information_schema database in the Classic Hosting Linux service includes a table called USER_PRIVILEGES and includes a row with the correct username in the GRANTEE column. However, the cPanel information_schema database does not. I verified and re-verified that the user was added to the correct database, yet the information_schema's table USER_PRIVILEGES does not show a row similar to the Classic Hosting Linux table.
Thanks in advance for your help.
Solved! Go to Solution.
@hartmada When creating a MySql Database you also have to create a user and grant access to the database for the user. You can use the following link for more information on managing databases in cPanel. https://documentation.cpanel.net/display/ALD/MySQL+Databases