mysql 改配置文件重启挂了pid丢失错误(其实是在pid之前的另一个错误)

我的操作 更改 vim /etc/my.cnf
的时间日志保存时间参数 然后 重启mysqld
之后出现上图保存,那么第一反映就是查错误 然后照着网上的进行一轮又一轮的操作
最后依然回到这个错误 没有丝丝改变
重建pid文件手工给他pid 给权限和用户组 都无用
唯有静下心来 清空错误日志  启动一次后 仔细的看看日志错误位置
并且得出了结果
  1. root@remenbo1:/data/alisql# cat mysql-error.log
  2. 161227 16:32:19 mysqld_safe Starting mysqld daemon with databases from /data/alisql
  3. 2016-12-27 16:32:19 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
  4. 2016-12-27 16:32:19 0 [Note] /usr/local/alisql/bin/mysqld (mysqld 5.6.32-log) starting as process 9210 ...
  5. 2016-12-27 16:32:19 9210 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
  6. 2016-12-27 16:32:19 9210 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
  7. 2016-12-27 16:32:19 9210 [Note] Plugin 'FEDERATED' is disabled.
  8. 2016-12-27 16:32:19 9210 [Note] InnoDB: Using atomics to ref count buffer pool pages
  9. 2016-12-27 16:32:19 9210 [Note] InnoDB: The InnoDB memory heap is disabled
  10. 2016-12-27 16:32:19 9210 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  11. 2016-12-27 16:32:19 9210 [Note] InnoDB: Memory barrier is not used
  12. 2016-12-27 16:32:19 9210 [Note] InnoDB: Compressed tables use zlib 1.2.3
  13. 2016-12-27 16:32:19 9210 [Note] InnoDB: Using Linux native AIO
  14. 2016-12-27 16:32:19 9210 [Note] InnoDB: Not using CPU crc32 instructions
  15. 2016-12-27 16:32:19 9210 [Note] InnoDB: Initializing buffer pool, size = 64.0M
  16. 2016-12-27 16:32:19 9210 [Note] InnoDB: Completed initialization of buffer pool
  17. 2016-12-27 16:32:19 9210 [Note] InnoDB: Highest supported file format is Barracuda.
  18. 2016-12-27 16:32:19 9210 [Note] InnoDB: 128 rollback segment(s) are active.
  19. 2016-12-27 16:32:19 9210 [Note] InnoDB: Waiting for purge to start
  20. 2016-12-27 16:32:19 9210 [Note] InnoDB: 5.6.32 started; log sequence number 72312064
  21. 2016-12-27 16:32:19 9210 [ERROR] Aborting
  22. 2016-12-27 16:32:19 9210 [Note] Binlog end
  23. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'partition'
  24. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  25. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  26. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  27. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  28. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  29. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  30. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  31. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  32. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  33. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  34. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  35. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  36. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  37. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  38. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  39. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_METRICS'
  40. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  41. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  42. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  43. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  44. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  45. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  46. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_CMPMEM'
  47. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  48. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_CMP'
  49. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  50. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_LOCKS'
  51. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_TRX'
  52. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'INNODB_RSEG'
  53. 2016-12-27 16:32:19 9210 [Note] Shutting down plugin 'InnoDB'
  54. 2016-12-27 16:32:19 9210 [Note] InnoDB: FTS optimize thread exiting.
  55. 2016-12-27 16:32:19 9210 [Note] InnoDB: Starting shutdown...
  56. 2016-12-27 16:32:21 9210 [Note] InnoDB: Shutdown completed; log sequence number 72312074
  57. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'BLACKHOLE'
  58. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  59. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'ARCHIVE'
  60. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'CSV'
  61. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'MRG_MYISAM'
  62. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'MEMORY'
  63. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'MyISAM'
  64. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'sha256_password'
  65. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'mysql_old_password'
  66. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'mysql_native_password'
  67. 2016-12-27 16:32:21 9210 [Note] Shutting down plugin 'binlog'
  68. 2016-12-27 16:32:21 9210 [Note]
  69. 161227 16:32:21 mysqld_safe mysqld from pid file /data/alisql/mysql.pid ended
那么结果是 Can't find messagefile '/usr/share/mysql/errmsg.sys
这是真正需要解决的问题
为什么无论删除 mysql-bin.index 还是 ib_logfile* 还是重建pid都无效是因为
在这之前这个错误没有解决 无法读取语言
这可能是环境中忘了配置这项导致  
手工指定安装位置为我的位置
编辑配置文件 vim /etc/my.cnf
language = /usr/local/alisql/share/english
重启 果然问题解决 没有错误
及一系列得到过参考的文章
~~~~~~~~~~~今天连接数据库发现不能连接~~~~~~~~~~~
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
修复后 修改的配置文件为
socket = /var/run/mysqld/mysqld.sock
#socket = /tmp/mysql.sock

非凡网 博客

我只是帮你筛选价值。

你也许喜欢

发表评论