January 26

База данных, пользователь, права

PostgreSQL:

CREATE USER 'username' WITH PASSWORD 'abcdef123';
CREATE DATABASE 'database' WITH OWNER 'username' TEMPLATE='template0' ENCODING='utf8';
GRANT ALL PRIVILEGES ON DATABASE 'database' TO 'username';

MySQL:

CREATE USER 'username'@'%' IDENTIFIED BY 'password';
CREATE DATABASE 'database';
GRANT ALL PRIVILEGES ON 'database'.* TO 'username'@'%';