Solved

Problem starting Mysql server

Posted on 2010-08-25
7
1,400 Views
Last Modified: 2013-12-13
Hi,
I'm a fresh newbie to this Mysql world and i have a problem -
i have a laptop with 32 bit Vista SP2 installed. i've installed the recent EasyPHP WAMP package. in the EasyPHP control panel, the Apache server is working (green light), but the MySQL is not (red light). trying to start it, it fails and i get the red light again. i get no error messages. to try and find the solution i did the following:
i saw that the MySQL listens to port 3306 so in my router, under NAT-Port Forwarding, i added to the port forwarding table my computer's ip, port 3306 and "TCP". the router's firewall is off. this didn't help.
i stopped window's firewall - this didn't help.
i stopped my avast anti-virus - this didn't help.
as the FAQ page on the EasyPHP site says - in the program files\EasyPHP folder security options, i granted "full control" permissions to all users - this didn't help.
Do you have any idea where is the problem or some ways to find it?
Thanks :)
0
Comment
Question by:Or_A
7 Comments
 
LVL 34

Assisted Solution

by:Beverley Portlock
Beverley Portlock earned 375 total points
ID: 33525857
Look for a file called something like

:\Program Files\MySQL\MySQL Server 5.0\data\hostname.err

and see what is in there. That's where the error messages should be logged. If it is not there then scan for a file ending in .err and have a look in it at the bottom for the latest error.
0
 

Author Comment

by:Or_A
ID: 33525974
thanks,
well i didn't find this exact file name, but i found another file that looks like an error log, with the following 2 lines repeat themselves lots of times:
25/08 23:14:13 EasyPHP MySQL ServerBase::Start ScanProcess -> 2428
25/08 23:14:14 EasyPHP ServerBase::TimerProc : GetProcessVersion MySQL (pid: 2428) error 5
it helps?
0
 
LVL 27

Assisted Solution

by:Lukasz Chmielewski
Lukasz Chmielewski earned 125 total points
ID: 33526370
How abou using xampp ?
http://www.apachefriends.org/en/xampp.html

See if the problem exists there also.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 34

Assisted Solution

by:Beverley Portlock
Beverley Portlock earned 375 total points
ID: 33526415
I've had a quick check. This seems to be a common problem with EasyPHP. Apparently most people solve it by switching to XAMPP

http://www.apachefriends.org/en/xampp.html

Is there some reason you picked EasyPHP?
0
 
LVL 34

Accepted Solution

by:
Beverley Portlock earned 375 total points
ID: 33526423
If you do install XAMPP make sure you uninstall EasyPHP first and then (Windows!) do a restart.
0
 

Author Comment

by:Or_A
ID: 33526474
thank you, i installed EasyPHP because a book i've read recommended it, but i'll guess i'll try XAMPP...
0
 
LVL 11

Expert Comment

by:mattibutt
ID: 33526476
Use xampp
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can define this $_GET["page"]  variable on my page? 5 32
can windows 10 wamp send mail()? 3 32
update joined tables 2 27
Session timeout 5 13
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
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…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

914 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now