====== access denied for user 'root'@'localhost' ======

[[https://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx|https://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx]]

<code - /etc/mysql/mysql.conf.d/mysqld.cnf>
bind-address            = 0.0.0.0
</code>

<code>
$ mysql -uroot -p -hlocalhost
mysql> use mysql;
mysql> update mysql.user set authentication_string=PASSWORD("PWD"), plugin="mysql_native_password" where User='root' and Host='localhost';
mysql> flush privileges;
</code>