oel5.5安装mysql数据库初始化报错解决办法

时间:2022-09-18 08:02:17

[root@chavinking mysql]# scripts/mysql_install_db --user=mysql
Installing MySQL system tables...2016-12-02 00:05:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-02 00:05:00 0 [Note] ./bin/mysqld (mysqld 5.6.24) starting as process 3711 ...
2016-12-02 00:05:00 3711 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-12-02 00:05:00 3711 [Note] InnoDB: The InnoDB memory heap is disabled
2016-12-02 00:05:00 3711 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-12-02 00:05:00 3711 [Note] InnoDB: Memory barrier is not used
2016-12-02 00:05:00 3711 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-12-02 00:05:00 3711 [Note] InnoDB: Using Linux native AIO
2016-12-02 00:05:00 3711 [Note] InnoDB: Not using CPU crc32 instructions
2016-12-02 00:05:00 3711 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-12-02 00:05:00 3711 [Note] InnoDB: Completed initialization of buffer pool
2016-12-02 00:05:00 3711 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
2016-12-02 00:05:00 3711 [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-12-02 00:05:00 3711 [ERROR] Plugin 'InnoDB' init function returned error.
2016-12-02 00:05:00 3711 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-12-02 00:05:00 3711 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-12-02 00:05:00 3711 [ERROR] Aborting

2016-12-02 00:05:00 3711 [Note] Binlog end
2016-12-02 00:05:00 3711 [Note] ./bin/mysqld: Shutdown complete

[root@chavinking mysql]# ll /etc/my.cnf
-rw-r--r-- 1 root root 441 Feb 17  2010 /etc/my.cnf
[root@chavinking mysql]# mv /etc/my.cnf /etc/my.cnf.bak

oel5.5安装mysql数据库初始化报错解决办法的更多相关文章

  1. 安装`lrzsz`包及其报错解决办法

    rz命令的安装包名是lrzsz. 安装lrzsz包时报错Failed to mount cd:///?devices=/dev/sr1,/dev/sr0 on /var/adm/mount/AP_0x ...

  2. 阿里云安装mysql数据库出现2002错误解决办法

    在安装数据库的时候出现了如下错误: 解决办法如下: 1.在bin目录下 输入:kill -s 9 9907 再输入:ps -ef|grep mysql 显示如下: 2.回到lampp目录下,重启数据库 ...

  3. 按照教程自动安装RFNoC时.在使用pip安装pybombs时出现报错,解决办法

    $ sudo apt-get install git $ sudo apt-get install python-setuptools python-dev python-pip build-esse ...

  4. R语言安装openxl包报错解决办法

    在R语言中使用openxlsx包,会报错 解决办法就是: 下载安装Set-Rtool,安装时注意勾选对话框 然后在R中运行以下代码: Sys.setenv("R_ZIPCMD" = ...

  5. sphinx :undefined reference to `libiconv' 报错解决办法

    sphinx :undefined reference to `libiconv' 报错解决办法   2013-11-30 21:45:39 安装sphinx时不停报错...郁闷在make时报错,错误 ...

  6. MySQL数据库忘记root密码解决办法

    MySQL数据库忘记root密码解决办法 1.在运行输入services.msc打开服务窗体,找到MYSQL服务.右键停止将其关闭.如图:

  7. [原创]MySQL数据库忘记root密码解决办法

    MySQL数据库忘记root密码解决办法 1.在运行输入services.msc打开服务窗体,找到MYSQL服务.右键停止将其关闭.如图:

  8. Aasible中cryptography兼容性报错解决办法

    Aasible中cryptography兼容性报错解决办法 1 Ansible中使用ansible --version查看版本,报错信息如下: ERROR! Unexpected Exception, ...

  9. [异常篇]001.MySQL数据库忘记root密码解决办法[转载]

    MySQL数据库忘记root密码解决办法 1.在运行输入services.msc打开服务窗体,找到MYSQL服务.右键停止将其关闭.如图: 2.在运行输入cmd打开终端. 3.找到MYSQL的安装目录 ...

随机推荐

  1. He faced a maximum sentence of three years.

    Police raided his home in August and found more than 100g of marijuana. He faced a maximum sentence ...

  2. Swing做的非阻塞式仿飞秋聊天程序

    采用Swing 布局 NIO非阻塞式仿飞秋聊天程序, 切换皮肤颜色什么的小功能以后慢慢做 启动主程序. 当用户打开主程序后自动获取局域网段IP可以在 设置 --> IP网段过滤, 拥有 JMF ...

  3. __attribute__机制介绍

    转载:http://blog.csdn.net/ithomer/article/details/6566739 1. __attribute__ GNU C的一大特色(却不被初学者所知)就是__att ...

  4. 重载 vs 重写

    http://www.cnblogs.com/lonelyDog/archive/2011/11/16/2251011.html

  5. 如何启动linux的telnet服务--转载

    如何启动linux的telnet服务 如何启动linux的telnet服务 步骤如下: 1.如果安装了telnet.telnet-server的rpm包,就跳到2.,否则安装这个包. 2.修改teln ...

  6. ABP+AdminLTE+Bootstrap Table权限管理系统第六节--abp控制器扩展及json封装以及6种处理时间格式化的方法

    返回总目录:ABP+AdminLTE+Bootstrap Table权限管理系统一期 一,控制器AbpController 说完了Swagger ui 我们再来说一下abp对控制器的处理和json的封 ...

  7. 使用html+css+js实现弹球游戏

    使用html+css+js实现弹球游戏 效果图: 代码如下,复制即可使用: <!doctype html> <head> <style type="text/c ...

  8. chrome中image图片预留位置的问题

    在项目中发现,当设置 <img src="" width="100" height="100"> 通过设置img的width属性 ...

  9. 关闭在chrome里使用双指前进后退页面的功能

    defaults write com.google.Chrome AppleEnableSwipeNavigateWithScrolls -bool FALSE

  10. saltstack常用模块

    介绍一些常用的saltstack模块,更多模块参考官方网站 1.跟安装包相关的模块:salt.states.pkg salt.states.pkg.downloaded(name, version=N ...