
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”.
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.