I just set up a new droplet. After configuring mysql for root and any other user with passwords, I just can´t seem to be able to access it correctly. 1. the root user logs in even without the password (unfortunately not usable in my PhP scripts). 2. On the other user (e.g. userX, the password does not allow me to log into the mysql even when I have used the correct one and I have rechecked a number of times. What could be the problem?
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.