用ubuntu远程连接mysql_Ubuntu 安装 MySQL 和远程连接

#安装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