How to create a database from the command line?

Question

I´m trying to create a data base from command line. My OS is centos and postgres version is 10.9.

sudo -u postgres psql createdb test

Password for user test:

Why asking me by user?

Answer 1

To create a Command-line in MySql you need to do some steps.

First, you need to change the user to Postgres :

su - Postgres

Then create User for Postgres

$ createuser testuser

Create Database

$ createdb testdb

Access the postgres Shell

psql ( enter the password for postgresql)

Provide the privileges to the postgres user

$ alter user testuser with encrypted password 'intellipaat';

$ grant all privileges on database testdb to testuser;