主要涉及到Tomcat和MySQL的配置。
操作系统centos7。
1.配置Tomcat
用Xftp找到下面的文件
/usr/local/tomcat/conf/server.xml
增加下图中红框内的语句,保存
重启Tomcat,用puTTY远程登录,依次输入以下指令
cd /usr/local/tomcat/bin
sh shutdown.sh
sh startup.sh
2.配置MySQL
用Xftp远程登录
找到/etc/my.cnf这个文件
在最下面一行添加
character_set_server=utf8
保存
用PuTTY远程登录
输入以下指令登录MySQL
mysql -u [用户名] -p
输入密码后回车登录
登录后输入以下指令查看MySQL字符集
show variables like '%character%'
会出现
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)
可以看到character_set_database和character_set_server的字符集不是utf8
输入以下指令
set character_set_database = utf8;
set character_set_server = utf8;
输入以下指令再次查看字符集
SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------------+
| 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/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)
然后输入以下指令重启MySQL
systemctl restart mysqld.service
完毕!