在MAC下配置mysql数据库的编码问题
最近安装了mac osx lion系统，然后安装了mysql5.5.16版本的数据库进行开发，但是大家都知道，mysql的默认编码是latin1，如果存储中文的话就会出现乱码，然后就狂google这个问题，但是一直都没有解决，网上大部分的回答都是如下：1.拷贝/usr/local/mysql/support-files下的任意一个*.cnf文件到/etc/my.cnf；
2.在my.cnf文件的［mysqld］和［client］后面添加一句default-character-set=utf8（或者是default_character_set=utf8）；
3.保存退出；
4.重新启动mysql服务器就可以。
可是我试过好多次，这样修改之后，mysql服务根本就启动不了。
偶然的机会，我发现了一个关于在linux下配置mysql的编码问题的方法，抱着试试看的态度，我进行了修改，发现真的可以用，因此发这篇博文希望装mac的朋友不用再走弯路了。配置方法如下：
1.拷贝/usr/local/mysql/support-files下的任意一个*.cnf文件到/etc/my.cnf；
2.在my.cnf文件的［client］后面添加一句default-character-set=utf8（ 不是default_character_set=utf8，这个配置我没有试过，不知道能不能成功），关键在这里的配置，在［mysqld］后面添加如下三句：
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci；
3.保存退出；
4.重新启动mysql服务器就可以。
然后再就入mysql数据库查看编码发现改成了utf8了。
下面是我重启mysql服务器进入mysql数据库查出来的结果：
Welcome to the MySQL monitor.Commands end with ; or \g.Your MySQL connection id is 520Server version: 5.5.16 MySQL Community Server (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show variables like '%char%';+--------------------------+--------------------------------------------------------+| 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-5.5.16-osx10.6-x86_64/share/charsets/ |+--------------------------+--------------------------------------------------------+8 rows in set (0.00 sec)
至此，这个困扰多日的问题终于解决了。
附修改好的 my.cnf文件内容，不知道为什么附件我上传不了，就把代码贴出来吧：
# Example MySQL config file for small systems.## This is for a system with little memory (<= 64M) where MySQL is only used# from time to time and it's important that the mysqld daemon# doesn't use much resources.## MySQL programs look for option files in a set of# locations which depend on the deployment platform.# You can copy this option file to one of those# locations. For information about these locations, see:# http://dev.mysql.com/doc/mysql/en/option-files.html## In this file, you can use all long options that a program supports.# If you want to know which options a program supports, run the program# with the "--help" option.# The following options will be passed to all MySQL clientsdefault-character-set=utf8#password= your_passwordport= 3306socket= /tmp/mysql.sock# Here follows entries for some specific programs# The MySQL serverdefault-storage-engine=INNODBcharacter-set-server=utf8collation-server=utf8_general_ciport= 3306socket= /tmp/mysql.sockskip-external-lockingkey_buffer_size = 16Kmax_allowed_packet = 1Mtable_open_cache = 4sort_buffer_size = 64Kread_buffer_size = 256Kread_rnd_buffer_size = 256Knet_buffer_length = 2Kthread_stack = 128K# Don't listen on a TCP/IP port at all. This can be a security enhancement,# if all processes that need to connect to mysqld run on the same host.# All interaction with mysqld must be made via Unix sockets or named pipes.# Note that using this option without enabling named pipes on Windows# (using the "enable-named-pipe" option) will render mysqld useless!# #skip-networkingserver-id= 1# Uncomment the following if you want to log updates#log-bin=mysql-bin# binary logging format - mixed recommended#binlog_format=mixed# Causes updates to non-transactional engines using statement format to be# written directly to binary log. Before using this option make sure that# there are no dependencies between transactional and non-transactional# tables such as in the statement INSERT INTO t_myisam SELECT * FROM# t_innodb; otherwise, slaves may diverge from the master.#binlog_direct_non_transactional_updates=TRUE# Uncomment the following if you are using InnoDB tables#innodb_data_home_dir = /usr/local/mysql/data#innodb_data_file_path = ibdata1:10M:autoextend#innodb_log_group_home_dir = /usr/local/mysql/data# You can set .._buffer_pool_size up to 50 - 80 %# of RAM but beware of setting memory usage too high#innodb_buffer_pool_size = 16M#innodb_additional_mem_pool_size = 2M# Set .._log_file_size to 25 % of buffer pool size#innodb_log_file_size = 5M#innodb_log_buffer_size = 8M#innodb_flush_log_at_trx_commit = 1#innodb_lock_wait_timeout = 50quickmax_allowed_packet = 16Mno-auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updateskey_buffer_size = 8Msort_buffer_size = 8Minteractive-timeout
页:
[1]