Cara reset password user postgres di PostgreSQL

masuk sebagai user postgres dengan perintah su – postgres

edit konfig pg_hba.conf

postgres@coderiver:/opt/framework-3.6.0/postgresql/bin$ vim ../data/pg_hba.conf

ganti:

# "local" is for Unix domain socket connections only
local   all         all                               md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5

menjadi:

How to set or reset password mysql on Ubuntu

reset

I’ve was succesfully install mysql on my friends machine . After do that i need set new password for replace balnk passsword. This post is tiny psoting. So, this not recommanded for advanced user . ok.

sometimes, after fresh installation i use command like this to set new password root on mysql :