ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > MySQL > 因login-path导致MySQL 启动[ERROR]unknown variable 'password=*****'

因login-path导致MySQL 启动[ERROR]unknown variable 'password=*****'

原创 MySQL 作者：哎呀我的天呐 时间：2015-11-25 15:09:34 0 删除 编辑
mysqld_multi start 3
报错如下：

点击(此处)折叠或打开

  1. 2015-11-25 14:48:05 15025 [Note] InnoDB: 128 rollback segment(s) are active.
  2. 2015-11-25 14:48:05 15025 [Note] InnoDB: Waiting for purge to start
  3. 2015-11-25 14:48:05 15025 [Note] InnoDB: 5.6.27 started; log sequence number 880209
  4. 2015-11-25 14:48:05 7f4bd7fff700 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
  5. 2015-11-25 14:48:05 15025 [Note] Semi-sync replication initialized for transactions.
  6. 2015-11-25 14:48:05 15025 [Note] Semi-sync replication enabled on the master.
  7. 2015-11-25 14:48:05 15025 [ERROR] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: unknown variable 'password=*****'
  8. 2015-11-25 14:48:05 15025 [ERROR] Aborting

  10. 2015-11-25 14:48:05 15025 [Note] Binlog end
  11. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'rpl_semi_sync_slave'
  12. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'rpl_semi_sync_master'
  13. 2015-11-25 14:48:05 15025 [Note] unregister_replicator OK
  14. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'partition'
  15. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'ARCHIVE'
  16. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'BLACKHOLE'
  17. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  18. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  19. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  20. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  21. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  22. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  23. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  24. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  25. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  26. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  27. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  28. 2015-11-25 14:48:05 7f4bd7fff7002015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  29.  InnoDB: Buffer pool(s) load completed at 151125 14:48:05
  30. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  31. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  32. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  33. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  34. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_METRICS'
  35. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  36. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  37. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  38. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  39. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  40. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  41. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMPMEM'
  42. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  43. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP'
  44. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  45. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_LOCKS'
  46. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_TRX'
  47. 2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'InnoDB'
  48. 2015-11-25 14:48:05 15025 [Note] InnoDB: FTS optimize thread exiting.
  49. 2015-11-25 14:48:05 15025 [Note] InnoDB: Starting shutdown...
  50. 2015-11-25 14:48:05 7f4bd7fff700 InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
  51. 2015-11-25 14:48:05 7f4bd7fff700 InnoDB: Buffer pool(s) dump completed at 151125 14:48:05
  52. 2015-11-25 14:48:07 15025 [Note] InnoDB: Shutdown completed; log sequence number 880219
  53. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'CSV'
  54. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'MEMORY'
  55. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'MyISAM'
  56. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'MRG_MYISAM'
  57. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'sha256_password'
  58. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'mysql_old_password'
  59. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'mysql_native_password'
  60. 2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'binlog'
  61. 2015-11-25 14:48:07 15025 [Note] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: Shutdown complete

  63. 151125 14:48:07 mysqld_safe mysqld from pid file /data3/mysqlA.pid ended
  64. 151125 14:51:18 mysqld_safe Starting mysqld daemon with databases from /data3
  65. 2015-11-25 14:51:18 0 [Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line

  67. 2015-11-25 14:51:18 0 [Note] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld (mysqld 5.6.27-log) starting as process 16304 ...
  68. 2015-11-25 14:51:18 16304 [Warning] Although a path was specified for the --slow-query-log-file option, log tables are used. To enable logging to files use the --log-output=file option.
  69. 2015-11-25 14:51:18 16304 [Note] Plugin 'FEDERATED' is disabled.
  70. 2015-11-25 14:51:18 7fdfbda3e720 InnoDB: innodb-page-size has been changed from the default value 16384 to 8192.
  71. 2015-11-25 14:51:18 16304 [Note] InnoDB: Using atomics to ref count buffer pool pages
  72. 2015-11-25 14:51:18 16304 [Note] InnoDB: The InnoDB memory heap is disabled
  73. 2015-11-25 14:51:18 16304 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  74. 2015-11-25 14:51:18 16304 [Note] InnoDB: Memory barrier is not used
  75. 2015-11-25 14:51:18 16304 [Note] InnoDB: Compressed tables use zlib 1.2.3
  76. 2015-11-25 14:51:18 16304 [Note] InnoDB: Using Linux native AIO
  77. 2015-11-25 14:51:18 16304 [Note] InnoDB: Using CPU crc32 instructions
  78. 2015-11-25 14:51:18 16304 [Note] InnoDB: Initializing buffer pool, size = 32.0M
  79. 2015-11-25 14:51:18 16304 [Note] InnoDB: Completed initialization of buffer pool
  80. 2015-11-25 14:51:18 16304 [Note] InnoDB: Opened 3 undo tablespaces
  81. 2015-11-25 14:51:18 16304 [Note] InnoDB: Highest supported file format is Barracuda.
  82. 2015-11-25 14:51:18 16304 [Note] InnoDB: 128 rollback segment(s) are active.
  83. 2015-11-25 14:51:18 16304 [Note] InnoDB: 5.6.27 started; log sequence number 880219
  84. 2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
  85. 2015-11-25 14:51:18 16304 [Note] Semi-sync replication initialized for transactions.
  86. 2015-11-25 14:51:18 16304 [Note] Semi-sync replication enabled on the master.
  87. 2015-11-25 14:51:18 16304 [ERROR] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: unknown variable 'password=*****'
  88. 2015-11-25 14:51:18 16304 [ERROR] Aborting

  90. 2015-11-25 14:51:18 16304 [Note] Binlog end
  91. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'rpl_semi_sync_slave'
  92. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'rpl_semi_sync_master'
  93. 2015-11-25 14:51:18 16304 [Note] unregister_replicator OK
  94. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'partition'
  95. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'ARCHIVE'
  96. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'BLACKHOLE'
  97. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  98. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  99. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  100. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  101. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  102. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  103. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  104. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  105. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  106. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  107. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  108. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  109. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  110. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  111. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  112. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  113. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_METRICS'
  114. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  115. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  116. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  117. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  118. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  119. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  120. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMPMEM'
  121. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  122. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP'
  123. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  124. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_LOCKS'
  125. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_TRX'
  126. 2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'InnoDB'
  127. 2015-11-25 14:51:18 16304 [Note] InnoDB: FTS optimize thread exiting.
  128. 2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Buffer pool(s) load completed at 151125 14:51:18
  129. 2015-11-25 14:51:18 16304 [Note] InnoDB: Starting shutdown...
  130. 2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
  131. 2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Buffer pool(s) dump completed at 151125 14:51:18
  132. 2015-11-25 14:51:20 16304 [Note] InnoDB: Shutdown completed; log sequence number 880229
  133. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'CSV'
  134. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'MEMORY'
  135. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'MyISAM'
  136. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'MRG_MYISAM'
  137. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'sha256_password'
  138. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'mysql_old_password'
  139. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'mysql_native_password'
  140. 2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'binlog'
  141. 2015-11-25 14:51:20 16304 [Note] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: Shutdown complete

  143. 151125 14:51:20 mysqld_safe mysqld from pid file /data3/mysqlA.pid ended
[root@mysqlA scripts]# mysql_config_editor set -G mysqld1 -u root -p -S /tmp/mysql.sock1 [root@mysqlA scripts]# mysql_config_editor set -G mysqld2 -u root -p -S /tmp/mysql.sock2 [root@mysqlA scripts]# mysql_config_editor set -G mysqld3 -u root -p -S /tmp/mysql.sock3 [root@mysqlA scripts]# mysql_config_editor set -G mysqld4 -u root -p -S /tmp/mysql.sock4
mysql_config_editor reset 问题得以解决.... ....

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29990276/viewspace-1846451/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： MySQL slow log + pt_query_digest
下一篇： MySQL5.6 5.7用户临时表 对比
请登录后发表评论 登录
全部评论
哎呀我的天呐
专家姓名：姚崇
https://cloud.tencent.com/developer/inventory/14362

注册时间：2014-10-30

  • 博文量
    403
  • 访问量
    2528743

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593