mysql登录时，弹出错误信息

little_angel

1.正常启动mysql

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

复制代码

2.登录操作

1. mysqld -uroot -pDJGN9M5fHkY5y4wN

复制代码

3.然后就弹出错误信息

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.
    

复制代码

我尝试了一些方法，但还是未解决，求助各位大声。。。。。

little_angel

在线等~~~~

bamqjurgg

mysql是以root用户启动的？ 改为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.

这些文件都被锁定了，说明有进程正在使用，是不是已经启动了一个mysql，

chenyx

系统有另外的mysql服务在运行吧，楼主最好用service mysql restart来启动服务。