Re: Mysql Administrator error "Could not find settings"
Posted by:
Colin Hume
Date: November 26, 2006 12:47PM
This happens because MySQL Administrator cannot find the location of your My.ini file. To correct this, go to Control Panel->Administrative Tools->Services and check the Properties entry (right-mouse click) against MySQL.
What you are looking for is 'Path to executable:'.
This probably reads as
C:\mysql\bin\mysqld.exe MySQL
It needs to be changed to
"C:\mysql\bin\mysqld.exe" --defaults-file="C:\WINDOWS\MY.INI" MySQL
The only way I have found of doing this is to alter the Registry, using Regedit.
The key to be changed is
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MySQL\ImagePath
You need to modify the key to read as above, including the quotes.
Stop and restart the MySQL service, and MySQL Administrator should then work correctly.