![]() Refer to Chapter 22 and Chapter 21 for information about managing users and authentication. Mungkin cukup sekian tutorial saya kali ini tentang cara membuat user / login baru. BONUS koneksi database postgresql dengan php. ![]() A role is an entity that can own database objects and have database privileges a role can be considered a user, a group, or both depending on how it is used. jika sudah silahkan klik ok maka secara otomatis pada list login roles muncul user yang anda buat tadi dan dapat anda gunakan untuk login. This is psql 8.0.3, the PostgreSQL interactive terminal. Description CREATE ROLE adds a new role to a PostgreSQL database cluster. Which leads to this output from the Postgresql 8.0.3 client: 4 Answers Sorted by: 68 Do it in a single statement within psql: CREATE ROLE username WITH LOGIN SUPERUSER PASSWORD 'password' e. Now, if for some reason none of those options work for you, you can get more help on the Postgresql client by typing this psql command: Psql -h myhost -d mydb -U myuser -W Postgres psql command help If for some reason you are not prompted for a password when issuing these commands, you can use the -W option, leading to these two command alternatives: If you need to log into a Postgres database on a server named myhost, you can use this Postgres login command: If you are logged into the same computer that Postgres is running on you can use the following psql login command, specifying the database ( mydb) and username ( myuser): Let's take a look at a few psql command line options you can use. To log into a Postgres database from the command line, use the psql command. Postgresql (Postgres) login FAQ: How do I log into a Postgres database from the command line?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |