I'm having trouble setting up my first database
New to DigitalOcean although I have successfully installed packages such as Drupal on a self-hosted Synology NAS. I used one-click to install a LAMP stack; now I’m wanting to install first WordPress and then Drupal. However, I’m having trouble creating the database.
I’m proceeding in accordance with the tutorial at https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-with-lamp-on-ubuntu-18-04. However, when I attempt to log in to mysql using the password which is in the location specified at droplet login I get: “ERROR 1698 (28000): Access denied for user ‘root’@'localhost’.” I’ve tried using the password both with and without the quotation marks which are in the file location. What am I missing?
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.×