#安装MySQL
sudo apt install mysql-server
#进入数据库
sudo mysql
#修改密码
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘123‘;
产生用户不能授权的原因是mysql 数据库中user 表中的特定用户(root) 的host 的属性值为localhost.
#查看
select host, user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| localhost | debian-sys-maint |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+------------------+
解决办法如下：
# 使用mysql 数据库
mysql > use mysql;
# 特定用户的host 修改
mysql > update user set host=‘%‘ where user=‘root‘;
# 指定用户的授权
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ WITH GRANT OPTION;
#执行如下SQL语句，刷新权限。
flush privileges;
#修改配置文件
vim /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
port = 3306
bind-address = 0.0.0.0
mysqlx-bind-address = 0.0.0.0