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

#1
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
Reply

#2
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 )
Reply

#3
Try changing hostname from localhost to 127.0.0.1
Reply

#4
(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 ?
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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