CodeIgniter Forums

Full Version: Unable to connect to the database
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Just installed CodeIgniter 4.0.4 and MySQL 8.0.23, trying to do the tutorial and I'm getting this error:

Code:
ERROR - 2021-01-30 21:30:48 --> Error connecting to the database: No such file or directory
CRITICAL - 2021-01-30 21:30:48 --> Unable to connect to the database.
#0 /Users/......./ci-news/system/Database/BaseConnection.php(646): CodeIgniter\Database\BaseConnection->initialize()

I've searched and searched and I could not find a solution. In php.ini I have:

Code:
;extension=exif      ; Must be after mbstring as it depends on it
extension=mysqli
;extension=oci8_12c  ; Use with Oracle Database 12c Instant Client

and in .env

Code:
database.default.hostname = localhost
database.default.database = <database>
database.default.username = <user>
database.default.password = <pass>
database.default.DBDriver = MySQLi
Did you start MySQLi using spark?

Make sure that your username and password are correct also.
Try changing hostname from localhost to 127.0.0.1
(01-31-2021, 09:37 AM)paulbalandan Wrote: [ -> ]Try changing hostname from localhost to 127.0.0.1

Yes, that was it. Why's that?


The following is for whoever maintains the documentation. Perhaps they read these posts, as I could not find a way to provide feedback.
Should the documentation here be updated https://www.codeigniter.com/user_guide/t...ction.html so other people don't waste their time like I did ?