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.

Practice

1. What is the main purpose of the .env file in Laravel's database configuration?

easy

A. To write SQL queries directly

B. To store user session data

C. To define routes for the application

D. To securely store database connection details like username and password

Solution

1. Step 1: Understand the role of the .env file

   The .env file holds environment-specific settings, including sensitive data like database credentials.

2. Step 2: Identify what is stored in .env for database

   It stores host, database name, username, and password securely, keeping them out of code files.

3. Final Answer:

   To securely store database connection details like username and password -> Option D

4. Quick Check:

   .env stores sensitive config = B [OK]

Hint: Remember .env keeps secrets safe, not code or queries [OK]

Common Mistakes:

• Thinking .env stores SQL queries
• Confusing .env with route files
• Assuming .env stores user data

2. Which of the following is the correct way to set the database connection type in Laravel's .env file?

easy

A. DB_CONNECTION=mysql

B. DATABASE=mysql

C. DB_TYPE=mysql

D. CONNECTION_DB=mysql

Solution

1. Step 1: Recall Laravel's .env database config keys

   Laravel uses keys starting with DB_, such as DB_CONNECTION for the driver type.

2. Step 2: Match the correct key for connection type

   The correct key is DB_CONNECTION, set to the database type like mysql, pgsql, sqlite.

3. Final Answer:

   DB_CONNECTION=mysql -> Option A

4. Quick Check:

   DB_CONNECTION sets driver = C [OK]

Hint: DB_CONNECTION is the exact key for database type [OK]

Common Mistakes:

• Using DATABASE or DB_TYPE instead of DB_CONNECTION
• Mixing key order or spelling
• Forgetting to set DB_CONNECTION at all

3. Given this .env snippet:

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=mydb
DB_USERNAME=user
DB_PASSWORD=pass

What database type will Laravel connect to?

medium

A. MySQL

B. PostgreSQL

C. SQLite

D. SQL Server

Solution

1. Step 1: Check the DB_CONNECTION value

   The value is 'pgsql', which is the driver name for PostgreSQL in Laravel.

2. Step 2: Match driver to database type

   'pgsql' corresponds to PostgreSQL, not MySQL, SQLite, or SQL Server.

3. Final Answer:

   PostgreSQL -> Option B

4. Quick Check:

   DB_CONNECTION=pgsql means PostgreSQL = A [OK]

Hint: pgsql means PostgreSQL, mysql means MySQL [OK]

Common Mistakes:

• Confusing pgsql with MySQL
• Ignoring DB_CONNECTION value
• Assuming default is MySQL always

4. You wrote this in your .env file:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=myapp
DB_USERNAME=root
DB_PASSWORD=

But Laravel throws a connection error. What is the most likely cause?

medium

A. Empty DB_PASSWORD causes authentication failure

B. DB_PORT 3306 is incorrect for MySQL

C. DB_HOST should be an IP address, not 'localhost'

D. DB_CONNECTION should be 'pgsql' for MySQL

Solution

1. Step 1: Review the DB_PASSWORD value

   The password is empty, which may cause authentication failure if MySQL requires a password.

2. Step 2: Check other config values

   DB_PORT 3306 is correct for MySQL, DB_HOST 'localhost' is valid, and DB_CONNECTION 'mysql' is correct.

3. Final Answer:

   Empty DB_PASSWORD causes authentication failure -> Option A

4. Quick Check:

   Empty password often blocks login = A [OK]

Hint: Empty password often causes connection errors [OK]

Common Mistakes:

• Assuming port 3306 is wrong
• Thinking localhost is invalid
• Mixing DB_CONNECTION values

5. You want to configure Laravel to use two different databases: one MySQL and one SQLite. How should you set this up in Laravel's configuration?

hard

A. Use only one database type per Laravel project; multiple are not supported

B. Set DB_CONNECTION in .env to both 'mysql,sqlite' separated by comma

C. Define both connections in config/database.php and set DB_CONNECTION in .env to the default

D. Create two separate .env files, one for each database

Solution

1. Step 1: Understand Laravel's multiple connection support

   Laravel supports multiple database connections defined in config/database.php under 'connections'.

2. Step 2: Set default connection in .env and use others explicitly

   DB_CONNECTION in .env sets the default. You can use other connections by specifying their names in code.

3. Final Answer:

   Define both connections in config/database.php and set DB_CONNECTION in .env to the default -> Option C

4. Quick Check:

   Multiple connections in config, default in .env = D [OK]

Hint: Use config/database.php for multiple connections, .env for default [OK]

Common Mistakes:

• Trying to list multiple DB_CONNECTION values in .env
• Creating multiple .env files
• Thinking Laravel can't handle multiple databases