1.数据库编码
目的:修改库数据库编码 连接编码等均为UTF-8
数据库中输入 StatusServer characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
修改mysql.cnf文件例如:Ubuntu Server16.04为 /etc/mysql/mysql.conf.d/mysqld.cnf
(1)添加,默认[client]不存在
[client]
default-character-set=utf8
(2)在[mysqld]下添加
character-set-server=utf8
重启动服务后,数据库中输入 Status
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
2.Mysql允许远程登陆
修改mysql.cnf文件
tcp 0 0 127.0.0.1:3306
将 bind-address = 127.0.0.1 注释后 netstat -nltp 查看
tcp6 0 0 :::3306
mysql 远程登陆授权
允许root在任何地方进行远程登陆,并具有所有库任何操作权限./mysql –u root -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '111111' WITH GRANT OPTION;
FLUSH PRIVILEGE;