MySQL doesn't see databases

[andreifundrei88]

Hi,

I am having problem with MySQL not seeing databases that exist in PHP. I tried to create a database that is the same as in PHPmyadmin but it says error creating databse, database already exists. I need help fixing this!

 

[descalzo]

You sort of lost me.

Are you saying that you have databases that show up in cPanel's PHPMyAdmin that do not show up in cPanel's MySQL Databases ?

 

[andreifundrei88]

Right and therefore I can't delete the Databases that I want to reset.

Also, in phpMyAdmin I can't modify the "hidden from MySQL" databases as it says that the databases are not owned by me. ><

 

[Anna]

hello,

just to confirm, these would be the two you would want removed, right?
xxxxxxx_login/
xxxxxxx_userData/

The xxxxxxx represents your cPanel username.

 

[andreifundrei88]

hello,

just to confirm, these would be the two you would want removed, right?
xxxxxxx_login/
xxxxxxx_userData/

The xxxxxxx represents your cPanel username.

Yes Remove everything. I have a backup of the site.

 

[Anna]

Those two was empty, there was no files that would normally have been there to show the tables (each table would normally be represented by one or more files depending on which storage engine you use).

You should now be able to created new databases with the same names.

 

[andreifundrei88]

I am still having problems with MySQL databases. As the databases in PHPmyAdmin still do not appear in MySQL. Is it possbile for you guys to reset my account, so that I have an empty PHPmyAdmin and an empty MySQL db.