blocks|key|555756|text|使用密码创建用户：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|555757|http://www.postgresql.org/docs/current/static/sql-createuser.html|offset|length|555758|CREATE+USER+name+[+[+WITH+]+option+[+...+]+]

where+option+can+be:

++++++SUPERUSER+%7C+NOSUPERUSER
++++%7C+CREATEDB+%7C+NOCREATEDB
++++%7C+CREATEROLE+%7C+NOCREATEROLE
++++%7C+CREATEUSER+%7C+NOCREATEUSER
++++%7C+INHERIT+%7C+NOINHERIT
++++%7C+LOGIN+%7C+NOLOGIN
++++%7C+REPLICATION+%7C+NOREPLICATION
++++%7C+CONNECTION+LIMIT+connlimit
++++%7C+[+ENCRYPTED+%7C+UNENCRYPTED+]+PASSWORD+'password'
++++%7C+VALID+UNTIL+'timestamp'
++++%7C+IN+ROLE+role_name+[,+...]
++++%7C+IN+GROUP+role_name+[,+...]
++++%7C+ROLE+role_name+[,+...]
++++%7C+ADMIN+role_name+[,+...]
++++%7C+USER+role_name+[,+...]
++++%7C+SYSID+uid|code-block|syntax|javascript|555759|然后授予用户对特定数据库的权限：|555760|http://www.postgresql.org/docs/current/static/sql-grant.html|555761|示例：|555762|grant+all+privileges+on+database+db_name+to+someuser;|555763|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|0|1T|0|0|0|0|0|1O|1|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|F|3|G|5|H|7|15|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|17|8|@]|9|@$D|18|E|19|1|1A]]|A|$]]|$1|O|3|P|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Q|3|R|5|H|7|1C|8|@]|9|@]|A|$I|J]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|C]]|Z|$5|V|W|X|A|$Y|N]]]]

blocks|key|339842|text|在CLI中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|339843|$+su+-+postgres+
$+psql+template1
template1=#+CREATE+USER+tester+WITH+PASSWORD+'test_password';
template1=#+GRANT+ALL+PRIVILEGES+ON+DATABASE+"test_database"+to+tester;
template1=#+\q|code-block|syntax|javascript|339844|PHP+(在本地主机上经过测试，它可以正常工作)：|339845|++$connString+=+'port=5432+dbname=test_database+user=tester+password=test_password';
++$connHandler+=+pg_connect($connString);
++echo+'Connected+to+'.pg_dbname($connHandler);|339846|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

From CLI:

<pre><code>$ su - postgres 
$ psql template1
template1=# CREATE USER tester WITH PASSWORD 'test_password';
template1=# GRANT ALL PRIVILEGES ON DATABASE "test_database" to tester;
template1=# \q
</code></pre>

PHP (as tested on localhost, it works as expected):

<pre><code> $connString = 'port=5432 dbname=test_database user=tester password=test_password';
 $connHandler = pg_connect($connString);
 echo 'Connected to '.pg_dbname($connHandler);
</code></pre>

I have installed PostgreSQL 8.4 on my CentOS server and connected to root user from shell and accessing the PostgreSQL shell.

I created the database and user in PostgreSQL.

While trying to connect from my PHP script it shows me authentication failed.

How do I create a new user and how to grant permissions to them for a particular DB?

How to create user for a db in postgresql?

身份验证

PostgreSQL

数据库

服务器

CentOS

我已经在我的CentOS服务器上安装了PostgreSQL 8.4，并从shell连接到根用户并访问PostgreSQL shell。我在PostgreSQL中创建了数据库和用户。当尝试从我的PHP脚本连接时，它显示身份验证失败。如何创建新用户以及如何授予他们对特定数据库的权限？

问如何在postgresql中为数据库创建用户？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在postgresql中为数据库创建用户？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在postgresql中为数据库创建用户？
EN