Различия

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

--- rdbms:create_user [2024/12/02 11:44] – 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 mydb;\\
-grant all privileges ON mydb.* TO 'myuser'@'localhost';##
+grant all privileges ON mydb.* TO 'myuser'@'%';