Chinaunix

标题: mysql登录时，弹出错误信息 [打印本页]
作者: little_angel    时间: 2015-11-04 17:37
标题: mysql登录时，弹出错误信息
本帖最后由 little_angel 于 2015-11-04 17:48 编辑

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

  4. 2015-11-05 01:30:50 2496 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

  6. 2015-11-05 01:30:50 2496 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)

  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    时间: 2015-11-04 17:44
在线等~~~~
作者: bamqjurgg    时间: 2015-11-11 00:07
mysql是以root用户启动的？ 改为mysql
作者: i6first    时间: 2015-11-17 11:24
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    时间: 2015-11-18 19:31
系统有另外的mysql服务在运行吧，楼主最好用service mysql restart来启动服务。



欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2