安装地址:https://www.cnhzz.com/mysql-5-6-21_install/
一,登陆mysql时候出现:Segmentation fault(dumped)
解决:
是因为缺少mysql-libs-5.1.61-4.el6.x86_64
然后在执行yum install mysql-devel这个命令就行了
二,配置/etc/my.cnf文件
datadir=/usr/local/mysql/data
#default-character-set=utf8
character-set-server=utf8
解决:
1,datadir 要配置到mysql安装目录的data下
2,不要使用default-character-set=utf8,
或者启动mysql,可能会报错:
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/datanode2.pid).
三,mysqlbinlo查看日志报错:ERROR: Error in Log_event::read_log_event(): 'Sanity check failed', data_len: 8186, event_type: 30
解决:
查看默认版本:是3.3
[root@datanode2 data]# mysqlbinlog -V
mysqlbinlog Ver 3.3 for redhat-linux-gnu at x86_64
查看当前mysql版本:是3.4
/usr/local/mysql/bin/mysqlbinlog -V
/usr/local/mysql/bin/mysqlbinlog Ver 3.4 for Linux at x86_64
所以用3.4版本去查看就没有问题了