MySQL字符集设置

点击数：84

cat > /etc/my.cnf.d/utf8.cnf << EOF

[mysqld]

# mysql字符集utf8

character-set-server=utf8

collation-server=utf8_unicode_ci

init_connect='SET NAMES utf8'

skip-character-set-client-handshake=true

[client]

default-character-set=utf8

[mysql] default-character-set=utf8

[mysqldump]

user=root

EOF

====================================================

cat > /etc/my.cnf.d/utf8.cnf << EOF

[mysqld]

# mysql字符集utf8mb4

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

skip-character-set-client-handshake = true

sql_mode='STRICT_TRANS_TABLES'

max_connections=2000

innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=1

[client]

default-character-set=utf8mb4

[mysql] default-character-set = utf8mb4

EOF

# 查看初始密码（适用于mysql5.7以上版本）

grep -r 'A temporary password' /var/log/mysqld.log

# 重设密码

set password=password('Mysq@823!');

FLUSH PRIVILEGES;

# 查看编码格式

show variables like "%character%"; show variables like "%collation%";