解决报错：The server quit without updating PID file今天晚上要做一个开启MySQL bin-log日志的变更。在关闭数据库后，修改参数文件，在mysqld下加上（一定要在mysqld下加上），即可开启mysql的binlog日志[mysqld]log-bin=mysql-bin修改

MySQL启动报错InnoDB: The innodb_system data file './ibdata1' is of a differentMySQL异机迁移后，启动数据库报错#/data/mysql_57_software/bin/mysqld_safe--defaults-file=/etc/my3319.cnf--user=mysql&#tail-20/var/log/mysqld3319.log2019-01-02T07:11

Mysql:The server quit without updating PID file (/eipdb1/mysql/data/EIPDB1.pid).环境：mysql主从，一台主机，一台备机。都是虚拟机。备机仅仅用来备份，不用于业务。关闭主机mysql服务，关闭主机系统，加内存。、备机不变。

开启主机。内存加好。EIPDB1:~ # free -m

mysqld_safe The file /usr/local/mysql/bin/mysqld does not exist修改密码mysqld_safe --skip-grant-tables 报错
mysqld_safe The file /usr/local/mysql/bin/mysqlddoes not exist
可以通过软连接的方式 解决此问题
mkdir-p/usr/local/my

InnoDB: Error: space id and page n:o stored in the page?2016-06-08 04:38:11 7fa7ddd86700 InnoDB: Error: space id and page n:o stored in the page
InnoDB: read in are 4294967295:4294967295, should be 22291:4096!
InnoDB