Welcome Guest, Not a member yet? Register   Sign In
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

(This post was last modified: 01-31-2021, 03:01 AM by InsiteFX.)

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




Theme © iAndrew 2016 - Forum software by © MyBB