[Solved] Invisible Database/database Connection Error

[kalantary]

Hi,

 

Would you please assist me by resoltion of my website database connection error?

Username: elaay

Database name: elaay_2013

Database User Name: elaay_2013

[wolstech]

This support request is being escalated to our root admin.

[Krydos]

The database elaay_2013 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. If phpmyadmin doesn't log in properly or you don't see the database there change your account password and this should sync up the mysql/cpanel passwords. Let us know if you're still having any issues accessing your data.

[kalantary]

I made a big mistake, I deleted and recreated database instead of database users in order to resolve this issue!

I would like to kindly request for your assistance to restore my database, if possible. Otherwise, I will loose my posts totally.

[wolstech]

We don't keep backups. If you don't have one, you'll need to start over

[Krydos]

We don't keep backups. If you don't have one, you'll need to start over.

This is true. We don't normally keep backups for users automatically, but since we did a major upgrade on MySQL recently I manually took a backup of the databases prior to the upgrade. This time you're lucky and I can restore your database to the state it was before the upgrade, but wolstech is right we normally can't do anything for you.

 

The database elaay_2013 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. If phpmyadmin doesn't log in properly or you don't see the database there change your account password and this should sync up the mysql/cpanel passwords. Let us know if you're still having any issues accessing your data.

[kalantary]

Thanks alot for your great assistance and support.

[Krydos]

Thanks! As a free service we don't have an advertising budget because we would rather invest all of the money that we do have into providing better service and improving the servers so we really appreciate the word of mouth recommendations that our satisfied users provide. Feel free to post about us on social media like twitter, facebook, hosting review sites, your personal websites or blogs, and anything else you can think of. As long as we have clients using our service Heliohost will continue to exist.

[Krydos]

@cbapps Your topic has been split to http://www.helionet.org/index/topic/22536-cbapps-phpmyadmin/