liunx系统下mysql常见异常
liunx系统下mysql常见错误
1、mysql: Character set 'gbk' is not a compiled character set and is not specified in the '/opt/mysql/share/mysql/charsets/Index.xml' file
说明my.cnf中缺少配置参数,解决方案如下:
1、先进入文件系统,进入/etc/,找到my.cnf文件/etc/my.cnf
2、打开my.cnf文件,找到下面内容,然后加入红色内容:
# The following options will be passed to all MySQL clients [client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf8 # 需要我们手动加入的语句