MySQL 8 issues and resolve

Photo by Caspar Camille Rubin on Unsplash

Remove the validate password plugin

uninstall plugin validate_password;

OR

UNINSTALL COMPONENT ‘file://component_validate_password’;

Allow Remote Access to MySQL

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

Set: bind-address = 0.0.0.0