MYSQL Wont even start please help

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MYSQL Wont even start please help

Postby DwMProHosting » 18. February 2015 01:38

Whenever i try to start my mysql database it doest start it brings up the fallowing:
12:33:42 AM [mysql] Error: MySQL shutdown unexpectedly.
12:33:42 AM [mysql] This may be due to a blocked port, missing dependencies,
12:33:42 AM [mysql] improper privileges, a crash, or a shutdown by another method.
12:33:42 AM [mysql] Press the Logs button to view error logs and check
12:33:42 AM [mysql] the Windows Event Viewer for more clues
12:33:42 AM [mysql] If you need more help, copy and post this
12:33:42 AM [mysql] entire log window on the forums
Then so i got to the error log thing and i get this:
2015-02-18 00:30:41 400 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 00:30:41 668 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-02-18 00:30:41 400 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 00:30:41 400 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 00:30:41 400 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 00:30:41 400 [Note] InnoDB: Memory barrier is not used
2015-02-18 00:30:41 400 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 00:30:41 400 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 00:30:41 400 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 00:30:41 400 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 00:30:41 400 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 00:30:41 400 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 00:30:41 400 [Note] InnoDB: Waiting for purge to start
2015-02-18 00:30:41 400 [Note] InnoDB: 5.6.21 started; log sequence number 1665234
2015-02-18 00:30:41 400 [ERROR] C:\xampp\mysql\bin\mysqld: unknown variable 'master-host=dwmprohosting'
2015-02-18 00:30:41 400 [ERROR] Aborting

2015-02-18 00:30:41 400 [Note] Binlog end
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'partition'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-18 00:30:41 400 [Note] Shutting down plugin 'InnoDB'
2015-02-18 00:30:41 400 [Note] InnoDB: FTS optimize thread exiting.
2015-02-18 00:30:41 400 [Note] InnoDB: Starting shutdown...
2015-02-18 00:30:43 400 [Note] InnoDB: Shutdown completed; log sequence number 1665244
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'ARCHIVE'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'MyISAM'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'MEMORY'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'CSV'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'sha256_password'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'mysql_old_password'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'mysql_native_password'
2015-02-18 00:30:43 400 [Note] Shutting down plugin 'binlog'
2015-02-18 00:30:43 400 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

2015-02-18 00:32:06 3200 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 00:32:06 3b8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-02-18 00:32:06 3200 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-18 00:32:06 3200 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-18 00:32:06 3200 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-02-18 00:32:06 3200 [Note] InnoDB: Memory barrier is not used
2015-02-18 00:32:06 3200 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-18 00:32:06 3200 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-18 00:32:06 3200 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-02-18 00:32:06 3200 [Note] InnoDB: Completed initialization of buffer pool
2015-02-18 00:32:06 3200 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-18 00:32:06 3200 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-18 00:32:06 3200 [Note] InnoDB: Waiting for purge to start
2015-02-18 00:32:06 3200 [Note] InnoDB: 5.6.21 started; log sequence number 1665244
2015-02-18 00:32:06 3200 [ERROR] C:\xampp\mysql\bin\mysqld: unknown variable 'master-host=dwmprohosting'
2015-02-18 00:32:06 3200 [ERROR] Aborting

2015-02-18 00:32:06 3200 [Note] Binlog end
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'partition'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-18 00:32:06 3200 [Note] Shutting down plugin 'InnoDB'
2015-02-18 00:32:06 3200 [Note] InnoDB: FTS optimize thread exiting.
2015-02-18 00:32:06 3200 [Note] InnoDB: Starting shutdown...
2015-02-18 00:32:08 3200 [Note] InnoDB: Shutdown completed; log sequence number 1665254
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'ARCHIVE'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'MyISAM'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'MEMORY'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'CSV'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'sha256_password'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'mysql_old_password'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'mysql_native_password'
2015-02-18 00:32:08 3200 [Note] Shutting down plugin 'binlog'
2015-02-18 00:32:08 3200 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete

2015-02-18 00:33:37 3216 [Note] Plugin 'FEDERATED' is disabled.
2015-02-18 00:33:37 3216 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2015-02-18 00:33:37 3216 [Note] Plugin 'InnoDB' is disabled.
2015-02-18 00:33:37 3216 [ERROR] C:\xampp\mysql\bin\mysqld: unknown variable 'master-host=dwmprohosting'
2015-02-18 00:33:37 3216 [ERROR] Aborting

2015-02-18 00:33:37 3216 [Note] Binlog end
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'partition'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_METRICS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_CMP'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'INNODB_TRX'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'BLACKHOLE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'ARCHIVE'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'MRG_MYISAM'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'MyISAM'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'MEMORY'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'CSV'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'sha256_password'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'mysql_old_password'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'mysql_native_password'
2015-02-18 00:33:37 3216 [Note] Shutting down plugin 'binlog'
2015-02-18 00:33:37 3216 [Note] C:\xampp\mysql\bin\mysqld: Shutdown complete


I need a lot of help my business depends on this.
DwMProHosting
 
Posts: 1
Joined: 18. February 2015 01:35
Operating System: Windows

Re: MYSQL Wont even start please help

Postby Altrea » 18. February 2015 06:30

DwMProHosting wrote:2015-02-18 00:33:37 3216 [ERROR] C:\xampp\mysql\bin\mysqld: unknown variable 'master-host=dwmprohosting'
2015-02-18 00:33:37 3216 [ERROR] Aborting

YOU should know where this setting come from
http://dev.mysql.com/doc/refman/5.6/en/ ... slave.html

DwMProHosting wrote:I need a lot of help my business depends on this.

If your business depends on XAMPP and you have no expert being able to configure it's components properly (and you are not even able to find the answer on google where the keywords unknown variable master-host give 160.000 hits) then something went badly wrong.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 3 guests