Database configuration in Laravel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What file in a Laravel project holds the main database configuration settings?

The .env file holds the main database configuration settings like database name, username, password, and host.

beginner

How do you specify the database connection type in Laravel?

You specify the database connection type in the DB_CONNECTION variable inside the .env file, for example, DB_CONNECTION=mysql.

intermediate

Where does Laravel store the default database connection settings besides the .env file?

Laravel stores default database connection settings in the config/database.php file, which reads values from the .env file.

beginner

What is the purpose of the DB_HOST variable in Laravel's database configuration?

The DB_HOST variable defines the address of the database server Laravel should connect to, like 127.0.0.1 or a remote IP.

intermediate

How can you configure multiple database connections in Laravel?

You can add multiple connections inside the connections array in config/database.php and switch between them by setting DB_CONNECTION in .env.

Which file do you edit to set your database username in Laravel?

A .env

B config/app.php

C routes/web.php

D public/index.php

The .env file is where you set environment variables like database username.

What does the DB_CONNECTION variable specify?

A The database port number

B The database password

C The type of database to connect to

D The database host address

DB_CONNECTION tells Laravel which database type to use, like mysql or sqlite.

Where are the default database connection settings stored in Laravel?

A config/database.php

B app/Models

C resources/views

D storage/logs

The config/database.php file holds the default connection settings.

If you want to connect to a remote database server, which variable do you change?

A DB_USERNAME

B DB_HOST

C DB_CONNECTION

D APP_URL

DB_HOST sets the address of the database server.

How do you switch between multiple database connections in Laravel?

A Restart the server

B Edit <code>routes/web.php</code>

C Change the database password

D Change the <code>DB_CONNECTION</code> value in <code>.env</code>

You switch connections by setting DB_CONNECTION in the .env file.

Explain how Laravel uses the .env file and config/database.php together for database configuration.

Think about where you put your database details and how Laravel reads them.

Describe the steps to configure Laravel to connect to a MySQL database on a remote server.

Focus on the variables in the .env file related to MySQL.