Sarathlal N

Create database, user & allow access - PostgreSQL

Connect to PostgreSQL server instance

sudo -u postgres psql

Create Database

CREATE DATABASE database_name;

Connect to Database

\c database_name;

Create User

CREATE USER user_name WITH PASSWORD 'user_password';

Grant privileges

GRANT ALL PRIVILEGES ON DATABASE "database_name" to user_name;

Delete database

DROP DATABASE IF EXISTS database_name;

Looking for a skilled WordPress/WooCommerce developer? I'm currently available for freelance, contract, or full-time remote opportunities! Let's create something amazing together. Send me a quick message, and I'll respond within 24 hours!

Recent Posts

  1. REST API Methods Explained with Best Practices for Building Clean and Secure APIs
  2. My 28-Day Plan to Master Modern WordPress Development Using AI Tools
  3. Scaling WordPress - How Custom Database Tables Solve the Post Meta Bottleneck
  4. WordPress Transients Explained - A Developer's Guide to Site Performance
  5. Behind the Click - The Hidden Journey of Your Web Requests

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.