First try to connect to mysql with xampp

Problems with the Windows version of XAMPP, questions, comments, and anything related.

First try to connect to mysql with xampp

Postby chris93 » 05. March 2014 23:07

hi guys ,

I am having trouble connecting to mysql with xampp. when i connect , i get this for the log file. I checked my windows defender, and i added an inbound and outbound rule for port 3306 which is mysql but , it still gives this error.

I have also uncommented the line in the xampp\mysql\bin\my.ini file
CODE: SELECT ALL
#bind-address="127.0.0.1"


140306 4:39:28 [Note] Plugin 'FEDERATED' is disabled.
140306 4:39:28 InnoDB: The InnoDB memory heap is disabled
140306 4:39:28 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 4:39:28 InnoDB: Compressed tables use zlib 1.2.3
140306 4:39:28 InnoDB: Initializing buffer pool, size = 16.0M
140306 4:39:28 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!
140306 4:39:28 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
140306 4:39:29 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...
140306 4:39:30 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
140306 4:39:33 InnoDB: Waiting for the background threads to start
140306 4:39:34 InnoDB: 5.5.36 started; log sequence number 0
140306 4:39:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140306 4:39:34 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140306 4:39:34 [Note] Server socket created on IP: '0.0.0.0'.
140306 4:39:34 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
140306 4:39:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
140306 4:39:34 [ERROR] Aborting

140306 4:39:34 InnoDB: Starting shutdown...
140306 4:39:36 InnoDB: Shutdown completed; log sequence number 1595675
140306 4:39:36 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140306 4:56:33 [Note] Plugin 'FEDERATED' is disabled.
140306 4:56:33 InnoDB: The InnoDB memory heap is disabled
140306 4:56:33 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 4:56:33 InnoDB: Compressed tables use zlib 1.2.3
140306 4:56:33 InnoDB: Initializing buffer pool, size = 16.0M
140306 4:56:33 InnoDB: Completed initialization of buffer pool
140306 4:56:33 InnoDB: highest supported file format is Barracuda.
140306 4:56:34 InnoDB: Waiting for the background threads to start
140306 4:56:35 InnoDB: 5.5.36 started; log sequence number 1595675
140306 4:56:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140306 4:56:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140306 4:56:35 [Note] Server socket created on IP: '0.0.0.0'.
140306 4:56:35 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
140306 4:56:35 [ERROR] Do you already have another mysqld server running on port: 3306 ?
140306 4:56:35 [ERROR] Aborting

140306 4:56:35 InnoDB: Starting shutdown...
140306 4:56:35 InnoDB: Shutdown completed; log sequence number 1595675
140306 4:56:35 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140306 4:56:47 [Note] Plugin 'FEDERATED' is disabled.
140306 4:56:47 InnoDB: The InnoDB memory heap is disabled
140306 4:56:47 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 4:56:47 InnoDB: Compressed tables use zlib 1.2.3
140306 4:56:47 InnoDB: Initializing buffer pool, size = 16.0M
140306 4:56:47 InnoDB: Completed initialization of buffer pool
140306 4:56:47 InnoDB: highest supported file format is Barracuda.
140306 4:56:48 InnoDB: Waiting for the background threads to start
140306 4:56:49 InnoDB: 5.5.36 started; log sequence number 1595675
140306 4:56:49 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140306 4:56:49 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140306 4:56:49 [Note] Server socket created on IP: '0.0.0.0'.
140306 4:56:49 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
140306 4:56:49 [ERROR] Do you already have another mysqld server running on port: 3306 ?
140306 4:56:49 [ERROR] Aborting

140306 4:56:49 InnoDB: Starting shutdown...
140306 4:56:50 InnoDB: Shutdown completed; log sequence number 1595675
140306 4:56:50 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140306 5:00:20 [Note] Plugin 'FEDERATED' is disabled.
140306 5:00:20 InnoDB: The InnoDB memory heap is disabled
140306 5:00:20 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 5:00:20 InnoDB: Compressed tables use zlib 1.2.3
140306 5:00:20 InnoDB: Initializing buffer pool, size = 16.0M
140306 5:00:20 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!
140306 5:00:20 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
140306 5:00:22 InnoDB: Error: all log files must be created at the same time.
140306 5:00:22 InnoDB: All log files must be created also in database creation.
140306 5:00:22 InnoDB: If you want bigger or smaller log files, shut down the
140306 5:00:22 InnoDB: database and make sure there were no errors in shutdown.
140306 5:00:22 InnoDB: Then delete the existing log files. Edit the .cnf file
140306 5:00:22 InnoDB: and start the database again.
140306 5:00:22 [ERROR] Plugin 'InnoDB' init function returned error.
140306 5:00:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140306 5:00:22 [ERROR] Unknown/unsupported storage engine: InnoDB
140306 5:00:22 [ERROR] Aborting

140306 5:00:22 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140306 5:03:55 [Note] Plugin 'FEDERATED' is disabled.
140306 5:03:55 InnoDB: The InnoDB memory heap is disabled
140306 5:03:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 5:03:55 InnoDB: Compressed tables use zlib 1.2.3
140306 5:03:55 InnoDB: Initializing buffer pool, size = 16.0M
140306 5:03:55 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140306 5:03:55 InnoDB: Could not open or create data files.
140306 5:03:55 InnoDB: If you tried to add new data files, and it failed here,
140306 5:03:55 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140306 5:03:55 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140306 5:03:55 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140306 5:03:55 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140306 5:03:55 InnoDB: remove old data files which contain your precious data!
140306 5:03:55 [ERROR] Plugin 'InnoDB' init function returned error.
140306 5:03:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140306 5:03:55 [ERROR] Unknown/unsupported storage engine: InnoDB
140306 5:03:55 [ERROR] Aborting

140306 5:03:55 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140306 5:04:01 [Note] Plugin 'FEDERATED' is disabled.
140306 5:04:01 InnoDB: The InnoDB memory heap is disabled
140306 5:04:01 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 5:04:01 InnoDB: Compressed tables use zlib 1.2.3
140306 5:04:01 InnoDB: Initializing buffer pool, size = 16.0M
140306 5:04:01 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140306 5:04:01 InnoDB: Could not open or create data files.
140306 5:04:01 InnoDB: If you tried to add new data files, and it failed here,
140306 5:04:01 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140306 5:04:01 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140306 5:04:01 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140306 5:04:01 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140306 5:04:01 InnoDB: remove old data files which contain your precious data!
140306 5:04:01 [ERROR] Plugin 'InnoDB' init function returned error.
140306 5:04:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140306 5:04:01 [ERROR] Unknown/unsupported storage engine: InnoDB
140306 5:04:01 [ERROR] Aborting

140306 5:04:01 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140306 5:04:03 [Note] Plugin 'FEDERATED' is disabled.
140306 5:04:03 InnoDB: The InnoDB memory heap is disabled
140306 5:04:03 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 5:04:03 InnoDB: Compressed tables use zlib 1.2.3
140306 5:04:03 InnoDB: Initializing buffer pool, size = 16.0M
140306 5:04:03 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140306 5:04:03 InnoDB: Could not open or create data files.
140306 5:04:03 InnoDB: If you tried to add new data files, and it failed here,
140306 5:04:03 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140306 5:04:03 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140306 5:04:03 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140306 5:04:03 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140306 5:04:03 InnoDB: remove old data files which contain your precious data!
140306 5:04:03 [ERROR] Plugin 'InnoDB' init function returned error.
140306 5:04:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140306 5:04:03 [ERROR] Unknown/unsupported storage engine: InnoDB
140306 5:04:03 [ERROR] Aborting

140306 5:04:03 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140306 5:04:07 [Note] Plugin 'FEDERATED' is disabled.
140306 5:04:07 InnoDB: The InnoDB memory heap is disabled
140306 5:04:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140306 5:04:07 InnoDB: Compressed tables use zlib 1.2.3
140306 5:04:07 InnoDB: Initializing buffer pool, size = 16.0M
140306 5:04:07 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140306 5:04:07 InnoDB: Could not open or create data files.
140306 5:04:07 InnoDB: If you tried to add new data files, and it failed here,
140306 5:04:07 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140306 5:04:07 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140306 5:04:07 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140306 5:04:07 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140306 5:04:07 InnoDB: remove old data files which contain your precious data!
140306 5:04:07 [ERROR] Plugin 'InnoDB' init function returned error.
140306 5:04:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140306 5:04:07 [ERROR] Unknown/unsupported storage engine: InnoDB
140306 5:04:07 [ERROR] Aborting

140306 5:04:07 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
chris93
 
Posts: 1
Joined: 05. March 2014 23:00
Operating System: windows 8

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 23 guests