studius Posted January 2, 2020 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.
wolstech Posted January 2, 2020 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.
studius Posted January 4, 2020 Author 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.
Luigi123 Posted January 4, 2020 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.
wolstech Posted January 4, 2020 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).
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now