Различия

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

--- rdbms:create_user [2023/02/06 11:28] – создано 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'@'%';