yashrs Posted May 5, 2014 Posted May 5, 2014 Try going to change password in cPanel and change your password and also tick the "Allow MySQL password change" option and then try connecting
paladox2014 Posted May 5, 2014 Posted May 5, 2014 Try downloading your back up database and see if it has all your tables in it and then delete your MySQL database and user and recreate them and then import backup data. But please make sure you have all your MySQL data in the backup before deleting. Try create another MySQL user and database and import it to see if it has all your data.
wolstech Posted May 5, 2014 Posted May 5, 2014 @paladox2014:He can't do that because he can't access anything. The user that's broken for him is not a DB user you can create in cPanel, it's the default database user that has the same username/password as your cPanel account. This is something an admin needs to fix. 1
wolstech Posted May 6, 2014 Posted May 6, 2014 This support request is being escalated to our root admin.
Krydos Posted May 7, 2014 Posted May 7, 2014 I tested your account and you have permission and show tables command works both in phpmyadmin and in a command line connection. I saw two databases. The one had four tables if I recall correctly, and the other had none. In order to test this as the mysql user pete20r2 I had to change your cPanel account password. Let us know if you're having trouble resetting your password and getting logged back into your account. I also tested your databases using the root mysql account and there was no additional tables or data that wasn't available to your pete20r2 mysql account. I'm going to mark this as solved, but if I am misunderstanding the issue or if you have any other issues please let us know and we can work get everything functional for you.
Recommended Posts