因login-path導致MySQL 啟動[ERROR]unknown variable 'password=*****'

哎呀我的天吶發表於2015-11-25

mysqld_multi start 3
報錯如下：

點選(此處)摺疊或開啟

2015-11-25 14:48:05 15025 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-25 14:48:05 15025 [Note] InnoDB: Waiting for purge to start
2015-11-25 14:48:05 15025 [Note] InnoDB: 5.6.27 started; log sequence number 880209
2015-11-25 14:48:05 7f4bd7fff700 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
2015-11-25 14:48:05 15025 [Note] Semi-sync replication initialized for transactions.
2015-11-25 14:48:05 15025 [Note] Semi-sync replication enabled on the master.
2015-11-25 14:48:05 15025 [ERROR] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: unknown variable 'password=*****'
2015-11-25 14:48:05 15025 [ERROR] Aborting
2015-11-25 14:48:05 15025 [Note] Binlog end
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'rpl_semi_sync_slave'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'rpl_semi_sync_master'
2015-11-25 14:48:05 15025 [Note] unregister_replicator OK
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'partition'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'ARCHIVE'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'BLACKHOLE'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-25 14:48:05 7f4bd7fff7002015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
InnoDB: Buffer pool(s) load completed at 151125 14:48:05
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_METRICS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_CMP'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'INNODB_TRX'
2015-11-25 14:48:05 15025 [Note] Shutting down plugin 'InnoDB'
2015-11-25 14:48:05 15025 [Note] InnoDB: FTS optimize thread exiting.
2015-11-25 14:48:05 15025 [Note] InnoDB: Starting shutdown...
2015-11-25 14:48:05 7f4bd7fff700 InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
2015-11-25 14:48:05 7f4bd7fff700 InnoDB: Buffer pool(s) dump completed at 151125 14:48:05
2015-11-25 14:48:07 15025 [Note] InnoDB: Shutdown completed; log sequence number 880219
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'CSV'
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'MEMORY'
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'MyISAM'
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'MRG_MYISAM'
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'sha256_password'
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'mysql_old_password'
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'mysql_native_password'
2015-11-25 14:48:07 15025 [Note] Shutting down plugin 'binlog'
2015-11-25 14:48:07 15025 [Note] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: Shutdown complete
151125 14:48:07 mysqld_safe mysqld from pid file /data3/mysqlA.pid ended
151125 14:51:18 mysqld_safe Starting mysqld daemon with databases from /data3
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
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 ...
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.
2015-11-25 14:51:18 16304 [Note] Plugin 'FEDERATED' is disabled.
2015-11-25 14:51:18 7fdfbda3e720 InnoDB: innodb-page-size has been changed from the default value 16384 to 8192.
2015-11-25 14:51:18 16304 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-25 14:51:18 16304 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-25 14:51:18 16304 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-25 14:51:18 16304 [Note] InnoDB: Memory barrier is not used
2015-11-25 14:51:18 16304 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-25 14:51:18 16304 [Note] InnoDB: Using Linux native AIO
2015-11-25 14:51:18 16304 [Note] InnoDB: Using CPU crc32 instructions
2015-11-25 14:51:18 16304 [Note] InnoDB: Initializing buffer pool, size = 32.0M
2015-11-25 14:51:18 16304 [Note] InnoDB: Completed initialization of buffer pool
2015-11-25 14:51:18 16304 [Note] InnoDB: Opened 3 undo tablespaces
2015-11-25 14:51:18 16304 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-25 14:51:18 16304 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-25 14:51:18 16304 [Note] InnoDB: 5.6.27 started; log sequence number 880219
2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Loading buffer pool(s) from .//ib_buffer_pool
2015-11-25 14:51:18 16304 [Note] Semi-sync replication initialized for transactions.
2015-11-25 14:51:18 16304 [Note] Semi-sync replication enabled on the master.
2015-11-25 14:51:18 16304 [ERROR] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: unknown variable 'password=*****'
2015-11-25 14:51:18 16304 [ERROR] Aborting
2015-11-25 14:51:18 16304 [Note] Binlog end
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'rpl_semi_sync_slave'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'rpl_semi_sync_master'
2015-11-25 14:51:18 16304 [Note] unregister_replicator OK
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'partition'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'ARCHIVE'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'BLACKHOLE'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_METRICS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_CMP'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'INNODB_TRX'
2015-11-25 14:51:18 16304 [Note] Shutting down plugin 'InnoDB'
2015-11-25 14:51:18 16304 [Note] InnoDB: FTS optimize thread exiting.
2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Buffer pool(s) load completed at 151125 14:51:18
2015-11-25 14:51:18 16304 [Note] InnoDB: Starting shutdown...
2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Dumping buffer pool(s) to .//ib_buffer_pool
2015-11-25 14:51:18 7fdfa8dfa700 InnoDB: Buffer pool(s) dump completed at 151125 14:51:18
2015-11-25 14:51:20 16304 [Note] InnoDB: Shutdown completed; log sequence number 880229
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'CSV'
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'MEMORY'
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'MyISAM'
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'MRG_MYISAM'
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'sha256_password'
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'mysql_old_password'
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'mysql_native_password'
2015-11-25 14:51:20 16304 [Note] Shutting down plugin 'binlog'
2015-11-25 14:51:20 16304 [Note] /usr/local/mysql-5.6.27-linux-glibc2.5-x86_64/bin/mysqld: Shutdown complete
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部落格 ” ，連結：http://blog.itpub.net/29990276/viewspace-1846451/，如需轉載，請註明出處，否則將追究法律責任。

MySQL 5.6因為OOM導致資料庫重啟
2018-11-13
MySqlOOM資料庫
Oracle RAC啟動因CTSS導致的異常
2020-05-25
Oracle
mysql登陸報錯mysql: unknown variable 'basedir=
2017-07-27
MySql
ERROR 1193: Unknown system variable 'log_slow_queries'
2008-05-14
Error
mysql Unknown error 1054
2018-03-26
MySqlError
innodb_undo_tablespaces導致Mysql啟動報錯
2024-03-23
MySql
JDBC/MYSQL問題 : Unknown system variable 'query_cache_size'
2020-04-07
JDBCMySql
神奇的DEBUG：因為異常導致MongoDB容器無法啟動
2022-12-30
MongoDB
mongoDB因root啟動關閉資料庫導致mongo普通使用者無法啟動
2016-06-28
MongoDB資料庫
sock鎖檔案導致的MySQL啟動失敗
2022-02-24
MySql
解決因ocr資源狀態為unknown導致CRS-0223
2012-05-04
SQL Server 因設定最大記憶體過小導致無法啟動
2024-03-13
SQLServer記憶體
解決一次gitlab因異常關機導致啟動失敗
2021-11-11
Gitlab
10G rac 因為ocr原因導致crs不能啟動的排查二例
2015-11-20
MySQL5.7更改密碼時出現ERROR 1054 (42S22): Unknown column 'password' in 'field list'
2017-09-24
MySql密碼Error
【Mysql】vm.overcommit_memory導致的mysql啟動記憶體報錯
2017-02-28
MySqlMIT記憶體
一次因為修改環境變數導致RESIN不能啟動的問題
2007-09-30
變數
MySQL5.7忘記密碼時出現ERROR 1054 (42S22): Unknown column 'password' in 'field list'
2017-11-09
MySql密碼Error
terminating the instance due to error481導致ASM無法啟動故障
2017-10-27
ErrorASM
因為修改windows管理員密碼導致sql server 2005不能啟動處理
2019-04-03
Windows密碼SQLServer
【故障恢復】因spfile修改錯誤導致資料庫無法啟動的恢復方法
2009-03-12
資料庫
一次意外斷電導致mysql檔案損壞，啟動異常
2022-02-18
MySql
ERROR | [iOS] unknown: Encountered an unknown error (Could not find a `ios` simulator (valid values:
2019-04-23
ErroriOS
【問題處理】因誤修改inittab檔案導致Oracle 10gR2 CRS無法啟動
2011-01-05
Oracle 10g
【MySQL】5.6/5.7並行複製bug導致的故障 ERROR 1755/1756
2017-07-13
MySql並行Error
Latch導致MySQL Crash
2016-05-18
MySql
【ASK_ORACLE】因process用盡導致的rac重啟的解決方法
2023-01-17
Oracle
MySQL 因資料型別轉換導致執行計劃使用低效索引
2018-07-27
MySql資料型別索引
MYSQL解決error: 'Access denied for user 'root'@'localhost' (using password:
2014-07-01
MySqlErrorlocalhost
【MySQL】AppArmor導致datadir遷移無法啟動&初始化失敗
2016-09-02
MySqlAPP
MySQL：ERROR 1286 (42000): Unknown storage engine 'MyISAM'
2020-06-21
MySqlError
ndo2db: mysql_error: ‘Unknown column ‘importance’ in ‘field list”
2015-06-04
MySqlErrorImport
mysql 動態引數(Dynamic System Variable Summary)
2019-06-13
MySql
mysql error 2005 - Unknown MySQL server host 'localhost'(11001）
2013-12-10
MySqlErrorServerlocalhost
記錄一次因 mysql 欄位取名不規範導致的問題
2021-07-31
MySql
MySQL login-path 本地快捷登陸
2019-07-12
MySql
unknown variable 'defaults-file=/home/mysql/my3310.cnf'--percona server 5.7
2016-11-21
MySqlServer
MYSQL5.5修改字符集報錯：unknown variable 'default-character-set=utf8'
2011-05-12
MySql

因login-path導致MySQL 啟動[ERROR]unknown variable 'password=*****'

相關文章