• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Unable to connect to the database

Just installed CodeIgniter 4.0.4 and MySQL 8.0.23, trying to do the tutorial and I'm getting this error:

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:

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

and in .env

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.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Try changing hostname from localhost to

(01-31-2021, 09:37 AM)paulbalandan Wrote: Try changing hostname from localhost to

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 ?

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.