Hola,

Yeah having multiple mysqls will do that to ya. localhost is the same thing as 127.0.0.1. See, a computer always checks it's host file before going out to the internet to resolve domain names to ip addresses. For example in windows there is windows/system32/drivers/etc/hosts. This hosts file has listing like this

localhost 127.0.0.1

Now when I type localhost into the browser. It looks there first. If it finds the domain name, it says ok i see it goes with this address. If not it goes out onto the old interwebs to some dns server to pair up a domain name ie (localhost) with an address ie(IP).

I have to ask, but is there an issue with connecting with the IP address? If not I wouldn't worry about it. If so then read on lol

When you connect to MAMP using 127.0.0.1 or localhost it should refer to the same place. Now, some instances of computers depending on if this is a work computer bought online or best buy. They will actually have a comment section at the localhost

localhost 127.0.0.1

If linux like ubuntu you can do

vi /etc/hosts

Check and see if it's commented out. Some applications if you install with ip address or localhost don't care if the localhost in the host file is commented out. Others do.

So I am just guessing, but if you go to your hosts file. I think you should see it commented out. If it is uncomment it and it should work. Another thing to make sure is they are not using the same port and that ports are available. You most likely arn't and the ports most likely are avail, just sayin. Sorry I am not to familiar with MAMP but I hope this helps.

Hi Ryan,

Thanks a lot for the reply. I eventually got it installed using the same version you did. I've been banging my head against the wall since yesterday!

A few things I did while setting this up:

• when I went to download an older version, it wouldn't allow me to install it. I got a message saying that there was a newer version already on my computer. Here's the solution I found for that: https://teamtreehouse.com/forum/erasing-mysql-from-mavericks-macos-and-reinstalling-errorfree-hopefully

• another problem I was having, and I'm not sure if this was part of the solution for me, but it was something I did during this process. Basically, there was 2 versions of mysqld running at the same time. I think this is because I use MAMP too. So, I had to go into activity monitor and stop one instance from running. I got the solution here: http://eliteeternity.com/mysql-server-wont-start-mamp-red-light-mac/

Now, I'm left with one small problem: as I mentioned above I use MAMP. Since setting up mySQL Community Server, I've not been able to load my MAMP server at localhost. It will only show up at this ip address: 127.0.0.1

I've been searching online and it seems other people have this problem, too, but none of the solutions I've seen have worked for me. Do you by any chance use MAMP, and have you possibly come across this problem?

Thanks again.

Hi Ryan,

I've just realized that I can't login to the backend of the local wordpress site that I'm working on. I'm able to load the login page by changing localhost to 127.0.0.1 but when I click on login, it brings me to the localhost version of the site, which obviously doesn't load for me now. Any ideas how to get around this?

I found out the reason why the localhost directory wasn't showing at localhost. In the etc/hosts file it had this extra line:

::1 localhost

I removed it and now it works at localhost. I've no idea what this line was doing, or how it got there. Any idea?

Thanks.