create new user database sql server code example

Example 1: create user mysql

CREATE USER 'norris'@'localhost' IDENTIFIED BY 'password';

Example 2: mongodb create admin user for all databases

use admin
db.createUser({ user: "mongoadmin" , pwd: "mongoadmin", roles: ["userAdminAnyDatabase", "dbAdminAnyDatabase", "readWriteAnyDatabase"]})

Example 3: mysql create a user

CREATE USER 'someusername'@'localhost' IDENTIFIED BY 'password'