Question

我已在我的窗户——x64台膝上型计算机上安装了SQL版本11.1,Im能够通过pgAdmin4进入数据库。

然而,我可以通过迅速指挥进入数据库。它要求密码,但不允许进入。我已尝试重新安装软件,但还是没有工作。此外,我还增加了双倍和双倍;平衡双倍通向变数。请提出咨询意见。

www.un.org/spanish/ecosoc 错误信息: 用户口号认证失败

Answer 1

You can enter your password just fine. The password does not show up in the terminal when you type it, but that is for security reasons. Just try typing your password out, and hitting enter.

If your password was entered correctly, the action will continue. If your password was spelled wrong, it will prompt you to enter it again. It worked for me.

Answer 2

当你开始上台时,你就把你拖到你身上。因此,在通过终点站与psql连接时,你必须具体说明用户(在这种情况下是邮政)。因此,从您的终点站来看,您将打上以下几类:psql <database, 你希望与“>”连接起来;及lt; postgres或你希望登录的任何邮政用户;。之后,这又使你打上密码:如果没有任何密码或密码,就进入。然后,它应当把你与纸浆连接起来。

其他工作方向是开普车。

Answer 3

I ve just installed PostgreSQL and had the same issue. Know that it simply hides your password so don t worry. Your keyboard doesn t block. Even if you don t see yourself typing, put your password and hit enter: Check this link to my cmd

Answer 4

由于你收到<条码>法证:密码认证对用户abc的错误没有效力,这意味着你对指定用户的密码有误。

如果你不知道密码,你可以把密码记录成作为超级用户的PSQL,并改变<代码>abc的密码。你可以这样做:

>>> psql -U postgres
postgres=# ALTER USER abc PASSWORD  myPassword ;

Answer 5

邮局的违约用户是邮政,无密码,因此,在座,由于你必须进入密码,你无法进入。

你们必须使用Psql客户的某种指挥,如:psql-U postgres(我不了解窗户!)和公正的密码来打上你的密码。

Answer 6

PasswordEnteredIMG

它只是隐藏着已进入密码的内在机制。仅仅进入正确的密码,如果它没有显示你的打字进展,那么它就会奏效,对我来说,会做得很好。

Answer 7

Just type your password and hit enter, PSQL hides the password

Answer 8

i have this error i solve this by following method: first i enter my password in pgadmin and later enter in psql

Answer 9

What @Madao mentioned is correct:

“你可以打上你的密码。密码在座标时没有显示,而是出于安全原因。只是试图打上你的口号,并打入。

如果你的密码正确无误,就将继续采取行动。如果你的口号被打错,就会促使你再次进入。它为我工作。

However this was NOT working for me when I run the SQL Shell (psql) normally from the Windows Start menu. I had to run the SQL Shell (psql) as an administrator and then the SQL Shell (psql) worked for me.

因此,对于面临这一问题的其他人来说,采取下列行动:

Windowsstart menu中的“psql”类型。
When you see "SQL Shell (psql)" in the start menu, right click it and select "Open File Location".
Once in the file location, right click on the "SQL Shell (psql)" shortcut and then select "Run as Administrator".
Once you open "SQL Shell (psql)" as an administrator enter the requested information below (remember you wont see the password even though you re entering it):

Server [localhost]: localhost
Database [postgres]: Name_of_your_Database
Port [5432]: 5432
Username [postgres]: postgres
Password for user postgres: your_password

If you entered the above correctly you should see the below output in the shell:

psql (14.2)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

Your_Database_Name=#

Answer 10

Don t worry, Its hide the password... Just Type your correct password into the field of password..It will automatically connect to your database. Thanks

Answer 11

第一类

psql -U postgres

在这样之后,你在开始和进入媒体时所写的口号。密码隐藏在正确的密码上。这为我工作。

友情链接