Инструменты пользователя

Инструменты сайта


rdbms:create_user

=====Postgresql=====
##sudo -u postgres psql
postgres=# CREATE database mydb;
postgres=# CREATE user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;
postgres=# ALTER ROLE myuser WITH LOGIN;##

=====Mysql=====
##CREATE USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
CREATE DATABASE mydb;
grant all privileges ON mydb.* TO 'myuser'@'localhost';##

rdbms/create_user.txt · Последнее изменение: chek

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki