Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 06:21PM

Hi, i've installed WAMP, I have an ERROR in MYSQL, it won''t start up, i had the same error in XAMPP and USBSERVER V8, With XAMPP it was ''TERMINATING WORKER THREAD 1'' ,I looked everywhere for a solution but couldnt find it, Here are the MYSQL-logs :120131 11:36:15 [Note] Plugin 'FEDERATED' is disabled.
120131 11:36:16 InnoDB: The InnoDB memory heap is disabled
120131 11:36:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120131 11:36:16 InnoDB: Compressed tables use zlib 1.2.3
120131 11:36:16 InnoDB: Initializing buffer pool, size = 128.0M
120131 11:36:16 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
120131 11:36:16 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120131 11:36:17 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120131 11:36:19 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\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
120131 11:36:23 InnoDB: Waiting for the background threads to start
120131 11:36:24 InnoDB: 1.1.8 started; log sequence number 0
120131 11:36:24 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120131 11:36:24 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120131 11:36:24 [ERROR] Aborting

120131 11:36:25 InnoDB: Starting shutdown...
120131 11:36:25 InnoDB: Shutdown completed; log sequence number 1595675
120131 11:36:25 [Note] wampmysqld: Shutdown complete

120131 11:48:07 [Note] Plugin 'FEDERATED' is disabled.
120131 11:48:07 InnoDB: The InnoDB memory heap is disabled
120131 11:48:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120131 11:48:07 InnoDB: Compressed tables use zlib 1.2.3
120131 11:48:07 InnoDB: Initializing buffer pool, size = 128.0M
120131 11:48:07 InnoDB: Completed initialization of buffer pool
120131 11:48:07 InnoDB: highest supported file format is Barracuda.
120131 11:48:08 InnoDB: Waiting for the background threads to start
120131 11:48:09 InnoDB: 1.1.8 started; log sequence number 1595675
120131 11:48:10 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120131 11:48:10 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120131 11:48:10 [ERROR] Aborting

120131 11:48:10 InnoDB: Starting shutdown...
120131 11:48:10 InnoDB: Shutdown completed; log sequence number 1595675
120131 11:48:10 [Note] wampmysqld: Shutdown complete

120131 11:49:46 [Note] Plugin 'FEDERATED' is disabled.
120131 11:49:46 InnoDB: The InnoDB memory heap is disabled
120131 11:49:46 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120131 11:49:46 InnoDB: Compressed tables use zlib 1.2.3
120131 11:49:46 InnoDB: Initializing buffer pool, size = 128.0M
120131 11:49:46 InnoDB: Completed initialization of buffer pool
120131 11:49:46 InnoDB: highest supported file format is Barracuda.
120131 11:49:47 InnoDB: Waiting for the background threads to start
120131 11:49:48 InnoDB: 1.1.8 started; log sequence number 1595675
120131 11:49:48 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120131 11:49:48 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120131 11:49:48 [ERROR] Aborting

120131 11:49:48 InnoDB: Starting shutdown...
120131 11:49:48 InnoDB: Shutdown completed; log sequence number 1595675
120131 11:49:48 [Note] wampmysqld: Shutdown complete

120131 14:57:11 [Note] Plugin 'FEDERATED' is disabled.
120131 14:57:11 InnoDB: The InnoDB memory heap is disabled
120131 14:57:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120131 14:57:11 InnoDB: Compressed tables use zlib 1.2.3
120131 14:57:11 InnoDB: Initializing buffer pool, size = 128.0M
120131 14:57:11 InnoDB: Completed initialization of buffer pool
120131 14:57:12 InnoDB: highest supported file format is Barracuda.
120131 14:57:14 InnoDB: Waiting for the background threads to start
120131 14:57:15 InnoDB: 1.1.8 started; log sequence number 1595675
120131 14:57:15 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120131 14:57:15 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120131 14:57:15 [ERROR] Aborting

120131 14:57:15 InnoDB: Starting shutdown...
120131 14:57:16 InnoDB: Shutdown completed; log sequence number 1595675
120131 14:57:16 [Note] wampmysqld: Shutdown complete

120131 14:57:23 [Note] Plugin 'FEDERATED' is disabled.
120131 14:57:23 InnoDB: The InnoDB memory heap is disabled
120131 14:57:23 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120131 14:57:23 InnoDB: Compressed tables use zlib 1.2.3
120131 14:57:23 InnoDB: Initializing buffer pool, size = 128.0M
120131 14:57:23 InnoDB: Completed initialization of buffer pool
120131 14:57:23 InnoDB: highest supported file format is Barracuda.
120131 14:57:23 InnoDB: Waiting for the background threads to start
120131 14:57:24 InnoDB: 1.1.8 started; log sequence number 1595675
120131 14:57:25 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120131 14:57:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120131 14:57:25 [ERROR] Aborting

120131 14:57:26 InnoDB: Starting shutdown...
120131 14:57:26 InnoDB: Shutdown completed; log sequence number 1595675
120131 14:57:26 [Note] wampmysqld: Shutdown complete

120131 18:12:25 [Note] Plugin 'FEDERATED' is disabled.
120131 18:12:26 InnoDB: The InnoDB memory heap is disabled
120131 18:12:26 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120131 18:12:26 InnoDB: Compressed tables use zlib 1.2.3
120131 18:12:26 InnoDB: Initializing buffer pool, size = 128.0M
120131 18:12:26 InnoDB: Completed initialization of buffer pool
120131 18:12:26 InnoDB: highest supported file format is Barracuda.
120131 18:12:30 InnoDB: Waiting for the background threads to start
120131 18:12:31 InnoDB: 1.1.8 started; log sequence number 1595675
120131 18:12:32 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120131 18:12:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120131 18:12:32 [ERROR] Aborting

120131 18:12:32 InnoDB: Starting shutdown...
120131 18:12:33 InnoDB: Shutdown completed; log sequence number 1595675
120131 18:12:33 [Note] wampmysqld: Shutdown complete

Can anybody see whats going wrong and how to fix this , THANKS IN ADVANCE !

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 07:23PM

In the my.ini add.

Bind-address 0.0.0.0

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 08:22PM

I'M SORRY, What do you mean ?, its all abracadabra for me,what must i change in my.ini ?

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 08:35PM

you need to add that line


after

[wampmysqld]

put

Bind-address 0.0.0.0


then save and restart wamp

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 09:02PM

Steven thanks for youre quick response , i did change the bind-address but now i am seeing this :120131 18:12:25 [Note] Plugin 'FEDERATED' is disabled.
120131 18:12:26 InnoDB: The InnoDB memory heap is disabled
120131 18:12:26 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120131 18:12:26 InnoDB: Compressed tables use zlib 1.2.3
120131 18:12:26 InnoDB: Initializing buffer pool, size = 128.0M
120131 18:12:26 InnoDB: Completed initialization of buffer pool
120131 18:12:26 InnoDB: highest supported file format is Barracuda.
120131 18:12:30 InnoDB: Waiting for the background threads to start
120131 18:12:31 InnoDB: 1.1.8 started; log sequence number 1595675
120131 18:12:32 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120131 18:12:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120131 18:12:32 [ERROR] Aborting

120131 18:12:32 InnoDB: Starting shutdown...
120131 18:12:33 InnoDB: Shutdown completed; log sequence number 1595675
120131 18:12:33 [Note] wampmysqld: Shutdown complete What am i doing wrong ? Here how i configured my.ini :# The MySQL server
[wampmysql]Bind-address 0.0.0.0
port = 3306
socket = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=c:/wamp/bin/mysql/mysql5.5.20
log-error=c:/wamp/logs/mysql.log
datadir=c:/wamp/bin/mysql/mysql5.5.20/data

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 09:07PM

sorry! i missed the =

bind-address = 0.0.0.0

make sure its on a new line.. yours

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 09:25PM

Ok THANKS Steven, i think its working now but i dont have access to PHPmyadmin, dont wanna bother you but can you say if you will what i must do now, THANK YOU and isnt it dangerous to change youre bindadress to 0.0.0.0 ? I did read that thats dangerous to do .

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 10:47PM

no its fine, alll it does is disabled ipv6.

just as always make sure port 3306 is not open in your router and that you dont change phpmyadmin settings to allow ALL access.. but this is also the case if you didnt need to disable IPV6

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 11:06PM

OK THANKS but i still cant get admission on phpmyadmin, if i look in services i still see the old xampp service but is not a problem because i removed all of xampp and it wont start so, if i want to start mysql in services isee the message :error1067 , thats the problem .

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 11:08PM

Can i take a look with teamviewer? would be easier smiling smiley

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 11:35PM

that would be great !!! where can i download teamviewer ?

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 11:37PM

[teamviewer.com] smiling smiley

its free , just pm me the details, but please do so in the next 30mins , otherwise i wil lcontact you tomor to arrange a time

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 11:48PM

ok im downloading it right now, will send you pm or else tomorrow

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 11:49PM

ok sure

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: January 31, 2012 11:58PM

SO what now ?

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: January 31, 2012 11:58PM

send me the new password.. once wamp is running,

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: MYSQL ERROR (MAYBE TERMINATING WORKER THREAD 1)
Posted by: mich77 (---.adsl-surfen.hetnet.nl)
Date: February 01, 2012 12:32AM

THANK YOU STEVEN FOR THE GREAT SERVICE !!!! I WAS HALF SLEEPING , SORRY !!!! BUT IT WORKS GREAT !!! THANKS AGAIN : )

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login