Skip to main content

How to create database and user in postgress databse

Tech Easy Solutions

sudo -u postgres createuser user01;
$ sudo -u postgres createdb userdb;
$ sudo -u postgres psql
psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
Type "help" for help.

postgres=# alter user user01 with encrypted password 'user01';
ALTER ROLE
postgres=# grant all privileges on database userdb to user01;
GRANT
postgres=# \q


database :userdb
user : user01
passworrd : user01

Comments

Post a Comment

Popular posts from this blog

Connection Information To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Tech Easy Solutions Connection Information To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.  WordPress 5.2.3 hosted on Linux server  need file permission  sudo chown -Rf www-data.www-data  /www/html/worpdressdir change in wp-config
3 comments
Read more

How to delete Torrent power account

Sanjay Tech solutions 3 easy tips to delete torrent power account  Step 1 : login in to your account Step 2 : click on more profile settings Step 3 : you see red button with deactivate account click then enter your password Your account deactivate 
Post a Comment
Read more

Shopify fully custom contact section block on home page

Tech Easy Solutions Shopify fully custom contact section block on home page <section class="contact-information" >       <!--<div class="left-shape">         <img src="images/left-shape.png" class="img-fluid">       </div>-->       <div class="container c-container">         <div class="row">           <div class="col-lg-6 col-md-6 col-sm-12 col-12">             <div class=" contact-us">                         {% form 'contact' %}                       {% if form.posted_successfully? %}                        <center> <p class="note form-success">                   ...
Post a Comment
Read more