Error establishing a database connection WordPress on Mac

The issue:

When we tried to setup WordPress in Mac we encountered issue related to database connection. Following is the issue:

Error establishing a database connection

In WordPress setup it is usually a common practice to use MySQL database on the same machine which is localhost. So the database host becomes the localhost.

The WordPress default setup comes with default wp-config.php there it has like this:

/** MySQL hostname */
define('DB_HOST', 'localhost');

The reason:

Mac OS can not determine the database host using localhost. It understands the localhost as the IP: 127.0.0.1

The solution:

We had to use the local IP instead of localhost like below:

/** MySQL hostname */
define('DB_HOST', '127.0.0.1');
Share