mysql安装报错

mysql  performance_schema  RPM_UPGRADE_HISTORY  RPM_UPGRADE_MARKER-LAST  test  wanliniu_mobile

[root@jstutf4nxxcc27 mysql]# /etc/init.d/mysql start

Starting MySQL....................................................................................The server quit without updating PID file (/var/lib/mysql/jstutf4nxxcc27.pid).                                                  [失败]

[root@jstutf4nxxcc27 mysql]# more /var/lib/mysql/jstutf4nxxcc27.pid

 

 

看了下日志

InnoDB: Some operating system error numbers are described at

InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html

130918 17:12:29 InnoDB: Could not open or create data files.

130918 17:12:29 InnoDB: If you tried to add new data files, and it failed here,

130918 17:12:29 InnoDB: you should now edit innodb_data_file_path in my.cnf back

130918 17:12:29 InnoDB: to what it was, and remove the new ibdata files InnoDB created

130918 17:12:29 InnoDB: in this failed attempt. InnoDB only wrote those files full of

130918 17:12:29 InnoDB: zeros, but did not yet use them in any way. But be careful: do not

130918 17:12:29 InnoDB: remove old data files which contain your precious data!

130918 17:12:29 [ERROR] Plugin 'InnoDB' init function returned error.

130918 17:12:29 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

130918 17:12:29 [Warning] /usr/sbin/mysqld: unknown variable 'loose-default-character-set=utf8'

130918 17:12:29 [ERROR] Unknown/unsupported storage engine: INNODB

130918 17:12:29 [ERROR] Aborting

 

130918 17:12:29 [Note] /usr/sbin/mysqld: Shutdown complete

 

130918 17:12:29 mysqld_safe mysqld from pid file /var/lib/mysql/jstutf4nxxcc27.pid ended

 

------------------------------解决-----------------------------

修改/data/mysql的权限

chown -R mysql:mysql /data/mysql

 

ps -ef | grep mysql

kill -9 xxx

 

然后启动就ok了.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值