Databases are their own environment and can create users and access independent of the host system
CREATE USER nicole
CREATE USER nicole IDENTIFIED BY P@s%w0rd
CREATE USER IF NOT EXISTS nicole IDENTIFIED BY P@s%w0rd
The Create User command has a few basic options shown here