一、在系统偏好设置里关闭mysql
二、在/etc目录下创建 my.cnf文件
并配置:
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
保存后 ,重新启动mysql
三、验证是否因为配置有错误而导致mysql不能启动
mysql -u -p 登录后 输入 status;
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.7.19, for osx10.12 (x86_64) using EditLine wrapper
Connection id: 99
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.7.19 MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 5 min 53 sec
三、创建数据库设置:
CREATE DATABASE `asmybatis` CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
四、这时候,就能 顺利插入中文字符了,也不会出现乱码了!
之前的插入中文后:
mysql> insert into tb_person(name,age,sex,card_id) values("kangxg",29,'男',1);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''男',1)' at line 1
配置后 插入:
mysql> insert into tb_person(name,age,sex,card_id) values("kangxg",29,"男",1);
Query OK, 1 row affected (0.00 sec)