How does one find and set localhost, user and password when using MySQL entirely through command line on Linux server, and not through phpMyAdmin?

I bought a 5$ Digital Ocean droplet in order to host and tinker with my projects, however, I'm facing some unexpected problems.

I installed MySQL through the command line and cloned my project from git, but I quickly realized that I need to connect to the database using the right credentials. Usually, I just go to phpMyAdmin and just copy the user and host from their interface but now that I'm using MySQL through the command line, I can't do that.

The error I'm getting is:

"Access denied for user 'root'@'localhost'"  

So I assume either my user or host is wrong. I'm trying to figure out how to find the correct values.

https://stackoverflow.com/questions/67052158/how-does-one-find-and-set-localhost-user-and-password-when-using-mysql-entirely April 12, 2021 at 11:04AM