mysql远程链接配置

mysql远程链接配置

十二月 23, 2019

描述

docker需要链接数据库，发现设置127.0.0.1无法链接

安装

1
2
3
4
sudo apt-get install mysql-server
# python相关依赖
sudo apt-get install libmysqlclient-dev python3-dev
sudo mysql_secure_installation

修改配置文件

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address = 127.0.0.1注释掉
skip-external-locking后面新增一行字符集编码character-set-server=utf8

重启mysql服务
sudo /etc/init.d/mysql restart

检查防火墙

修改用户信息

1
2
3
4
5
create user 'dawn'@'%' identified by '密码';
grant all privileges on *.* to 'dawn'@'%' identified by '密码'with grant option;
# mysql8.0 授权更新为不需要认证密码
grant all privileges on *.* to 'dawn'@'%' with grant option;
flush privileges;
  1. 1. 描述
  2. 2. 安装
  3. 3. 修改配置文件