Create Database in MySQL/MariaDB

The easiest way to create a database is with the console, also shipped with the databases
mysql (Linux/Mac) or mysql.exe (Windows).

The installation of MySQL/MariaDB contains a subdirectory bin/, it contains:

bin/mysqld or bin/mysqld.exe

Starts MySQL/MariaDB

bin/mysql or bin/mysql.exe

Console for execution of commands (also 'create database')

The console also needs the login information for the user that is allowed to create databases (Default: root).

Using
bin/mysql -u root
or
bin/mysql -u root -p

you start the console and log in as the user root. The Parameter -p is necessary if a password is set for the user. In this case you will be asked for the password.

Now using this command you can create a database named datenbank1:

mysql> create database datenbank1;

The creation of the database is finished. If InnoList is accessing the database with a different database user, the access/right to add tables for the database needs to be granted to the database user.