Re: Mysql Administrator error "Could not find settings"
Posted by:
Colin Hume
Date: December 05, 2006 12:14PM
The only solution now I think is to remove the MySQL Service and re-install it. As long as you are happy to do this, the following should resolve the MySQL Administrator issue.
I have found before that installing the MySQL service manually and attempting to start the Service too early generated error messages. In addition, trying to use MySQL Administrator too soon led to key sections of the my.ini file being commented out.
For these reasons, do not attempt to start the MySQL service or use MySQL Administator until the final stage is complete.
Note: under XP I use mysqld-nt rather than mysqld.
* Stage 1 - remove the MySQL service *
What I do is to open a Command Prompt box and change direcory to the MySQL bin folder.
1. NET STOP MySQL
2. mysqld-nt --remove
3. Restart the PC.
* Stage 2 - reinstall the MySQl service *
Open a Command Prompt box and change direcory to the MySQL bin folder.
1. mysqld-nt --install MySQL --defaults-file="C:\windows\my.ini"
2. Restart the PC.
* Stage 3 - Correct the Registry key entry *
1. Modify the key entry as before to add quotes.
2. Restart the PC.
Start the MySQL service using either the Control Panel or NET START MySQL.
Open MySQL Administrator - it should now be OK. If not, check the my.ini file.