mysql login fails with LEMP
I setup a LEMP droplet using the digitalocean one click-apps. Then, I sshed into the droplet, and was able to login as root and reset my password. However, whenever I try to use “mysql -u root -p” and type in my root password, it fails to login. I’ve tried creating a new user, and then using “su” to get into that user, and then run the “mysql -u newuser -p” but still the password doesn’t work.
What am i doing wrong?