PgAdmin无法连接PostgreSQL数据库:SCRAM认证未提供密码报错
PostgreSQL与Spring Boot连接报错:SCRAM认证要求但未提供密码
已在PgAdmin中创建服务器及数据库,尝试创建无密码服务器失败,仅能使用application.yml中配置的密码,但Spring Boot应用仍无法连接数据库,报错信息:
org.postgresql.util.PSQLException: The server requested SCRAM-based authentication, but no password was provided
相关配置与代码
application.yml 配置内容
spring: datasource: url: jdbc:postgresql://localhost:5432/jwt_security username: postgres password: Zygimantas1 driver-class-name: org.postgresql.Driver jpa: hibernate: ddl-auto: create-drop show-sql: false properties: hibernate: format_sql: true database: postgresql database-platform: org.hibernate.dialect.PostgreSQLDialect
User.java 实体类代码
package com.zygimantas.security.user; import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.Id; import jakarta.persistence.Table; import lombok.AllArgsConstructor; import lombok.Builder; import lombok.Data; import lombok.NoArgsConstructor; @Data //生成getter和setter方法 @Builder //提供对象构建器 @NoArgsConstructor //配合@Builder所需的无参构造 @AllArgsConstructor @Entity @Table(name = "_user") public class User { @Id @GeneratedValue private Integer id; private String firstname; private String lastname; private String email; private String password; }
已尝试参考论坛方案、新建数据库等操作,问题仍未解决。
内容的提问来源于stack exchange,提问作者Eiken
相关产品推荐
相关产品推荐

