I've been trying to setup the database connection to use the following details:
host => '127.0.0.1'
port => xxxx (non-default)
using host => localhost disregards the non-default port
using host => 127.0.0.1 regardless of port, results to "Please check your database connection in `app/Config/database.php` or may be some syntax error."
using host=> 127.0.0.1:XXXX results the same with SETUP 2
using host => localhost:XXXX results the same with Database Configuration form.
Is it possible to use a non-default port and and host other than 'localhost'. Already checked the credentials and privileges and connections are okay when using different mysql client tool.
Thank you very much in advance!