Различия

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

--- rdbms:create_user [2023/04/05 19:57] – chek
+++ rdbms:create_user [2026/01/21 22:39] (текущий) – [Mysql] chek
@@ Строка 1: / Строка 1: @@
-=====Postgresql=====\
+===== Postgresql =====
-##sudo -u postgres psql\
+CREATE database mydb;\\
-postgres=# CREATE database mydb;\
+CREATE user myuser with encrypted password 'mypass';\\
-postgres=# CREATE user myuser with encrypted password 'mypass';\
+GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;\\
-postgres=# grant all privileges on database mydb to myuser;\
+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'@'%' 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'@'%';