#? ? (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id? ? ? = 2
#
# The replication master for this slave - required
#master-host? ? =?
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user? ? =?
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =?
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port? ? =?
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 256M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set=utf8
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
4. 启动MySQL
# /etc/init.d/mysql start
5. 再次查看编码
mysql> show variables like '%character%';
注:即使做了以上修改如果直接数据库再创建表,然后存入中文,取出来的还会是问号。
解决的办法是:创建数据库的时候指明默认字符集为utf8,如:
create database test default character set utf8;