Ubuntu 上这样操作
1.关闭mysql服务
sudo /etc/init.d/mysql stop
2.vi编辑器打开/etc/mysql/my.cnf文件 sudo vim /etc/mysql/my.cnf
sudo vi /etc/my.cnf
sudo vim /etc/mysql/my.cnf
添加下面的命令
[client]
default-character-set=utf8
[server]
default-character-set=utf8
[mysql]
default-character-set=utf8
--重启mysql服务
sudo /etc/init.d/mysql restart
--查看mysql字符编码
show variables like 'character%';
--把/etc/mysql/my.cnf copt /etc/my.cnf(如果存在,会覆盖)
sudo cp /etc/mysql/my.cnf /etc/my.cnf
--在tomcat目录bin下执行启动tomcat服务
./startup.sh start
CentOS上把default-character-set=utf8 换成character-set-server=utf8