access denied for user 'root'@'localhost'

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

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

bind-address            = 0.0.0.0

$ 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;