MySQL Administrator Error: “Could Not Find Settings”
Warning: technical post to follow on MySQL Admin software.
I posted this information in the MySQL Forums, but unfortunately, their “phorum” software threads posts by discussion and not date, so I doubt my information will ever be found.
Here it is, in case this issue bugs you as much as it has me.
The MySQL Admin program tries to determine the location of the “my.ini” file by looking at the “command line” of the service that’s running.
The service is installed so the default command line is
"C:\mysql\bin\mysqld.exe" "--defaults-file=C:\WINDOWS\MY.INI" MySQL50
(where “MySQL50″ is the actual name of the service on your machine)
Colin, in the second post on this thread, had it right though. The line needs to be
"C:\mysql\bin\mysqld.exe" --defaults-file="C:\WINDOWS\MY.INI" MySQL50
The key change is in the quotation marks.
Obviously, the paths will differ depending on where you installed things on your system. It might just as easily be --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini".
The key you want to change using regedt32 is
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MySQL50\ImagePath
Making this change is what made the error/warning message from MySQL Admin finally go away for me.