Skip to content Skip to sidebar Skip to footer

Unable to connect to the database No such file or directory

MySQLi No such file or directory

Unable to connect to the database. Main connection [MySQLi]: No such file or directory - If you get an error like:

[CodeIgniter\Database\Exceptions\DatabaseException]

Unable to connect to the database.
Main connection [MySQLi]: No such file or directory

That's a sign there is a problem with the database connection. Now in your project folder find the "env" file. Then copy and paste. rename the file "env (paste)" to ".env".

Unable to connect to the database No such file or directory


How to fix Unable to connect to the database?

Open the .env file, then adjust the database settings. For example I use the following rules:

#--------------------------------------------------------------------
# ENVIRONMENT
#--------------------------------------------------------------------

CI_ENVIRONMENT = development

#--------------------------------------------------------------------
# DATABASE
#--------------------------------------------------------------------

database.default.hostname = 127.0.0.1
database.default.database = crud_ci4
database.default.username = root
database.default.password = 
database.default.DBDriver = MySQLi
database.default.DBPrefix =

After that repeat the following command in terminal:

php spark migrate

If successful, it will appear as follows:

neon@neon:~/Documents/Project-CI4/crud_basic$ php spark migrate

CodeIgniter v4.1.5 Command Line Tool - Server Time: 2021-12-07 19:49:05 UTC-06:00

Running all new migrations...
        Running: (App) 2021-12-07-004422_App\Database\Migrations\Users
Done migrations.

Now, we will see if the table was created successfully in the database. Open phpmyadmin, navigate to the crud_ci4 database, then you will see a table named "users".

I hope this article is useful.

Post a Comment for "Unable to connect to the database No such file or directory"