mysql5.6安装及配置utf8

最新推荐文章于 2021-05-02 02:34:24 发布

努力，加油，奋斗

最新推荐文章于 2021-05-02 02:34:24 发布

阅读量440

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/qq_43681948/article/details/103489941

版权

mysql 专栏收录该内容

2 篇文章

订阅专栏

本文提供了MySQL5.6的安装链接，并详细介绍了如何在Windows、Mac和Linux上配置数据库以使用UTF-8编码。在Windows上安装时选择UTF-8编码，而在配置文件my.ini或my.cnf中添加相关设置，然后重启MySQL服务以确保编码设置生效。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql5.6安装步骤链接：
https://www.cnblogs.com/alan-lin/p/9966917.html
配置utf8
在Windows上，安装时请选择UTF-8编码，以便正确地处理中文。
在my.ini加
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
default-character-set=utf8

[mysqld]
default-character-set=utf8

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
basedir = D:\Program Files\mysql-5.6

datadir = D:\Program Files\mysql-5.6\data

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

在Mac或Linux上，需要编辑MySQL的配置文件，把数据库默认的编码全部改为UTF-8。MySQL的配置文件默认存放在/etc/my.cnf或者/etc/mysql/my.cnf：

[client]
default-character-set = utf8

[mysqld]
default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_general_ci

重启MySQL后，可以通过MySQL的客户端命令行检查编码：

$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor...
...

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.1.65-osx10.6-x86_64/share/charsets/ |
+--------------------------+--------------------------------------------------------+
8 rows in set (0.00 sec)

看到utf8字样就表示编码设置正确。