If you never set, forgot, or change your MySQL password, you're in luck. This article walks you through these steps, so you'll never be at a loss for that database root user password.

However, when you attempt to connect to a remote MySQL database server, ... log into your MySQL server, change to the /etc/mysql/mysql.conf.d/ directory, and open the file mysql.cnf for editing.