Symptom
When you click the Start button in MySQL Manager, nothing happens. Normally, the button changes from Start to Stop after MySQL starts.
Solution
This usually happens when the host name of the server is set to something other than its DNS name. This prevents the database from being created, as you may verify by reading the ".err" files at /var/mysql/. If you cannot fix your DNS configuration, then follow these steps to create the database files:
1. Open Terminal (/Applications/Utilities/).
2. Each of the following commands is preceded by the number sign (#), which represents the prompt you see on screen. Type each command, pressing Return before continuing to the next:
# sudo mysql_install_db --force
# sudo chown -R mysql:admin /var/mysql
# sudo chmod -R o- /var/mysql
# sudo safe_mysqld &
# sudo mysqladmin -u root password <new_pwd>
Note: Replace "<new_pwd>" with your actual new password of choice. If your new password was "p$ssw*rd", then you would type:
sudo mysqladmin -u root password p$ssw*rd
3. Quit Terminal.