[Solved] Unable To Access Mysql Database

[xynnia]

Username: xynnia

Domain: puffnames.heliohost.org

Server: Stevie

 

Hello,

 

I have a Heliohost site of which the main component is a MySQL database, a kind of directory of names and contact details for people who used to be on the website Pottermore. The database name is xynnia_namelist. About a week and a half ago I revived my site from inactivity and then noticed I was getting an error when I tried to visit the URL where the database is normally located, puffnames.heliohost.org/contact.php. The error reads as follows:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'xynnia_admin'@'localhost' (using password: YES) in /home1/xynnia/public_html/contact_config.php on line 23

Access denied for user 'xynnia_admin'@'localhost' (using password: YES)

 

I originally thought that the problem was due to your server downtime, but now the servers seem to be restored and I still can't access the database. I should add that I don't know anything about MySQL myself; I run the site, but a friend of mine coded the database and just gave me the instructions to implement it. I noticed that the code for it is written differently to what is specified in your MySQL Wiki, but it's always worked fine before now. However, it could be that the problems date back further than a week and a half ago, and I didn't notice because the site was inactive.

 

I've attached a screenshot of the error and the MySQL database code - passwords are blanked out, but I can provide the information via PM if you need it.

 

Thank you!

[yashrs]

Can you try changing localhost to '127.0.0.1' ?

[xynnia]

I changed the host and got an Internal Server Error on the database page... Then when I refreshed the page the same error as before came back. :/

 

Edited to add: I also tried clearing my cache and accessing the page again, but the error remained.

[alein]

mysql (5.6.21) failed

[xynnia]

mysql (5.6.21) failed

 

What does that mean?

[wolstech]

It means the cPanel monitor is broken. The database server is working fine. The problem is actually that localhost no longer points to 127.0.0.1 like it should. Change your script's database server to 127.0.0.1 instead of localhost and see if it works.

 

If it does not, check in PHPMyAdmin and verify that the database exists and has content like it should. If it's empty or missing, let me know its name so I can escalate this for you.

[xynnia]

It means the cPanel monitor is broken. The database server is working fine. The problem is actually that localhost no longer points to 127.0.0.1 like it should. Change your script's database server to 127.0.0.1 instead of localhost and see if it works. If it does not, check in PHPMyAdmin and verify that the database exists and has content like it should. If it's empty or missing, let me know its name so I can escalate this for you.

 

Yeah, I already changed the server as per yashrs' suggestion and it didn't make a difference. I checked in PHPMyAdmin and the database is not listed. The name is "xynnia_namelist".

[wolstech]

I just realized you're on Stevie. The localhost thing is a Johnny problem.

 

You just have an invisible database. Krydos needs to restore it for you. Escalating.

[Krydos]

The database xynnia_namelist 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.

[xynnia]

Thank you! Yes, it's back and all there! That's such a relief, thanks for fixing the problem

[cnitx]

its work.thank you all my friend.