Различия

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

--- rdbms:create_user [2023/04/05 19:57] – 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';##