studius Posted January 2, 2020 Share Posted January 2, 2020 After my account got deleted due to some server problems on Tommy a couple months ago, I tried starting a website again from scratch on my new account (thankfully I had the backed up files). This time, I am not even able to create a database in phpMyAdmin because apparently access is denied for my user. phpMyAdmin also shows I am connected to localhost:3306 while I used to be connected to tommy.heliohost.org. Please let me know how I can fix this issue. My website is nvitro.gq where you will find the error messages displayed. Thank you for your time.Best regards. Quote Link to comment Share on other sites More sharing options...
wolstech Posted January 2, 2020 Share Posted January 2, 2020 You must use cpanel to create a database, not phpmyadmin: https://tommy.heliohost.org:2083/frontend/paper_lantern/sql/index.html After creation, you can use phpmyadmin to import the data if you wish. This behavior is by design. Quote Link to comment Share on other sites More sharing options...
studius Posted January 4, 2020 Author Share Posted January 4, 2020 I was able to create the new database through cPanel, but I am still getting the error message: "Access denied for user 'studius_corp'@'tommy.heliohost.org' (using password: YES)" when I use mysqli_connect. Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted January 4, 2020 Share Posted January 4, 2020 For that, go to Remote MySQL under “Database”. Once you enter it, just put a % into the first field and leave the second field alone and click add. This will allow access to any of the IPs. Quote Link to comment Share on other sites More sharing options...
wolstech Posted January 4, 2020 Share Posted January 4, 2020 Did you assign a user to it in cpanel? Also, use localhost if the script is running on the server. You should only use tommy.heliohost.org if you're accessing it remotely (and you need to do what Luigi said if you're accessing remotely as well). Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.