服務器：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 mysqltcp 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 = mysqlpid-file = /var/run/mysqld/mysqld.pidsocket = /var/run/mysqld/mysqld.sockport = 3306basedir = /usrdatadir = /var/lib/mysqltmpdir = /tmplc-messages-dir = /usr/share/mysqlskip-external-lockingcharacter-set-server=utf8 #新增加#登錄mysql查看字符# eric @ userver in ~ [14:21:26]$ mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 4Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql> show variables like '%char%';+--------------------------+----------------------------+| Variable_name | Value |+--------------------------+----------------------------+| character_set_client | utf8 || character_set_connection | utf8 || character_set_database | utf8 || character_set_filesystem | binary || character_set_results | utf8 || character_set_server | utf8 || character_set_system | utf8 || character_sets_dir | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+8 rows in set (0.00 sec) |
新建遠程登錄用戶并授權
| mysql> create user 'eric'@'%' identified by 'lyd2017';Query OK, 0 rows affected (0.01 sec)mysql> grant all on *.* to 'eric'@'%';--所有權限Query OK, 0 rows affected (0.00 sec) |
關于授權：
命令：GRANT privileges ON databasename.tablename TO 'username'@'host'
說明：privileges-用戶的操作權限，如select，insert,update 等，如果要授予所有權則使用all
如果要授予該用戶對所有數據庫和表的操作權限則用* 表示，如 *.*
例如：
| GRANT SELECT, INSERT ON mysql.tables TO 'eric'@'%';GRANT ALL ON *.* TO 'eric'@'%'; |
