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