This is for all of you who have the problem with MySQLAdministrator throwing the Error "Either the server service or the configuration file could not be found. Startup variables and service section are therefore disabled."
On and off I battled with this for over 6 month and only when I looked into "MySQL Administrator" not using XAMPP I finally realized what's going on…
MySQL Administrator is not actually looking for an existing service as one may suspect, no it expects all info within it's own local install path: C:\%PROGRAMFILES%\MySQL\…!
So, with a simple trick you can make MySQL Administrator show you where it thinks the stuff should be — simply press the "CTRL" key when you're logging on — and you'll see the "Cancel-Button" become a "Skip-Button" hit Skip and you'll get to a plain MySQL-Administrator config GUI.
Why they made it so complicated I don't know, but yes sometimes the "CTRL" key is just magic
Then just go to the Tab "Configure Service" (Service Controle -> Configure Service), where you'll see some red highlighted Path & File infos.
Go ahead and replace them with the XAMPP values from your install
- Code: Select all
Like:
Config Filename: C:\apachefriends\xampp\mysql\bin\my.cnf
Path to binary: C:\apachefriends\xampp\mysql\bin\mysqld
And all should be good.
Personally I go to "regedit" after all the changes and look for
- Code: Select all
"HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MySQL"
- Code: Select all
"C:\apachefriends\xampp\mysql\bin\mysqld" --defaults-file="C:\apachefriends\xampp\mysql\bin\my.cnf" "MySQL"
This is just to double check and making sure I'm using just one "my.cnf" as this can easily be the cause of "why isn't it working" or "why is it ignoring my changes"…
My first post here and sort of my Thank You to Apachefriends.
Hope it'll be useful
Cheers