Page 1 of 1

MySQL problem

PostPosted: 10. June 2011 14:31
by seahawk182
i have a problem with mysql... i start it in the control panel and it starts normally... no error... but when i go to the security section on localhost it says mysql is not running or is blocked by a firewall and it doesn't work with firewall off either... i can't set the password for root because of this and basically can't use it...

Anyone having the same problem?

PS: i'm using XP 32bit and xampp 1.7.4

Re: MySQL problem

PostPosted: 10. June 2011 17:07
by JonB
try making MySQL a service (check the Svc box) - then restart the machine, and try things out.

Just a question, have you had any other suites like XAMPP installed or had MySQL installed standalone before??
:D

Re: MySQL problem

PostPosted: 10. June 2011 17:36
by seahawk182
no i haven't.

i'll try making it a service and then post if it still doesn't work...

Re: MySQL problem

PostPosted: 12. June 2011 11:36
by seahawk182
well i tried that and it still doesn't work... any other ideas maybe?

thanks for helping anyway.

Re: MySQL problem

PostPosted: 13. June 2011 00:34
by JonB
Ok

I guess we need to get to specifics:

What specific version of Windows (including 32 or 64 bit and what service pack, and what version of XAMPP? - and - where is XAMPP installed on your machine?

Also - you say that it starts from the XAMPP control panel, correct? Does Apache start OK as well?

If so - don't go the the XAMPP security page -
just type this address in your browser - and see what happens when you try to go there
http://localhost/phpmyadmin

Good Luck
:)

Re: MySQL problem

PostPosted: 13. June 2011 16:14
by seahawk182
well apache used to work fine but now it doesn't start :D and i'm now getting the run from root folder error...

i'm using winXP 32bit sp3 and XAMPP 1.7.4 installed on d:/xampp


EDIT: actually sometimes apache starts but then stops in like 2 seconds...

Re: MySQL problem

PostPosted: 13. June 2011 17:22
by JonB
Well - if you are just getting started, I would un-install the current XAMPP, and install XAMPP 1.7.3 - its much more stable (unless you have some version-related reason to run 1.7.4).

Well, I guess I need a how-to-uninstall-XAMPP page!

Basics -

A. Save or backup any files or folders you have created. If you are using MySQL, and wish to preserve any databases, you will need to do a MySQL backup, a file-based backup will not work.

B. Be sure to remove the 'Services' you may have running before uninstalling XAMPP - uncheck the Svc box before those services currently running - Apache, MySQL, FileZilla and/or Mercury. Reboot the machine, check the XAMPP Control Panel and ensure the Svc boxes are not 'unchecked'. Close the XAMPP Control Panel.

C. You should now be clear to remove the XAMPP folder and its sub-folders.


Good Luck
8)

Re: MySQL problem

PostPosted: 13. June 2011 19:56
by seahawk182
it seems to be working now :D thank you very much :D