• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1491
  • Last Modified:

Problem starting Mysql server

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
Or_A
Asked:
Or_A
4 Solutions
 
Beverley PortlockCommented:
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
 
Or_AAuthor Commented:
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
 
Lukasz ChmielewskiCommented:
How abou using xampp ?
http://www.apachefriends.org/en/xampp.html

See if the problem exists there also.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Beverley PortlockCommented:
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
 
Beverley PortlockCommented:
If you do install XAMPP make sure you uninstall EasyPHP first and then (Windows!) do a restart.
0
 
Or_AAuthor Commented:
thank you, i installed EasyPHP because a book i've read recommended it, but i'll guess i'll try XAMPP...
0
 
mattibuttCommented:
Use xampp
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now