Page 1 of 3

MySQL problems

PostPosted: 16. January 2009 08:01
by qbjj07
I got the message "Cannot find path specified" when trying to run MySQL, and I think I have traced the problem and now I need help fixing it. I went into services and looked at the MySQL service and the path to executable gives a path to a previous version of MySQL I have since taken off the computer. So my question is how do I change the path to direct it to the mysql in my xampp package?

Thanks for your help.

Re: MySQL problems

PostPosted: 16. January 2009 08:09
by Izzy
Open a command prompt
Click start
Click on Run...
Type: cmd.exe

Type:
sc delete mysql
Click OK

BTW - sc is an acceptable abbreviation for sc.exe Windows Service Controller and will delete any stray services that won't shut down by any normal means, among other services commands.

Re: MySQL problems

PostPosted: 16. January 2009 08:32
by qbjj07
Thanks for your help. Did the delete thing, and the service appears to be successfully uninstalled. I ran the mysql_install next, and it still says path not found. So how do I make sure the install path is correct?

Re: MySQL problems

PostPosted: 16. January 2009 08:37
by Izzy
qbjj07 wrote:I ran the mysql_install next, and it still says path not found. So how do I make sure the install path is correct?
What is mysql_install?

Re: MySQL problems

PostPosted: 16. January 2009 08:41
by qbjj07
Nevermind. MySQL appears to be running now. Thanks for the help.

So at this point, how do I get phpmyadmin to run?

Re: MySQL problems

PostPosted: 16. January 2009 08:45
by Izzy

Re: MySQL problems

PostPosted: 16. January 2009 08:48
by qbjj07
Izzy wrote:http://localhost/phpmyadmin


There is nothing at that link. I have apache and mysql started, did I miss something?

Re: MySQL problems

PostPosted: 16. January 2009 08:55
by Izzy
Nothing at the other links either?

Re: MySQL problems

PostPosted: 16. January 2009 08:57
by qbjj07
Izzy wrote:Nothing at the other links either?


nope

Re: MySQL problems

PostPosted: 16. January 2009 09:02
by Izzy
Then I suspect that Apache and MySQL are not running.

How did you start Apache and MySQL?

Did you use the XAMPP Control Panel?
in the xampp folder double click on xampp-control.exe

Apache and MySQL should show running in green.

Check using Task Manager>Processes tab by right clicking on the Task Bar.
Check and see if you have 2 apache files and 1 mysql file processes running.

Re: MySQL problems

PostPosted: 16. January 2009 09:08
by qbjj07
I did use the control panel.
Apache and MySQL both show running in green, but I couldn't find either in the task manager anywhere.

Re: MySQL problems

PostPosted: 16. January 2009 09:16
by Izzy
qbjj07 wrote:I did use the control panel.
Apache and MySQL both show running in green, but I couldn't find either in the task manager anywhere.
If they are not in the Processes tab of the Task Manager then they are not running.

Try stopping them in the XCP till the green running goes away.

Now go to the xampp folder and double click on the apache_start.bat and paste any error messages here.
(To copy and paste from a console window click on the little icon to left of the window titlw bar and the click on the Edit item - the mark and copy are located in there then just paste the results in the forum reply box).

Re: MySQL problems

PostPosted: 16. January 2009 09:24
by qbjj07
Izzy wrote:
qbjj07 wrote:I did use the control panel.
Apache and MySQL both show running in green, but I couldn't find either in the task manager anywhere.
If they are not in the Processes tab of the Task Manager then they are not running.

Try stopping them in the XCP till the green running goes away.

Now go to the xampp folder and double click on the apache_start.bat and paste any error messages here.
(To copy and paste from a console window click on the little icon to left of the window titlw bar and the click on the Edit item - the mark and copy are located in there then just paste the results in the forum reply box).


"Diese Eingabeforderung nicht waehrend des Running beenden
Bitte erst bei einem gewollten Shutdown schliessen
Please close this command only for Shutdown
Apache 2 is starting ...
apache.exe: Syntax error on line 42 of C:/xampp/xampp/apache/conf/httpd.conf: Se
rverRoot must be a valid directory

Apache konnte nicht gestartet werden
Apache could not be started
Press any key to continue . . ."

Re: MySQL problems

PostPosted: 16. January 2009 09:35
by Izzy
Paste here what line 42 of C:/xampp/xampp/apache/conf/httpd.conf

You installed XAMPP to C:/xampp/xampp ?

Best to install to the C:\ drive then it will create C:\xampp not C:\xampp\xampp


3 Searches results for serverroot must be a valid directory
viewtopic.php?f=16&t=32638&hilit=ServerRoot+must+be+a+valid+directory

viewtopic.php?f=16&t=29532&hilit=ServerRoot+must+be+a+valid+directory

viewtopic.php?f=16&t=28456&hilit=ServerRoot+must+be+a+valid+directory

Re: MySQL problems

PostPosted: 16. January 2009 09:38
by qbjj07
Izzy wrote:Paste here what line 42 of C:/xampp/xampp/apache/conf/httpd.conf

You installed XAMPP to C:/xampp/xampp ?

Best to install to the C:\ drive then it will create C:\xampp not C:\xampp\xampp


I tried to put it on the C:\ drive, but must have messed up somehow. Is that a big deal?

What program do I use to view the file you asked about, the .conf?