ubuntu server配置mysql并实现远程连接

ubuntu server配置mysql并实现远程连接

服务器：ubuntu server 16.04 LSS

客户机：ubuntu 16.04 LTS

服务器配置

• 服务器安装mysql

  
  # eric @ userver in ~ [14:00:31] 
  
  $ sudo apt install mysql-server install mysql-client libmysqlclient-dev
  

• 检查是否成功SET PASSWORD FOR ‘pig’@’%’ = PASSWORD(“123456”);

  
  # eric @ userver in ~ [14:10:55] 
  
  $ sudo netstat -tap | grep mysql
  tcp  0   0 localhost:mysql  *:*  LISTEN  5287/mysqld     

• 修改远程连接配置文件

  
  # eric @ userver in ~ [14:16:26] 
  
  $ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf 
  
  
  #注释掉 bind-address           = 127.0.0.1
  
  
  #bind-address           = 127.0.0.1
  

• 设置服务器数据库字符为utf-8

  
  # eric @ userver in ~ [14:16:26] 
  
  $ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf 
  
  #在[mysqld] 中添加：character-set-server=utf8
  
  [mysqld]
  #
  
  # * Basic Settings
  
  #
  user            = mysql
  pid-file        = /var/run/mysqld/mysqld.pid
  socket          = /var/run/mysqld/mysq