mysql没有配置文件也可以启动,你可以把my-default.ini改名为my.ini,然后放到mysql安装根目录,在[mysqld]下加上character-set-server=utf8,
在[client]下加default-character-set=utf8。就可以了,哈哈。
Mysql查看编码方式专题
1.查看数据库的字符集
SHOW VARIABLES LIKE ''character_set_%'';
修改前输出:
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
+--------------------------+--------+
修改后:
+--------------------------+--------+
| 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 |
+--------------------------+--------+
2.首先查看系统的字符集和排序方式。如果想查看某个特定的数据库的字符集和排序方式,应该先选定数据库,
mysql>use databasename;
mysql> SHOW VARIABLES LIKE "character_set_%";
改变数据库的编码方式
alter database databasename character set utf8;