mysql出现乱码
1.修改/etc/mysql/my.cnf
sudo gedit /etc/mysql/my.cnf drwxrwxrwx
2.在my.cnf文件中的[client]段和 [mysqld]段加上以下两行内容:
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
3.重新启动MySQL:
sudo /etc/init.d/mysql restart
查看一下现在mysql的编码
show variables like 'character%';
4.表出现问题后需要设置utf8
create database new_databasename default charset utf8;
1.修改/etc/mysql/my.cnf
sudo gedit /etc/mysql/my.cnf drwxrwxrwx
2.在my.cnf文件中的[client]段和 [mysqld]段加上以下两行内容:
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
3.重新启动MySQL:
sudo /etc/init.d/mysql restart
查看一下现在mysql的编码
show variables like 'character%';
4.表出现问题后需要设置utf8
create database new_databasename default charset utf8;