How to change Laravel database configuration

When you move a project from local development to a live server, switch hosting providers, or connect to a new database, it's common to have to change the Laravel database settings. If you're using the Laravel framework, it's important to know how to change database settings correctly so that your development process goes smoothly. This SEO-friendly guide will show you how to safely and quickly change the configuration of your Laravel database step by step.

Step 1: Locate the .env File

Laravel uses a file called .env to manage the settings for an application. This file lets developers set values that are specific to each environment without changing the main codebase. The .env file is very important for setting up a database, whether you're working on a local server like XAMPP or deploying to a production server.

Go to the root directory of your Laravel project to change the database connection. Inside this directory, you will find the .env file. If you cannot see it, make sure hidden files are enabled in your file explorer or code editor.

The .env file has private configuration information like the database name, username, password, and host. Be careful with this file at all times, and never put it in public repositories.

Step 2: Edit Laravel Database Configuration Settings

Once you locate the .env file, open it in your preferred code editor, such as VS Code, Sublime Text, or PHPStorm. Inside the file, look for the database configuration section. By default, it looks something like this:

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

Here is a screenshot with the database setting.

To change the Laravel database settings, just change these values to match your new database login information. For instance, if you are moving to a live hosting server, your host and login information will be different from what you use at home.

Save the file after you make changes to it. 

Step 3: Clear the Configuration Cache

Laravel may still use cached configuration values even after you change the .env file. That's why it's so important to clear the configuration cache. Your application might still connect to the old database if you don't do this step.

Open your terminal or command prompt, go to the directory where your Laravel project is stored, and type the following command:

php artisan clear config 

This Artisan command clears the configuration cache and makes Laravel read all of the settings from the .env file again. You might also want to run the following if your project uses cached routes or views:

Step 4: Test the New Database Connection

Once you update the database settings and clear the configuration cache, it is time to test the connection. The easiest way to verify your new Laravel database configuration is by running the migration command.

php artisan migrate

If the connection is successful, Laravel will run the migrations without errors. If there is an issue, you will see a database connection error message.

Conclusion

Every Laravel developer needs to know how to change the database settings in Laravel. You can easily switch databases without changing your application code by editing the .env file, updating the right database credentials, clearing the configuration cache, and testing the connection with migrations.

Always remember to use the right database information and clear the cache after you make changes. Following these steps will help you avoid common database connection problems and keep your Laravel app running well.