xynnia Posted April 10, 2016 Share Posted April 10, 2016 Username: xynniaDomain: puffnames.heliohost.orgServer: 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 23Access 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! Link to comment Share on other sites More sharing options...
yashrs Posted April 10, 2016 Share Posted April 10, 2016 Can you try changing localhost to '127.0.0.1' ? 1 Link to comment Share on other sites More sharing options...
xynnia Posted April 10, 2016 Author Share Posted April 10, 2016 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. Link to comment Share on other sites More sharing options...
alein Posted April 10, 2016 Share Posted April 10, 2016 mysql (5.6.21) failed Link to comment Share on other sites More sharing options...
xynnia Posted April 11, 2016 Author Share Posted April 11, 2016 mysql (5.6.21) failed What does that mean? Link to comment Share on other sites More sharing options...
wolstech Posted April 11, 2016 Share Posted April 11, 2016 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. 1 Link to comment Share on other sites More sharing options...
xynnia Posted April 11, 2016 Author Share Posted April 11, 2016 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". Link to comment Share on other sites More sharing options...
wolstech Posted April 11, 2016 Share Posted April 11, 2016 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. 1 Link to comment Share on other sites More sharing options...
Krydos Posted April 11, 2016 Share Posted April 11, 2016 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. 1 Link to comment Share on other sites More sharing options...
xynnia Posted April 11, 2016 Author Share Posted April 11, 2016 Thank you! Yes, it's back and all there! That's such a relief, thanks for fixing the problem 1 Link to comment Share on other sites More sharing options...
cnitx Posted April 12, 2016 Share Posted April 12, 2016 its work.thank you all my friend. Link to comment Share on other sites More sharing options...
Recommended Posts