分享

centos6.5安装mysql后启动不起来

夜漫长 发表于 2016-8-27 21:16:32 [显示全部楼层] 回帖奖励 阅读模式 关闭右栏 4 9339
centos6.5安装mysql时,提示有依赖,强制安装后,mysql启动不起来,没有/etc/下没有my.cnf,拷贝了my-default.cnf
cp /usr/share/mysql/my-default.cnf /etc/my.cnf
my.cnf里手工增加的配置如下:
datadir = /var/lib/mysql
tmpdir = /tmp
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
innodb_use_sys_malloc =0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

可是启动service mysqld start,还是报下面的错,请各位帮忙看看。

160827 20:13:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-08-27 20:13:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-27 20:13:14 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29) starting as process 4934 ...
2016-08-27 20:13:14 4934 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
2016-08-27 20:13:14 4934 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-08-27 20:13:14 4934 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-27 20:13:14 4934 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-27 20:13:14 4934 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-27 20:13:14 4934 [Note] InnoDB: Memory barrier is not used
2016-08-27 20:13:14 4934 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-27 20:13:14 4934 [Note] InnoDB: Using Linux native AIO
2016-08-27 20:13:14 4934 [Note] InnoDB: Using CPU crc32 instructions
2016-08-27 20:13:14 4934 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-08-27 20:13:14 4934 [Note] InnoDB: Completed initialization of buffer pool
2016-08-27 20:13:14 4934 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2016-08-27 20:13:15 4934 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2016-08-27 20:13:15 4934 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-08-27 20:13:15 4934 [Warning] InnoDB: New log files created, LSN=1601036
2016-08-27 20:13:15 4934 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-27 20:13:15 4934 [Note] InnoDB: 128 rollback segment(s) are active.
2016-08-27 20:13:15 4934 [Note] InnoDB: Waiting for purge to start
2016-08-27 20:13:15 4934 [Note] InnoDB: 5.6.29 started; log sequence number 1601548
2016-08-27 20:13:15 4934 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-27 20:13:15 4934 [Note] IPv6 is not available.
2016-08-27 20:13:15 4934 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2016-08-27 20:13:15 4934 [Note] Server socket created on IP: '0.0.0.0'.
2016-08-27 20:13:15 4934 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
160827 20:13:15 mysqld_safe mysqld from pid file /var/lib/mysql/da1.com.cn.pid ended

已有(4)人评论

跳转到指定楼层
einhep 发表于 2016-8-27 21:21:31
应该是缺一些组件或则文件。
最好不要强制安装。
可以下载mysql安装包,然后直接配置。

回复

使用道具 举报

夜漫长 发表于 2016-8-27 21:31:33
centos6.5之前安装系统时是装的带图形桌面的,卸掉图形桌面后,安装mysql都很正常,为何这次最小化安装操作系统后,安装mysql却提示依赖关系呢?跟系统安装的选择有关系吗?
回复

使用道具 举报

einhep 发表于 2016-8-27 21:47:23
夜漫长 发表于 2016-8-27 21:31
centos6.5之前安装系统时是装的带图形桌面的,卸掉图形桌面后,安装mysql都很正常,为何这次最小化安装操作 ...

有些关系,但是关系不大的。系统上都是可以安装mysql的。
先看看缺什么依赖,安装上即可
回复

使用道具 举报

liuzhixin137 发表于 2016-8-29 08:32:20
直接装完mysql ,你不要修改配置 试试能不能起来
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

推荐上一条 /2 下一条