Setup New Database with User

startdb.md

Setup New Database with User

MySQL

SHOW DATABASES;

CREATE DATABASE IF NOT EXISTS vapor_database
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;

CREATE USER 'vapor_username'@'localhost' IDENTIFIED BY 'vapor_password';
GRANT ALL PRIVILEGES ON vapor_database.* TO 'vapor_username'@'localhost';
FLUSH PRIVILEGES;

PostgreSQL

CREATE USER vapor_username;
ALTER USER vapor_username WITH PASSWORD 'vapor_password';
CREATE DATABASE vapor_database;
GRANT ALL PRIVILEGES ON DATABASE vapor_database TO vapor_username;
\c vapor_database
GRANT ALL ON SCHEMA public TO vapor_username; 

Prior to Postgres 15

CREATE USER vapor_username;
CREATE DATABASE vapor_database;
GRANT ALL PRIVILEGES ON DATABASE vapor_database TO vapor_username;
ALTER USER vapor_username WITH PASSWORD 'vapor_password';

MongoDB

use vapor_database
db.createUser({
	user: "vapor_username",
	pwd:  passwordPrompt(), // or cleartext password
	roles: [ { role: "readWrite", db: "vapor_database" } ]
})

use sports-etl-data
db.createUser({user: "user", pwd: "26...508", roles: [{ role: "dbOwner", db: "sports-etl-data" }]})

If no root/admin user exists, create with:

use admin
db.createUser({
	user: "root",
	pwd: '74cc1c60799e0a786ac7094b532f01b1',
	roles: [
		{ role: "userAdminAnyDatabase", db: "admin" },
		{ role: "readWriteAnyDatabase", db: "admin" }
	]
})