How to create a new database in laravel

Laravel is a web framework developed based on PHP because it provides many powerful tools and class libraries that allow developers to quickly implement web applications. Among them, creating a new database is a very important function in Laravel. This article will introduce how to create a database in Laravel.

There are many ways to create a new database in Laravel, the most commonly used of which is to use the Artisan command line tool. The Artisan command line tool can be started by running the command php artisan. It provides many functions, such as generating code, clearing cache, creating data migrations, generating controllers, etc. The following are the steps to create a database using the Artisan command line tool:

Steps

Step 1: Configure the database connection

Configuring the database connection in Laravel is very simple and only needs to be modified. .env file is enough. In the .env file, generally what you need to modify is the following items:

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

Among them, DB_CONNECTION is the database connection type, which is generally usedmysql is enough, DB_HOST and DB_PORT are the address and port number of the database server, DB_DATABASE is the name of the database to be created, DB_USERNAME and DB_PASSWORD are the username and password to connect to the database.

Step 2: Create a new database

After completing the configuration of the .env file, you can use the following command to create the database:

php artisan db:create

After executing this command, Laravel will automatically detect the configuration information in the .env file and create a new database in the MySQL database based on the information. If everything is OK, you will see output similar to the following on the terminal:

   Database created successfully.

Step 3: Check whether the new database was created successfully

You can use mysqlThe command line tool checks whether the new database is created successfully. Enter the following command in the command line:

mysql -u root -p

This command will use the root user to log in to the MySQL database. After successful login, enter the following command in the MySQL command line to detect whether there is a file named laravel Database:

show databases;

If everything is fine, you should see output similar to the following:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| laravel            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

Step 4: Use the new database

After completing the above steps After that, the new database is already available in the Laravel application. You can check whether the database connection information is successfully configured in the config/database.php file:

    'mysql' => [
        'driver' => 'mysql',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'laravel'),
        'username' => env('DB_USERNAME', 'root'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],

In the code, the env() function will read.env environment variables in the file to obtain the database connection information. If everything is correct, you can start using the new database in your Laravel application.

Summary

It is very simple to create a new database using the Artisan command line tool. You only need to follow the above steps to complete the configuration. Through this article, you have learned how to create a new database in Laravel. I believe this is very useful for developers who are learning Laravel. But please note that before creating a new database, please back up the data to avoid unexpected situations.

The above is the detailed content of How to create a new database in laravel. For more information, please follow other related articles on the PHP Chinese website!