CI Shield setup: can't connect to database

I've run into a problem that is driving me nuts. I installed CI4.6.1 and everything went as expected. I need an authentication system, so I turned to CI Shield. Followed the docs and installation seemed to run smoothly. And that's when things went south: ran the setup through spark - everything worked until the last step and this got thrown at me:

Code:

Running all new migrations...
[CodeIgniter\Database\Exceptions\DatabaseException]
Unable to connect to the database.
Main connection [MySQLi]: No such file or directory
at SYSTEMPATH/Database/BaseConnection.php:467

I double checked my database config and everything seemed to be fine:

Code:

public local -> array (20) [
        'DSN' => string (0) ""
        'hostname' => string (9) "localhost"
        'username' => string (4) "root"
        'password' => string (4) "root"
        'database' => string (10) "benzaiten2"
        'DBDriver' => string (6) "MySQLi"
        'DBPrefix' => string (0) ""
        'pConnect' => boolean false
        'DBDebug' => boolean true
        'charset' => string (7) "utf8mb4"
        'DBCollat' => string (18) "utf8mb4_general_ci"
        'swapPre' => string (0) ""
        'encrypt' => boolean false
        'compress' => boolean false
        'strictOn' => boolean false
        'failover' => array (0) []
        'port' => integer 8889
        'numberNative' => boolean false
        'foundRows' => boolean false
        'dateFormat' => array (3) [
            'date' => string (5) "Y-m-d"
            'datetime' => string (11) "Y-m-d H:i:s"
            'time' => string (5) "H:i:s"
        ]

    ]
I changed "localhost" to "127.0.0.1",  just as a test and tried running the migration again, and got the same result. I checked the connection with both the CLI and a PHP script and had no issues.
I'm using MAMP as my development enviroment, and it's running PHP8.3.9 and MySQL8.0.35.
Any suggestions or pointers in the right direction would be greatly appreciated.

Check your MySQLi my.ini port number it is usually 3306

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Check your MySQLi my.ini port number it is usually 3306

Thanks for the suggestion, but it didn't help: for whatever reason, MAMP sets its default ports for Apache and MySQL at 8888 and 8889 respectively, and I have not changed those settings. I was also able to access the database through localhost:8889 through other scripts and the terminal, so that doesn't appear to be the problem.

That is strange, the only time I get an error on a database connection is if I forget to create a
database connection in my PhpStorm editor, but then I' m running on Windows 11 Rro.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Check your MySQLi my.ini port number it is usually 3306

Thanks for the suggestion, but it didn't help: for whatever reason, MAMP sets its default ports for Apache and MySQL at 8888 and 8889 respectively, and I have not changed those settings. I was also able to access the database through localhost:8889 through other scripts and the terminal, so that doesn't appear to be the problem.

Are you using MAMP for Windows? Even the free version of MAMP for Mac should allow you to use ports 80 and 3306 (web server & Db respectively).
I had published an end-to-end tutorial video on showing how to set up the free version of MAMP (on macOS) for frameworks like CodeIgniter:

How to Set Up a Virtual Host on Free MAMP for Frameworks like CodeIgniter 4 and Laravel  

Near the exact timestamp suffixed to the link above, you should see where exactly to customize default MAMP ports.

---

CodeIgniter Wizard (CRUD code generator for Mac) instantly scaffolds Bootstrap-based web applications with an administrative interface (admin templates include Bootstrap5)

---