疯狂痴呆 发表于 2015-8-13 01:21:11

MYSQL启动不了,好似是机房断电还是怎么后就这样了

150813 01:18:04 mysqld_safe Starting mysqld daemon with databases from /home/mysql/
1508131:18:05 InnoDB: The InnoDB memory heap is disabled
1508131:18:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1508131:18:05 InnoDB: Compressed tables use zlib 1.2.3
1508131:18:05 InnoDB: Initializing buffer pool, size = 16.0M
1508131:18:05 InnoDB: Completed initialization of buffer pool
1508131:18:05 InnoDB: highest supported file format is Barracuda.
1508131:18:06InnoDB: Waiting for the background threads to start
1508131:18:07 InnoDB: 5.5.42 started; log sequence number 1595675
1508131:18:07 Server hostname (bind-address): '0.0.0.0'; port: 3306
1508131:18:07    - '0.0.0.0' resolves to '0.0.0.0';
1508131:18:07 Server socket created on IP: '0.0.0.0'.
1508131:18:07 Event Scheduler: Failed to open table mysql.event
1508131:18:07 Event Scheduler: Error while loading from disk.
1508131:18:07 Event Scheduler: Purging the queue. 0 events
1508131:18:07 Aborting

1508131:18:07InnoDB: Starting shutdown...
1508131:18:08InnoDB: Shutdown completed; log sequence number 1595675
1508131:18:08 /usr/local/mysql/bin/mysqld: Shutdown complete

150813 01:18:08 mysqld_safe mysqld from pid file /home/mysql//cloud.pid ended



./mysql-bin.000001

licess 发表于 2015-8-15 09:17:03

你改了目录?

ls -lh /home/mysql 看一下权限

疯狂痴呆 发表于 2015-8-15 22:10:49

回复 2# 的帖子

这个有问题吗?

[ 本帖最后由 疯狂痴呆 于 2015-8-15 22:12 编辑 ]

licess 发表于 2015-8-16 11:26:47

权限一块就不对,属主和属组必须都是mysql

chown mysql:mysql -R /home/mysql

疯狂痴呆 发表于 2015-8-16 13:03:52

回复 4# 的帖子

感谢,已OK·········
页: [1]
查看完整版本: MYSQL启动不了,好似是机房断电还是怎么后就这样了