Solved Mac OSX MySQL fresh install password mystery
Hey all
after many frustrating hours searching many web forums, I have managed to get into MySQL Administrator and Query Browser fresh after installing.
Thanks to the many suggestions, which were all technically correct. The below user/pass were ok, but I eventually had to install a nifty OSX app called MAMP and add connect via a temp socket (?!)
So here is the deal once installed, MySQL administrator/query browser requires the following for you to login successfully.
1. Download and install MAMP (index.html)
2. Once launched click on start servers (it works by istelf from here just leave it on in the background)
3. Open MySQL Administrator(same for Query Browser) and enter:
Server Hostname:localhost
Port:8889
Username: root
Password: root
> then click on "more options" and paste the following into
Connect using socket: /Applications/MAMP/tmp/mysql/mysql.sock
hope it works for other Mac users that were stumped, gees it only took me about 2 years on and off of coming back to it to work this out but hey it was worth it.