Laravel Database Connections

Following are some database connection possibilities. It's not mandatory to use one of them but given for demo purpose.

For MySQL#

Copy file .env.example, and change its name to .env. Then in file .env complete this database configuration:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=

For SQLite#

Create a database in database folder.

#create database
touch database/database.sqlite

Copy file .env.example, and change its name to .env. Then in file .env replace this database configuration:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=

To this:

DB_CONNECTION=sqlite
DB_DATABASE=/path_to_your_project/database/database.sqlite

For PostgreSQL#

1. Install PostgreSQL: You can refer its official documentation to install it.
2. You have to create a user to interact with the PostgreSQL database..
Copy

$ sudo -u postgres createuser --interactive
enter name of role to add: laravel
shall the new role be a superuser (y/n) n
shall the new role be allowed to create database (y/n) n
shall the new role be allowed to create more new roles (y/n) n

3. You have to update/change the default password with your desired one. In our case, we have put 'password' as a password.
Copy

$ sudo -u postgres psql
postgres= ALTER USER laravel WITH ENCRYPTED PASSWORD 'password';
postgres= \q

4. Create database for your Laravel app.
Copy

sudo -u postgres createdb laravel

5. Copy file .env.example, and change its name to .env. Then in file .env replace this database configuration:
Copy

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=

6. To this:
Copy

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=laravel
DB_USERNAME=laravel
DB_PASSWORD=password