SQL CREATE USER

The following command will create a user named Alex with a password mySecretPass123.
PostgreSQL
MySQL
SQL Server
CREATE USER Alex WITH PASSWORD 'mySecretPass123';

SQL Server

Microsoft’s documentation on the difference between login and user.

Oracle

Oracle handles users, schemas, and databases differently. Here is a link to Oracle’s explanation of high level objects like schemas, databases, etc