MAMP: Craft can’t connect to the database with the credentials in craft/config/db.php

Question

I'm using MAMP to setup a local environment for CraftCMS on Windows 10.

I have followed all necessary procedures and have my local host and my database setup but I'm still receiving the error mentioned above.

My db.php is shown as this:

 return array(

        // The database server name or IP address. Usually this is 'localhost' or '127.0.0.1'.
       'server' => 'localhost',

        // The name of the database to select.
        'database' => 'mycraft',

       // The database username to connect with.
       'user' => 'root',

       // The database password to connect with.
      'password' => 'root',

       // The prefix to use when naming tables. This can be no more than 5 characters.
      'tablePrefix' => 'craft',

 );

Even if i make a custom user or password I still get the error above when I try to connect to http://localhost:8888/admin

I've checked many times and all my credentials as well as my local host port is correct. Craft can clearly connect to host which is why I'm getting the error from craft but for some reason, despite the details in db.php being correct it cant connect to the database...

Anyone know what's going on?

Answer 1

The default MAMP DB credentials are indeed root:root, as you have already, so you should check that you did indeed create a database (set up as detailed here) and that it is indeed called ‘mycraft’.

Also check in your MAMP control panel that the MySQL is actually running:

Answer 2

This happens when you go from old versions of craft, in the latest versions you have to have the config/db.php file like this:

<?php
use craft\helpers\App;

return [
    'dsn' => App::env('DB_DSN') ?: null,
    'driver' => App::env('DB_DRIVER'),
    'server' => App::env('DB_SERVER'),
    'port' => App::env('DB_PORT'),
    'database' => App::env('DB_DATABASE'),
    'user' => App::env('DB_USER'),
    'password' => App::env('DB_PASSWORD'),
    'schema' => App::env('DB_SCHEMA'),
    'tablePrefix' => App::env('DB_TABLE_PREFIX'),
];

Also make sure you have the correct database credentials in the .env file and delete a line called DSN if you have it.

I used composer.