How to create mysql database

How to create a MySQL database

Step 1: Connect to the MySQL server

• Open the MySQL command line client, such as MySQL Workbench or command prompt.
• Connect to the MySQL server using the following command:

mysql -u 用户名 -p 密码

Step 2: Create the database

• UseCREATE DATABASECommand to create a database, the syntax is as follows:

CREATE DATABASE database_name;

• wheredatabase_nameis the name of the database you want to create.

Example:

CREATE DATABASE my_database;

Step 3: Select new database (optional)

• Create database, you need to switch to the new database to use it. Use theUSEcommand with the following syntax:

USE database_name;

Example:

USE my_database;

Step 4: Grant permissions (optional)

• If you need to grant other users access to the database, use theGRANTcommand with the following syntax:

GRANT <权限> ON database_name TO <用户名>;

• For example, to grant usermy_userall permissions to themy_databasedatabase, you can use the following command:

GRANT ALL ON my_database TO my_user;

Step 5: Refresh permissions

• After granting permissions, you need to use theFLUSH PRIVILEGEScommand to refresh the permissions:

FLUSH PRIVILEGES;

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