2016/9/6补充
初始化报错：
# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysqldb/
Installing MySQL system tables...2016-09-06 17:29:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-09-06 17:29:17 0 [Note] /usr/local/mysql//bin/mysqld (mysqld 5.6.32) starting as process 21651 ...
2016-09-06 17:29:19 21651 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-09-06 17:29:19 21651 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-06 17:29:19 21651 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-09-06 17:29:19 21651 [Note] InnoDB: Memory barrier is not used
2016-09-06 17:29:19 21651 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-06 17:29:19 21651 [Note] InnoDB: Using CPU crc32 instructions
/usr/local/mysql//bin/mysqld: Can't create/write to file '/tmp/ibEKTPAP' (Errcode: 13 - Permission denied)
2016-09-06 17:29:19 7f72573f0720 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-06 17:29:19 21651 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-06 17:29:19 21651 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-06 17:29:19 21651 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-06 17:29:19 21651 [ERROR] Aborting
2016-09-06 17:29:19 21651 [Note] Binlog end
2016-09-06 17:29:19 21651 [Note] /usr/local/mysql//bin/mysqld: Shutdown complete
解决方法：
# chmod 777 /tmp
第一次安装mysql，启动时报错
# /etc/init.d/mysqld start
Starting MySQL.......The server quit without updating PID f[失败]tmp/mysql.pid).
查看日志
# tailf /data/mysqldb/log/mysql-error.log
160730 00:57:28 mysqld_safe Starting mysqld daemon with databases from /data/mysqldb
2016-07-30 00:57:29 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.31-log) starting as process 18702 ...
2016-07-30 00:57:29 18702 [Warning] option 'innodb-buffer-pool-instances': signed value -1 adjusted to 0
.........
2016-07-30 00:57:29 18702 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 131072 pages, max 0 (relevant if non-zero) pages!
2016-07-30 00:57:29 18702 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2016-07-30 00:57:29 18702 [ERROR] Plugin 'InnoDB' init function returned error.
2016-07-30 00:57:29 18702 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-07-30 00:57:29 18702 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-07-30 00:57:29 18702 [ERROR] Aborting
......
160730 00:57:29 mysqld_safe mysqld from pid file /tmp/mysql.pid ended
解决方法
# ls /data/mysqldb
binlog ibdata1 ib_logfile0 ib_logfile1 log mysql performance_schema test
重命名或者直接删除这三个文件
# mv ibdata1 ibdata1.bak
# mv ib_logfile0 ib_logfile0.bak
# mv ib_logfile1 ib_logfile1.bak
# /etc/init.d/mysqld start
Starting MySQL........................ [确定]
之前因为总是断电，启动数据库报如下类似错误
# /etc/init.d/mysqld status
MySQL is not running, but lock file (/var/lock/subsys/mysql[失败]ts
查看日志
# tailf /data/mysqldb/log/mysql-error.log
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
160801 19:30:39 mysqld_safe mysqld from pid file /tmp/mysql.pid ended
解决方法
同上，删除那几个文件即可
Ubuntu操作系统编译安装zabbix报错汇总
Ubuntu操作系统编译安装zabbix报错汇总 作者:尹正杰 版权声明:原创作品,谢绝转载!否则将追究法律责任. 一.报错提示:"configure: error: MySQL libra ...
python MySQL安装依赖报错的坑
0X01 问题 MySQL-python是python调用MySQL的常用库 通常安装时会遇到某些坑. EnvironmentError: mysql_config not found yum -y ...
1、linux下mysql5.5.20安装过程报错汇总
1.Access denied for user 'root'@'localhost' (using password: YES) 这个提示是因为root帐户默认不开放远程访问权限,所以需要修改一下相 ...
jmeter安装启动报错：Not able to find Java executable or version. Please check your Java installation
1.xp安装jmeter后启动,出现下面错误,找了很多方法试了,都没有用: 2.最后找到一个方法解决了[感谢无名大神],在环境变量PATH中添加:%SystemRoot%/system32;%Syst ...
mysql启动报错，与selinux相关
mysql启动报错,与selinux相关 如果遇到报错,可能的情况是 selinux 的关系,可以安装 setroubleshoot-server 工具,使用 sealert -a /var/log/ ...
mysql启动报错：Starting MySQL...The server quit without updating PID file
在mysql的data目录下误删除了mysql-bin.000001,mysql-bin.000002等文件,但是没有删除mysql-bin.index文件,此时启动mysql就会报错: Starti ...
安装mongodb后启动报错libstdc++
安装mongo后启动报错如下图 显然说是libstdc++.so文件版本的问题,这种一般都是gcc版本太低了 接着查询gcc的版本 strings /usr/lib/libstdc++.so.6 ...
随机推荐
模拟实现Spring中的注解装配
本文原创,地址为http://www.cnblogs.com/fengzheng/p/5037359.html 在Spring中,XML文件中的bean配置是实现Spring IOC的核心配置文件,在 ...
在列表页，按照指定的category取所属的post列表
在某些指定的页面,例如news,blog等页面,需要列出指定某种类型的文章列表,这种情况下,可以先添加两个category,分别命名news,blog,然后再分别添加几个post,指定每个post所属 ...
puppet常用调试命令
yum快速部署puppet测试环境(C/S端) rpm -ivh http://yum.puppetlabs.com/puppetlabs-release-el-7.noarch.rpm yum r ...
Asp.Net MVC 上传图片到数据库
[读书笔记]Asp.Net MVC 上传图片到数据库(会的绕行) 之前上传图片的做法都是上传到服务器上的文件夹中,再将url保存到数据库.其实在MVC中将图片上传到数据库很便捷的事情,而且不用去存 ...
NOIP2015游记——一次开心又失望的旅行
啊,一年一度的NOIP终于是结束了 以前的大神都有写自己的感受 然而我居然给忘了!!!! 吓得我赶紧来写一份游记 Day.-INF--出发前一个星期 机智的我选择了停课 就是为了OIER这伟大而又光荣 ...
OpenCV角点检测源代码分析(Harris和ShiTomasi角点)
OpenCV中常用的角点检测为Harris角点和ShiTomasi角点. 以OpenCV源代码文件 .\opencv\sources\samples\cpp\tutorial_code\Trackin ...
2017-9-19 c语言预备作业
题目一: (1)我对邹欣老师博客内容的看法 针对邹欣老师的第一种看法,也就是文中所谈的春蚕与园丁的例子.我认为在大学之前的阶段,师生关系可以如此比喻,因为在中学阶段教师与学生的关系,更多地是一个知识的 ...
Docker配置文件
Docker 的 Registry 利用配置文件提供了一些仓库的模板(flavor),用户可以直接使用它们来进行开发或生产部署. 模板 在 config_sample.yml 文件中,可以看到一些现成 ...
AR模块常用函数
--AR模块常用函数 FUNCTION get_fnd_user_name ( p_user_id IN NUMBER ) return VARCHAR2 IS CURSOR c_user_name ...
centos 7 hadoop的安装和使用
准备工作 安装jdk 用户免密登录 安装参考文章: http://blog.csdn.net/circyo/article/details/46724335 http://www.linuxidc.c ...