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. Scaling WordPress - How Custom Database Tables Solve the Post Meta Bottleneck
  2. WordPress Transients Explained - A Developer's Guide to Site Performance
  3. Behind the Click - The Hidden Journey of Your Web Requests
  4. Automating Code Linting with GitHub Actions for WordPress Plugins
  5. Comprehensive Guide to Linting PHP, JavaScript, and CSS in WordPress Plugins Using Composer

This article was published on

Your Questions / Comments

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