Page 1 of 1

MySQL Service setting incorrect and malfunctioning

PostPosted: 20. February 2009 01:28
by CopaGringo
I am running XAMPP 1.7.0 with XP SP2.
I am an ignorant newbie (as far as XAMPP and its components go).

In the installation I did NOT check to have any programs started as a Service.
However, Mysql is starting as a Service and will not be turned off as a Service, BUT is in fact not running at all!

In addition WinMySqlAdmin.exe was loading automatically on start up and giving me the following error:
Access violation at address 1000A1F7 in module LIBMYSQL.dll. Read of address 00000000.

In msconfig I turned off the start up command for this admin file and the problem stopped.
(I include the above data about the admin program thinking that perhaps it contains some clue to the problem described below.)

In SCM (Services) I changed MySql to Manual (it was set on Auto)

Still, in the XAMPP Control Panel MySql is set to Svc (the checkbox is checked).

I unchecked the checkbox, answered yes to removing the service and the checkmark then disappears, but reappears immediately (and returns/stays even after rebooting).

I tried changing the Control Panel to a Service itself, which gave me access to the MySql checkmark in that dialogue box and unchecked and etc...again to no avail. MySql remains checked (and still not actually running, as per the Task Manager).

I tried launching mysql_start.bat and received an error message that the syntax of the file, folder or volume is incorrect.

I assume that means an error within the C:\xampp\mysql\bin\my.cnf file, as that seems to be the file that the .bat file reads to start mysql. I looked in there to see what I could see...but being an ignorant newbie, well what would I know anyhow...?

Although I did not say at each step above, I rebooted after each process just to make sure that the changes had an opportunity to take effect.

Any suggestions? Is my.cnf the file I need to make a correction in? If so, which setting and how? If not, what and where and how....PLEASE!!!!

Many thanks ahead of time.

Re: MySQL Service setting incorrect and malfunctioning

PostPosted: 20. February 2009 01:44
by Izzy
Go to
start>Run...
type
sc delete mysql
Click OK

See if that helps with the sticking MySQL service..

Re: MySQL Service setting incorrect and malfunctioning

PostPosted: 20. February 2009 03:40
by CopaGringo
That did the trick. I rebooted and the the Svc checkbox is clear and MySQL starts normally. Many thanks.

Re: MySQL Service setting incorrect and malfunctioning

PostPosted: 20. February 2009 03:54
by CopaGringo
Well, while the Run >> sc delete mysql action resolves the Svc checkbox issue, it seems that is not the end of my problems.

MySQL now starts normally, but when I then click on the Admin button for MySQL I get the problem I mentioned earlier:

The Admin screen opens and then closes within a few seconds, the checkbox for Svc MySQL is suddenly checked again and the error message (Access violation at address 1000A1F7 in module LIBMYSQL.dll. Read of address 00000000) is posted on my screen repeatedly (about every five seconds).

So in Task Manager I kill WinMySqlAdmin.exe and then do the run >> sc delete mysql routine and the checkbox clears itself (it still won't do it via the dialogue box).

So the net result is that I can load MySQL, but not the admin program.

Thoughts???

Re: MySQL Service setting incorrect and malfunctioning

PostPosted: 20. February 2009 04:11
by Izzy
Do not use this Admin.. button as it is deprecated and will always give you this issue - eventually and through time it may get removed from the XCP as it creates many support requests, search for access violation and you will see what I mean.

Use phpMyAdmin instead.

Re: MySQL Service setting incorrect and malfunctioning

PostPosted: 20. February 2009 04:14
by CopaGringo
Many, Many Thanks.