The server quit without updating PID file (/mydata/mysql/BIDB.pid).[FAILED]

  • urgel_babay

    2016-02-29 17:12:55
  • MySQL
  • 转载
刚刚安装的MySQL 启动时报错：
[root@BIDB scripts]# ../support-files/mysql.server start
Starting MySQL........The server quit without updating PID file (/mydata/mysql/BIDB.pid).[FAILED]
[root@BIDB scripts]# vi /etc/my.cnf

查看日志：

点击(此处)折叠或打开

  1. 140928 12:46:21 mysqld_safe mysqld from pid file /mydata/mysql/BIDB.pid ended
  2. 140928 12:48:43 mysqld_safe Starting mysqld daemon with databases from /mydata/mysql
  3. 2014-09-28 12:48:43 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  4. 2014-09-28 12:48:43 66983 [Note] Plugin \'FEDERATED\' is disabled.
  5. /my/mysql/bin/mysqld: Table \'mysql.plugin\' doesn\'t exist
  6. 2014-09-28 12:48:43 66983 [ERROR] Can\'t open the mysql.plugin table. Please run mysql_upgrade to create it.
  7. 2014-09-28 12:48:43 66983 [Note] InnoDB: Using atomics to ref count buffer pool pages
  8. 2014-09-28 12:48:43 66983 [Note] InnoDB: The InnoDB memory heap is disabled
  9. 2014-09-28 12:48:43 66983 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  10. 2014-09-28 12:48:43 66983 [Note] InnoDB: Compressed tables use zlib 1.2.3
  11. 2014-09-28 12:48:43 66983 [Note] InnoDB: Using CPU crc32 instructions
  12. 2014-09-28 12:48:43 66983 [Note] InnoDB: Initializing buffer pool, size = 100.0G
  13. 2014-09-28 12:48:49 66983 [Note] InnoDB: Completed initialization of buffer pool
  14. 2014-09-28 12:48:50 7ff1edc84720 InnoDB: Operating system error number 13 in a file operation.
  15. InnoDB: The error means mysqld does not have the access rights to
  16. InnoDB: the directory.
  17. 2014-09-28 12:48:50 7ff1edc84720 InnoDB: Operating system error number 13 in a file operation.
  18. InnoDB: The error means mysqld does not have the access rights to
  19. InnoDB: the directory.
  20. 2014-09-28 12:48:50 66983 [ERROR] InnoDB: Creating or opening ./ibdata1 failed!
  21. 2014-09-28 12:48:50 66983 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
  22. 2014-09-28 12:48:50 66983 [ERROR] Plugin \'InnoDB\' init function returned error.
  23. 2014-09-28 12:48:50 66983 [ERROR] Plugin \'InnoDB\' registration as a STORAGE ENGINE failed.
  24. 2014-09-28 12:48:50 66983 [ERROR] Unknown/unsupported storage engine: InnoDB
  25. 2014-09-28 12:48:50 66983 [ERROR] Aborting
  27. 2014-09-28 12:48:50 66983 [Note] Binlog end
  28. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'partition\'
  29. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_DATAFILES\'
  30. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_TABLESPACES\'
  31. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_FOREIGN_COLS\'
  32. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_FOREIGN\'
  33. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_FIELDS\'
  34. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_COLUMNS\'
  35. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_INDEXES\'
  36. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_TABLESTATS\'
  37. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_SYS_TABLES\'
  38. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_FT_INDEX_TABLE\'
  39. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_FT_INDEX_CACHE\'
  40. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_FT_CONFIG\'
  41. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_FT_BEING_DELETED\'
  42. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_FT_DELETED\'
  43. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_FT_DEFAULT_STOPWORD\'
  44. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_METRICS\'
  45. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_BUFFER_POOL_STATS\'
  46. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_BUFFER_PAGE_LRU\'
  47. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_BUFFER_PAGE\'
  48. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_CMP_PER_INDEX_RESET\'
  49. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_CMP_PER_INDEX\'
  50. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_CMPMEM_RESET\'
  51. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_CMPMEM\'
  52. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_CMP_RESET\'
  53. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_CMP\'
  54. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_LOCK_WAITS\'
  55. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_LOCKS\'
  56. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'INNODB_TRX\'
  57. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'PERFORMANCE_SCHEMA\'
  58. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'ARCHIVE\'
  59. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'BLACKHOLE\'
  60. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'MRG_MYISAM\'
  61. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'MEMORY\'
  62. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'CSV\'
  63. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'MyISAM\'
  64. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'sha256_password\'
  65. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'mysql_old_password\'
  66. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'mysql_native_password\'
  67. 2014-09-28 12:48:50 66983 [Note] Shutting down plugin \'binlog\'
  68. 2014-09-28 12:48:50 66983 [Note] /my/mysql/bin/mysqld: Shutdown complete
经常启动MySQL的时候遇见这个错误。也是最常见的错误之一
解决办法：
我也是尝试了好多次。
1、修改/etc/my.cnf   文件。要跟实际的一样
2、到MySQL的安装目录下面的script
./mysql_install_db --basedir=/my/mysql --no-defaults --skip-name-resolve --user=mysql --datadir=/mydata/mysql/data
这是重新初始化MySQL。
3. 切换到suppsupport-files 目录下启动MySQL
./mysql.server start.

经验总结：
1、上面的有可4能一次不行，多执行几次。
2、注意这两个参数确性：
basedir = /my/mysql                    ----MySQL安装路径 
datadir = /mydata/mysql/data       ----MySQL的数据文件存放位置
请使用浏览器的分享功能分享到微信等