Jumat, 31 Oktober 2008

Login di PHPPGADMIN

Salam,

Tidak bisa login saat mengakses phppgadmin-8.3? Tenang tidak perlu panik. Saatnya membuat user account.

Login dulu sebagai root
$ su

Lakukan insialisasi terlebih dahulu

zara:/home# su - postgres
postgres@zara:~$ psql template1
Welcome to psql 8.3.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template1=# ALTER USER postgres PASSWORD 'zulali';
ALTER ROLE
template1=# \q
postgres@zara:~$ exit
logout


Buat penggna

postgres@zara:~$ createuser -DRS za

postgres@zara:~$ psql template1
Welcome to psql 8.3.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template1=# ALTER USER za PASSWORD 'ZULALI';
ALTER ROLE
template1=# \q
postgres@zara:~$ exit
logout