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? # 需要我们手动加入的语句