mysql

mysql --host=адрес_сервера --port=порт --user=имя_пользователя --password

mysql --host=localhost --port=33060 --user=root --password

CREATE DATABASE mydatabase;
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypassword';
GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'%';
FLUSH PRIVILEGES;

CREATE TABLE users (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO users (name, age) VALUES ('John Doe', 30);

mariadb
docker run -d name mariadb -e MARIADB_ROOT_PASSWORD=your_password mariadb

docker exec -it mariadb mariadb -u root -p


postgres
docker run --name my-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres

docker exec -it my-postgres psql -U postgres

docker run --name my-postgres -e POSTGRES_PASSWORD=mysecretpassword -p 5432:5432 -d postgres

\l

CREATE DATABASE имя_базы_данных;
CREATE DATABASE имя_базы_данных OWNER имя_пользователя;

\c имя_базы_данных

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name VARCHAR(50) NOT NULL
);

CREATE USER newuser WITH PASSWORD 'password';

GRANT ALL PRIVILEGES ON DATABASE dbname TO newuser;


sudo -u postgres psql
ALTER USER username WITH PASSWORD 'новый_пароль';
Выход:
\q

INSERT INTO users (name, age)
VALUES ('John Doe', 30);


docker run -d --name mariadb -e MARIADB_ROOT_PASSWORD=12345 mariadb

docker exec -it mariadb mariadb -u root -p