Change that line to: bind-address = 0.0.0.0; Save and close the file. Restart the MySQL service with: ... Next, create a new MySQL user. We’re going to call this user dbadmin.

How to change MySQL root user password. To reset the password for MySQL you first must create a new file with the following contents: ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORD'; ...