ubuntu 安装mysql 添加远程连接用户 配置远程连接设置

sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev

# 创建用户
mysql>CREATE USER ‘fixdq‘@‘%‘ IDENTIFIED BY ‘123456‘;
# 授权 远程访问的权限
mysql>GRANT ALL ON *.* TO ‘fixdq‘@‘%‘;
# 刷新系统权限表
mysql>flush privileges;

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf 
将
bind-address=127.0.0.1
修改为
bind-address=0.0.0.0

编辑完成输入
:wq
保存操作

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