SQL (Structured Query Language) is the standard language for managing relational databases. To create a database, you must have a database management system (DBMS) installed, such as MySQL, PostgreSQL, or SQLite, and apropriate privileges, typical administrative or database creation rights.

Connect to the database server using a command-line client or graphical tool. For MySQL, use the command:

mysql -u user_account -p

Replace user_account with your username, and enter the password when prompted.

Once connected, create a database with the CREATE DATABASE statement. For example, to create a database named app_data:

CREATE DATABASE app_data;

Optionally, specify character sets and collations during creation to handle different languages and special characters. For instance, to set UTF-8 encoding:

CREATE DATABASE app_data
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

After creating the database, end the session with QUIT or EXIT to disconnect from the server.