- mysql启动不了，innodb引擎，报以下错误 ：
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
160929 10:10:04 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
160929 10:10:04 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
原因是磁盘空间满了，处理方法是处理一下空间，然后在重启，不行的话，可能要重启一下系统了。
2、mysql5.6.32初始化时报以下错：
[root@ynuts-backup mysql]# /application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql
FATAL ERROR: please install the following Perl modules before executing /application/mysql/scripts/mysql_install_db:
Data::Dumper
[root@ynuts-backup mysql]#处理方法：安装perl模块就可以了。yum install perl-Module-Install.noarch -y
3、授权报错（grant）
在mysqldump备份用户授权的时候会以下错误：
mysql> grant select,reload,lock tables on zabbix.* to 'zabbix2'@'localhost' identified by '123456'; ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
上面报错的原因是上面三个权限有的权限是全局的，需要对所有数据库，不能对单个数据库，所以就会报错，所以需要更改成以下命令就不会报错：
mysql> grant select,reload,lock tables on *.* to 'zabbix1'@'localhost' identified by '1223456';Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show grants for zabbix1@localhost;
+-----------------------------------------------------------------------------+
| Grants for zabbix1@localhost |+-----------------------------------------------------------------------------+
| GRANT SELECT, RELOAD, LOCK TABLES ON *.* TO 'zabbix1'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `zabbix`.* TO 'zabbix1'@'localhost' |+-----------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
原文链接：mysql相关错误总结，转载请注明来源！