mysql登錄時(shí)，彈出錯(cuò)誤信息

little_angel

1.正常啟動(dòng)mysql

1. -bash-4.2$ service mysql start
   
2. Starting MySQL SUCCESS!

復(fù)制代碼

2.登錄操作

1. mysqld -uroot -pDJGN9M5fHkY5y4wN

復(fù)制代碼

3.然后就彈出錯(cuò)誤信息

1. 2015-11-05 01:30:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
   
2. 2015-11-05 01:30:50 2496 [Warning] One can only use the --user switch if running as root
   
3. 
   
4. 2015-11-05 01:30:50 2496 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
   
5. 
   
6. 2015-11-05 01:30:50 2496 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
   
7. 
   
8. 2015-11-05 01:30:50 2496 [Note] Plugin 'FEDERATED' is disabled.
   
9. 2015-11-05 01:30:50 2496 [Note] InnoDB: Using atomics to ref count buffer pool pages
   
10. 2015-11-05 01:30:50 2496 [Note] InnoDB: The InnoDB memory heap is disabled
    
11. 2015-11-05 01:30:50 2496 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    
12. 2015-11-05 01:30:50 2496 [Note] InnoDB: Compressed tables use zlib 1.2.3
    
13. 2015-11-05 01:30:50 2496 [Note] InnoDB: Using Linux native AIO
    
14. 2015-11-05 01:30:50 2496 [Note] InnoDB: Using CPU crc32 instructions
    
15. 2015-11-05 01:30:50 2496 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    
16. 2015-11-05 01:30:50 2496 [Note] InnoDB: Completed initialization of buffer pool
    
17. 2015-11-05 01:30:50 2496 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    
18. 2015-11-05 01:30:50 2496 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    
19. 2015-11-05 01:30:50 2496 [Note] InnoDB: Retrying to lock the first data file
    
20. 2015-11-05 01:30:51 2496 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    
21. 2015-11-05 01:30:51 2496 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    
22. 2015-11-05 01:30:52 2496 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    
23. 2015-11-05 01:30:52 2496 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    

復(fù)制代碼

我嘗試了一些方法，但還是未解決，求助各位大聲。。。。。

little_angel

在線等~~~~

bamqjurgg

mysql是以root用戶啟動(dòng)的？ 改為mysql

i6first

2015-11-05 01:30:51 2496 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-11-05 01:30:51 2496 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2015-11-05 01:30:52 2496 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2015-11-05 01:30:52 2496 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

這些文件都被鎖定了，說(shuō)明有進(jìn)程正在使用，是不是已經(jīng)啟動(dòng)了一個(gè)mysql，

chenyx

系統(tǒng)有另外的mysql服務(wù)在運(yùn)行吧，樓主最好用service mysql restart來(lái)啟動(dòng)服務(wù)。