mysql数据库安装过程中遇见的问题及解决办法
来源:互联网 发布:百胜erp软件下载 编辑:程序博客网 时间:2024/05/17 23:37
Starting MySQL...Manager of pid-file quit without updating[failue]
解决办法:
修改启动脚本文件:/etc/init.d/mysqld
conf=/usr/local/mysql/etc/my.cnf
问题2:
[root@localhost scripts]# ./mysql_install_db --user=mysql --datadir=/database/mydata
FATAL ERROR: please install the following Perl modules before executing ./mysql_install_db:
Data::Dumper
解决办法:
[root@localhost scripts]# rpm -ivh /mnt/Packages/perl-Data-Dumper-2.145-3.el7.x86_64.rpm
warning: /mnt/Packages/perl-Data-Dumper-2.145-3.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID fd431d51: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:perl-Data-Dumper-2.145-3.el7 ################################# [100%]
问题3:
linux启动mysql报Fatal error:Can't change to run as user 'mysql' Please check that the user exists
解决办法:
1、创建mysql用户
useradd mysql
2、mysql目录改为mysql读写权限
chown -R mysql:mysql /var/lib/mysql
chown -R mysql:mysql /usr/local/mysql
问题4
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/database/mydata
Installing MySQL system tables...2015-10-30 14:18:43 5981 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-10-30 14:18:43 5981 [Note] InnoDB: The InnoDB memory heap is disabled
2015-10-30 14:18:43 5981 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-10-30 14:18:43 5981 [Note] InnoDB: Memory barrier is not used
2015-10-30 14:18:43 5981 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-10-30 14:18:43 5981 [Note] InnoDB: Using CPU crc32 instructions
2015-10-30 14:18:43 5981 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-10-30 14:18:43 5981 [Note] InnoDB: Completed initialization of buffer pool
2015-10-30 14:18:43 5981 [Note] InnoDB: Restoring page 0 of tablespace 0
2015-10-30 14:18:43 5981 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2015-10-30 14:18:43 5981 [ERROR] InnoDB: space header page consists of zero bytes in data file ./ibdata1
2015-10-30 14:18:43 5981 [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!
2015-10-30 14:18:43 5981 [ERROR] Plugin 'InnoDB' init function returned error.
2015-10-30 14:18:43 5981 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-10-30 14:18:43 5981 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-10-30 14:18:43 5981 [ERROR] Aborting
2015-10-30 14:18:43 5981 [Note] Binlog end
2015-10-30 14:18:43 5981 [Note] ./bin/mysqld: Shutdown complete
解决办法:
1.删除数据库目录下的文件ib_logfile0和ib_logfile1,我在安装时定义的数据库目录是/database/mydata
rm -rf /database/mydata/l
2.再次执行脚本
[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/database/mydata
- mysql数据库安装过程中遇见的问题及解决办法
- Mysql安装过程中遇到的问题及解决办法
- ubuntu安装mysql数据库遇到的问题及解决办法
- SQL Service2008安装过程中遇到的问题及解决办法
- NGUI使用过程中遇见的问题
- 学习android及自动化测试中遇见的问题及解决办法总汇
- 安装ubuntu8.10遇见到问题及解决办法
- centos7中源码安装mysql过程及遇到的问题
- Genymotion 安装遇见的问题及解决方法
- mini2440交叉编译工具安装及使用过程中可能会遇到的问题及解决办法
- netBeans使用过程中遇见问题及解决方法
- nodejs 连接MySQL数据库及插入数据遇见的问题总结
- oracle安装中遇见的问题
- vpn 安装L2TP中遇见的问题
- Ubuntu 搭建LNMP环境---及过程中所遇见的问题的相关解决方法
- cocopods安装使用和安装过程中遇到的问题及解决办法(2016)
- 使用 facebook pop 遇见的问题及解决办法
- Java与mysql数据库编程中遇见“Before start of result set at com.mysql.jdbc.SQLError.createSQLException” 的解决办法
- CRichEditCtrl
- 学习笔记:如何成为一个优秀的scrum master
- nodeJS第二章
- 一台机器上同时部署多个tomcat服务
- Aizu-0118 Property Distribution
- mysql数据库安装过程中遇见的问题及解决办法
- Git常用命令速查04 - 提交历史
- js从写alert样式
- java事件处理机制(自定义事件)
- Java中的过滤器doFilter里的chain.doFilter()函数理解
- oracle系统包——dbms job用法(oracle定时任务)
- 51nod 1069 Nim游戏 (博弈论)
- MD5加密算法的java实现
- Android中Activity四种启动模式和taskAffinity属性详解