linux上mysql编码 utf-8设置

灰太狼 2022-06-08 03:23 195阅读 0赞

## vi /etc/my.cnf ##

# For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
    [mysqld]
    #
    # 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
    #
    # 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
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    character-set-server=utf8
    
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    # Recommended in standard MySQL setup
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
    [mysql]
    default-character-set=utf8
    
    [client]
    default-character-set=utf8

> SHOW VARIABLES LIKE ‘character%’;  
> \+————————–+—————————-+  
> | 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/share/mysql/charsets/ |  
> \+————————–+—————————-+