1、安装:
sudo apt-get install mysql-server
2、修改字符编码为utf8:
找到[client] 添加:
default-character-set=utf8
找到[mysqld] 添加:
character-set-server=utf8
init_connect='SET NAMES utf8'
重启mysql命令以便让你上面的修改生效
sudo /etc/init.d/mysql restart
检查mysql字符集
命令一:show variables like 'character%';
命令二:show variables like 'collation_%';
sudo apt-get install mysql-server
2、修改字符编码为utf8:
找到[client] 添加:
default-character-set=utf8
找到[mysqld] 添加:
character-set-server=utf8
init_connect='SET NAMES utf8'
重启mysql命令以便让你上面的修改生效
sudo /etc/init.d/mysql restart
检查mysql字符集
命令一:show variables like 'character%';
命令二:show variables like 'collation_%';