[Solved] Unable To Access Mysql Databases

[phantom666]

Username: demon666

Domain: phantomtest.heliohost.org

Server: johnny

 

Hi,

 

I've just logged into my account after a couple of weeks, and I am no longer able to connect to any of my existing MySQL databases.

 

Please can anyone assist?

 

Thanks in advance.

 

D.

[yashrs]

Please mention the name of the database which is missing. It will be in the format your username_database. An admin will need to fix your issue.

[phantom666]

Hi,

 

Thanks for getting back to me so quickly.

 

With regards to the problem I have described, as far as I can tell, it appears to be affecting all of my databases.

The names of my databases are:

 

demon666_demo2

demon666_sakila

demon666_sakila2

demon666_testdb

demon666_wishlist

demon666_wpdb

demon666_wpdb2

 

Let me know if you require any additional information. Thanks in advance.

 

D

[wolstech]

This support request is being escalated to our root admin.

[Krydos]

The databases you listed should now be visible to your root mysql account. You may need to delete, recreate, and reassign permissions to any database users that should have access to the affected database. Let us know if you're still having any issues accessing your data.

[phantom666]

Hi All,

 

I would like to thank everyone's help, this issue appears to have been resolved and I am now able to access my MySQL databases from the web pages.

 

I would also like to add that, further to the recommendations in earlier posts, in order to get everything working as before, I had to delete and re-create the database users first.

 

Thanks everyone.

 

D

[Krydos]

Glad everything is working for you again.