Tip : user 'root' using method 'mysql_native_password' failed with message: Access denied for user '

sloving problem :
user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'localhost' (using password: YES)

also need to do in server side  :

biding to any port

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

change below from:

bind-address                              = 127.0.0.1

To

bind-address                               = 0.0.0.0

After making the change above, save the file and run the commands below to restart the server.

sudo systemctl restart mysql.service
sudo systemctl restart mariadb.service
To verify that the change happens, run the commands below

sudo netstat -anp | grep 3306

and you should find the result that looks like the one below

tcp       0      0 0.0.0.0:3306          0.0.0.0:*        LISTEN         3213/mysqld

• #comedy
• #mysql_access_denied_for_user