Can MAMP be used for production databases

I cannot log into the WordPress related MySQL database from iTerm

I discovered today that I actually have two MySQL databases on my Mac OS X Sierra because when I log into MySQL through iTerm it is not the same database as the one I see it through but regardless of what username or what password I am trying from the user accounts I cannot log into this particular database even if I change the password for one of the users.

In this case, I was looking for the database username and password in my core WordPress files, but I was unable to log in with them, which means these are not the correct credentials.

After retracing my steps, I realized that these were the credits for the production database.

What I didn't realize here is that I could have one database server overhead and yet another database server overhead. I thought they were the same server.


Without further details we cannot help you here: If we are before our Macs sitting down (or buying Christmas presents), we don't get the chance to look over your shoulder and personally check what's wrong here. Example: Two MySQL databases can mean different MySQL installations (MySQL Community Edition & Xammp), one database in each of the two MySQL installations, two databases in one of the two different installations ... etc.


I found out by reading the MAMP documentation. For anyone who might come across it in the future.

Just go to your iTerm and enter:

You should be able to log in successfully. The MAMP documents helped after I discovered that the database server is no matter what is being installed with.