Connection failed: Access denied for user 'root'@'localhost'
I am currently trying to host a movie database website on DigitalOcean.
I have set up a droplet with LAMP installed and managed to clone the repository from GitHub to /var/www/html. If I set a regular HTML page as the index, it works just fine. However, attempting to do the same with a PHP file presents me with the error seen in the title of the post. I have a .sql file containing the data and I can’t figure out where it should be uploaded to. I know this is a problem with the database, but I am unsure of how to solve it.
Using XAMPP to test locally works perfectly fine.
I realize this is a novice question and might come across as ignorant, but this is my first time hosting and using a Linux terminal.
Greatly appreciate any and all help.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×