Различия

Показаны различия между двумя версиями страницы.

--- rdbms:create_user [2023/02/06 11:28] – создано chek
+++ rdbms:create_user [2024/12/02 11:44] (текущий) – chek
@@ Строка 1: / Строка 1: @@
-=====Postgresql=====
+=====Postgresql=====\\
-##sudo -u postgres psql
+##sudo -u postgres psql\\
-postgres=# CREATE database mydb;
+postgres=# CREATE database mydb;\\
-postgres=# CREATE user myuser with encrypted password 'mypass';
+postgres=# CREATE user myuser with encrypted password 'mypass';\\
-postgres=# grant all privileges on database mydb to myuser;
+postgres=# grant all privileges on database mydb to myuser;\\
-postgres=# ALTER ROLE myuser WITH LOGIN;##
+postgres=# ALTER ROLE myuser WITH LOGIN;##\\
-=====Mysql=====
+=====Mysql=====\\
-##CREATE USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
+##CREATE USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';\\
-CREATE DATABASE vostrove_wiki;
+CREATE DATABASE mydb;\\
-grant all privileges ON vostrove_wiki.* TO 'vostrove'@'localhost';##
+grant all privileges ON mydb.* TO 'myuser'@'localhost';##