设置数据库密码一直报错
登录数据库
mysql -u root -p
有密码输入密码，没密码直接回车进入；
use mysql;
select user,host from user;
终端显示：
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| user | % |
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
+------------------+-----------+
修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassWord1.';
一直报语法错误，后来发现是我的host是‘%’
应该用如下的语法：
ALTER USER 'root'@'%' IDENTIFIED BY 'xxx';
再次运行，成功了。
参考：https://zhangxiaofan.blog.csdn.net/article/details/84555847
