SQL Databases not showing in MySQL

[gtg93]

I'm guessing this is the best category for this issue, but if not, apologies, mods feel free to move my post if need be.

 

 

I currently have a shared hosting account (so no access to the server OS - planning on changing to VPS soon, but that's a different matter).

 

In CPanel, none of my my SQL databases or database users are showing in MySQL. In phpMyAdmin however they are displayed. I discovered this yesterday when my sites were down. Upon investigation, I found that if I exported my databases from phpMyAdmin, and restored them in backup wizard, the websites came back online - but MySQL still doesn't see the databases. Not a massive issue but would be nice to have them there.

 

If I try creating a new database in MySQL under the same name, I get the " the database already exists" error, so it knows they're there - it just doesn't show them.

 

Does anyone have any ideas? I've got the hosting support onto it, but they seem lost - they're usually pretty good, and have taken suggestions on board in the past, so if anyone has seen this before, any suggestions are appreciated.

 

Thanks,

Grant

[pcstru]

It sounds like a permissions thing. Are you sure the user that cpanel and phpMyAdmin are using to log into the database server are the same?

[gtg93]

I thought this, but my CPanel details have been the same since I set up the hosting 12 months ago, and the hosting company claim to have not changed anything that would relate to this.

[pcstru]

Can you run arbitary SQL statements from cPanel? If so try :

 

show grants for current_user();

 

from both cPanel and phpMyAdmin.

[SovietRussia]

If you are on shared hosting, you wont be able to edit permissions or even view them for tables, its the way cPanel works in a shared environment.

[gtg93]

Nope - can't view them.

 

I've had to delete all the SQL databases in phpMyAdmin, recreate them in MySQL, then import the backups in phpMyAdmin.

 

Then edit config files for my sites to change the SQL login details and create new users for each database.