By aalumar
Hello, 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.
Thank you.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hey,
It looks like your MySQL database credentials might be invalid. Presumably, you’ve specified these credentials somewhere in your PHP file.
You might need to adjust the database credentials you use to connect to the database on the Digital Ocean droplet.
These will be details like the MySQL host, username, database name, and password. Your local XAMPP environment will likely have different database credentials than the one you’ve configured on your droplet.
If you haven’t already, consult this guide on how to set a LAMP stack up on Digital Ocean.
From the error message, it looks like the database credentials are invalid.
No questions are ignorant. First time trying to setup hosting will be a bit rough but you’ll get the hang of it after a while :)
Best of luck!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.