Protas
New Member
- Jun 11, 2013
- 13
- 0
My xamp doesnt want to host it or my local host and this is what comes up:
Error: MySQL shutdown unexpectedly.
6:01:54 AM [mysql] This may be due to a blocked port, missing dependencies,
6:01:54 AM [mysql] improper privileges, a crash, or a shutdown by another method.
6:01:54 AM [mysql] Check the "/xampp/mysql/data/mysql_error.log" file
6:01:54 AM [mysql] and the Windows Event Viewer for more clues
and then this:
121228 20:21:38 [Note] Plugin 'FEDERATED' is disabled.
121228 20:21:38 InnoDB: The InnoDB memory heap is disabled
121228 20:21:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121228 20:21:38 InnoDB: Compressed tables use zlib 1.2.3
121228 20:21:38 InnoDB: Initializing buffer pool, size = 16.0M
121228 20:21:38 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
121228 20:21:38 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
121228 20:21:39 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
121228 20:21:41 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121228 20:21:43 InnoDB: Waiting for the background threads to start
121228 20:21:44 InnoDB: 1.1.8 started; log sequence number 0
121228 20:21:44 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121228 20:21:44 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121228 20:21:44 [Note] Server socket created on IP: '0.0.0.0'.
121228 20:21:47 [Note] Event Scheduler: Loaded 0 events
121228 20:21:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
121228 23:27:58 [Warning] IP address '125.132.136.163' could not be resolved: No such host is known.
121230 1:55:34 [Note] Plugin 'FEDERATED' is disabled.
121230 1:55:34 InnoDB: The InnoDB memory heap is disabled
121230 1:55:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121230 1:55:34 InnoDB: Compressed tables use zlib 1.2.3
121230 1:55:35 InnoDB: Initializing buffer pool, size = 16.0M
121230 1:55:35 InnoDB: Completed initialization of buffer pool
121230 1:55:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
121230 1:55:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
121230 1:55:38 InnoDB: Waiting for the background threads to start
121230 1:55:39 InnoDB: 1.1.8 started; log sequence number 1595675
121230 1:55:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121230 1:55:39 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121230 1:55:39 [Note] Server socket created on IP: '0.0.0.0'.
121230 1:55:40 [Note] Event Scheduler: Loaded 0 events
121230 1:55:40 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130621 18:13:34 [Note] Plugin 'FEDERATED' is disabled.
130621 18:13:35 InnoDB: The InnoDB memory heap is disabled
130621 18:13:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:13:35 InnoDB: Compressed tables use zlib 1.2.3
130621 18:13:35 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:13:35 InnoDB: Completed initialization of buffer pool
130621 18:13:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:13:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130621 18:13:36 InnoDB: Waiting for the background threads to start
130621 18:13:37 InnoDB: 1.1.8 started; log sequence number 1595675
130621 18:13:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130621 18:13:37 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130621 18:13:37 [Note] Server socket created on IP: '0.0.0.0'.
130621 18:13:38 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
130621 18:14:10 [Note] Plugin 'FEDERATED' is disabled.
130621 18:14:10 InnoDB: The InnoDB memory heap is disabled
130621 18:14:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:14:10 InnoDB: Compressed tables use zlib 1.2.3
130621 18:14:10 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:14:10 InnoDB: Completed initialization of buffer pool
130621 18:14:10 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:14:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130621 18:14:11 InnoDB: Waiting for the background threads to start
130621 18:14:12 InnoDB: 1.1.8 started; log sequence number 1595675
130621 18:14:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130621 18:14:12 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130621 18:14:12 [Note] Server socket created on IP: '0.0.0.0'.
130621 18:14:12 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
130621 18:14:12 [Note] Plugin 'FEDERATED' is disabled.
130621 18:14:12 InnoDB: The InnoDB memory heap is disabled
130621 18:14:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:14:12 InnoDB: Compressed tables use zlib 1.2.3
130621 18:14:12 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:14:12 InnoDB: Completed initialization of buffer pool
130621 18:14:13 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:14:13 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130621 18:14:13 InnoDB: Waiting for the background threads to start
130621 18:14:14 InnoDB: 1.1.8 started; log sequence number 1595675
130621 18:14:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130621 18:14:14 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130621 18:14:14 [Note] Server socket created on IP: '0.0.0.0'.
130621 18:14:14 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
130621 18:14:18 [Note] Plugin 'FEDERATED' is disabled.
130621 18:14:18 InnoDB: The InnoDB memory heap is disabled
130621 18:14:18 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:14:18 InnoDB: Compressed tables use zlib 1.2.3
130621 18:14:18 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:14:18 InnoDB: Completed initialization of buffer pool
130621 18:14:18 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:14:18 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer......
It waits or five seconds and then it just stops. Help please?
Error: MySQL shutdown unexpectedly.
6:01:54 AM [mysql] This may be due to a blocked port, missing dependencies,
6:01:54 AM [mysql] improper privileges, a crash, or a shutdown by another method.
6:01:54 AM [mysql] Check the "/xampp/mysql/data/mysql_error.log" file
6:01:54 AM [mysql] and the Windows Event Viewer for more clues
and then this:
121228 20:21:38 [Note] Plugin 'FEDERATED' is disabled.
121228 20:21:38 InnoDB: The InnoDB memory heap is disabled
121228 20:21:38 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121228 20:21:38 InnoDB: Compressed tables use zlib 1.2.3
121228 20:21:38 InnoDB: Initializing buffer pool, size = 16.0M
121228 20:21:38 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
121228 20:21:38 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
121228 20:21:39 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
121228 20:21:41 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121228 20:21:43 InnoDB: Waiting for the background threads to start
121228 20:21:44 InnoDB: 1.1.8 started; log sequence number 0
121228 20:21:44 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121228 20:21:44 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121228 20:21:44 [Note] Server socket created on IP: '0.0.0.0'.
121228 20:21:47 [Note] Event Scheduler: Loaded 0 events
121228 20:21:47 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
121228 23:27:58 [Warning] IP address '125.132.136.163' could not be resolved: No such host is known.
121230 1:55:34 [Note] Plugin 'FEDERATED' is disabled.
121230 1:55:34 InnoDB: The InnoDB memory heap is disabled
121230 1:55:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121230 1:55:34 InnoDB: Compressed tables use zlib 1.2.3
121230 1:55:35 InnoDB: Initializing buffer pool, size = 16.0M
121230 1:55:35 InnoDB: Completed initialization of buffer pool
121230 1:55:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
121230 1:55:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
121230 1:55:38 InnoDB: Waiting for the background threads to start
121230 1:55:39 InnoDB: 1.1.8 started; log sequence number 1595675
121230 1:55:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121230 1:55:39 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121230 1:55:39 [Note] Server socket created on IP: '0.0.0.0'.
121230 1:55:40 [Note] Event Scheduler: Loaded 0 events
121230 1:55:40 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130621 18:13:34 [Note] Plugin 'FEDERATED' is disabled.
130621 18:13:35 InnoDB: The InnoDB memory heap is disabled
130621 18:13:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:13:35 InnoDB: Compressed tables use zlib 1.2.3
130621 18:13:35 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:13:35 InnoDB: Completed initialization of buffer pool
130621 18:13:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:13:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130621 18:13:36 InnoDB: Waiting for the background threads to start
130621 18:13:37 InnoDB: 1.1.8 started; log sequence number 1595675
130621 18:13:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130621 18:13:37 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130621 18:13:37 [Note] Server socket created on IP: '0.0.0.0'.
130621 18:13:38 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
130621 18:14:10 [Note] Plugin 'FEDERATED' is disabled.
130621 18:14:10 InnoDB: The InnoDB memory heap is disabled
130621 18:14:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:14:10 InnoDB: Compressed tables use zlib 1.2.3
130621 18:14:10 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:14:10 InnoDB: Completed initialization of buffer pool
130621 18:14:10 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:14:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130621 18:14:11 InnoDB: Waiting for the background threads to start
130621 18:14:12 InnoDB: 1.1.8 started; log sequence number 1595675
130621 18:14:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130621 18:14:12 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130621 18:14:12 [Note] Server socket created on IP: '0.0.0.0'.
130621 18:14:12 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
130621 18:14:12 [Note] Plugin 'FEDERATED' is disabled.
130621 18:14:12 InnoDB: The InnoDB memory heap is disabled
130621 18:14:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:14:12 InnoDB: Compressed tables use zlib 1.2.3
130621 18:14:12 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:14:12 InnoDB: Completed initialization of buffer pool
130621 18:14:13 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:14:13 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130621 18:14:13 InnoDB: Waiting for the background threads to start
130621 18:14:14 InnoDB: 1.1.8 started; log sequence number 1595675
130621 18:14:14 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130621 18:14:14 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130621 18:14:14 [Note] Server socket created on IP: '0.0.0.0'.
130621 18:14:14 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
130621 18:14:18 [Note] Plugin 'FEDERATED' is disabled.
130621 18:14:18 InnoDB: The InnoDB memory heap is disabled
130621 18:14:18 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130621 18:14:18 InnoDB: Compressed tables use zlib 1.2.3
130621 18:14:18 InnoDB: Initializing buffer pool, size = 16.0M
130621 18:14:18 InnoDB: Completed initialization of buffer pool
130621 18:14:18 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130621 18:14:18 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer......
It waits or five seconds and then it just stops. Help please?
