Solved

MySQL  Service cannot be started

Posted on 2013-01-16
9
2,525 Views
Last Modified: 2013-01-16
Hi there. Say, experts, after using MySQL 5.5 a while and doing SQL queries in iReport 4.7.1,
the following occurred one day. (The server is running Windows 7 Home Basic).

I went into Services, selected the MySQL55 service, and clicked to start it up. After a while, the status bar had advanced quite far, but then the following error came up.

"Windows could not start the MySQL55 service on Local Computer.

Error 1067: The process terminated unexpectedly.".

Subsequently I tried again. After a long while the status bar had advanced almost to the end, then the following came up:

"Windows could not start the MySQL55 service on Local Computer.

Err 1053: The service did not respond to the start or control request in a timely fashion."

How do I begin with debugging this problem?

Many thanks in anticipation of your expertise.
0
Comment
Question by:shaunwingin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
9 Comments
 
LVL 13

Expert Comment

by:Alexios
ID: 38781831
Hello
I suggest to run an antivirus scan with an updated antivirus software
0
 

Author Comment

by:shaunwingin
ID: 38781837
Why??? Please motivate! AVS running and up to date.
We need to debug this!
0
 
LVL 13

Expert Comment

by:Alexios
ID: 38781900
Of course it is not normal behavior when a service is stopping unexpectedly.
Common issues are malware or viruses, this is the reason that I prompt you to scan so to sure that you are "clean"

Is your AVS free of charge?
0
Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

 
LVL 11

Accepted Solution

by:
Amar Bardoliwala earned 250 total points
ID: 38781906
Hello shaunwingin,

Following links should help you.

For windows error,
Error 1053: The service did not respond to the start or control request in a timely fashion

Look at following links,

http://social.technet.microsoft.com/Forums/hu/winserverGP/thread/c0402197-1c87-4e40-bfcf-d613e843a0f6

http://support.microsoft.com/kb/839174

For MYSQL error

Windows could not start the MySQL55 service on Local Computer.
Error 1067: The process terminated unexpectedly.


Look at following links,

http://www.michael-thomas.com/tech/mysql/tutorial_firststeps_downloadinstall/index.htm

http://serverfault.com/questions/214435/error-1067-the-process-terminated-unexpectedly-when-trying-to-install-mysql-o

http://cyleft.wordpress.com/2008/07/20/fixing-mysql-service-could-not-start-1067-errors/

Hope this will help you.

Thank you.

Amar Bardoliwala
0
 
LVL 8

Assisted Solution

by:databoks
databoks earned 250 total points
ID: 38782073
What does the Event Viewer tell you?

It has nothing to do with a malware or antivirus. This is a software problem.

check the following:

1. Is there enough space on the drive where your databases/MySQL install resides?
2. Is there enough memory
3. Check the MySQL directory for log files.
4. Check the Log-On Tab on the service to see if the service is started with a username that doesn't exists or doesn't have permissions.
0
 

Author Comment

by:shaunwingin
ID: 38782085
Pls send standard path to log files
0
 

Author Comment

by:shaunwingin
ID: 38782131
but:
[root@messaging logs]# wget http://127.0.0.1:18991/www.tmr.ecommunicate.co.za
--2013-01-16 13:07:22--  http://127.0.0.1:18991/www.tmr.ecommunicate.co.za
Connecting to 127.0.0.1:18991... connected.
HTTP request sent, awaiting response... 404 Not Found
2013-01-16 13:07:22 ERROR 404: Not Found.

[root@messaging logs]#
0
 
LVL 8

Expert Comment

by:databoks
ID: 38782739
what is that you have posted?
0
 

Author Comment

by:shaunwingin
ID: 38782882
Pls ignore
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question