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

疯狂痴呆

1. 150813 01:18:04 mysqld_safe Starting mysqld daemon with databases from /home/mysql/
   
2. 150813  1:18:05 InnoDB: The InnoDB memory heap is disabled
   
3. 150813  1:18:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
   
4. 150813  1:18:05 InnoDB: Compressed tables use zlib 1.2.3
   
5. 150813  1:18:05 InnoDB: Initializing buffer pool, size = 16.0M
   
6. 150813  1:18:05 InnoDB: Completed initialization of buffer pool
   
7. 150813  1:18:05 InnoDB: highest supported file format is Barracuda.
   
8. 150813  1:18:06  InnoDB: Waiting for the background threads to start
   
9. 150813  1:18:07 InnoDB: 5.5.42 started; log sequence number 1595675
   
10. 150813  1:18:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    
11. 150813  1:18:07 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    
12. 150813  1:18:07 [Note] Server socket created on IP: '0.0.0.0'.
    
13. 150813  1:18:07 [ERROR] Event Scheduler: Failed to open table mysql.event
    
14. 150813  1:18:07 [ERROR] Event Scheduler: Error while loading from disk.
    
15. 150813  1:18:07 [Note] Event Scheduler: Purging the queue. 0 events
    
16. 150813  1:18:07 [ERROR] Aborting
    
17. 
    
18. 150813  1:18:07  InnoDB: Starting shutdown...
    
19. 150813  1:18:08  InnoDB: Shutdown completed; log sequence number 1595675
    
20. 150813  1:18:08 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
    
21. 
    
22. 150813 01:18:08 mysqld_safe mysqld from pid file /home/mysql//cloud.pid ended

复制代码

1. ./mysql-bin.000001

复制代码

licess

你改了目录？

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

疯狂痴呆

这个有问题吗？

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

licess

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

chown mysql:mysql -R /home/mysql

疯狂痴呆

感谢，已OK·········