study/db2 mysql jpa connect dependency implementation 'org.springframework.boot:spring-boot-starter-data-jpa' implementation 'mysql:mysql-connector-java' application.properties spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/board?useSSL=false&allowPublicKeyRetrieval=true&useUnicode=true&serverTimezone=Asia/Seoul spring.datasource.username=boardAdmin spring.dat.. 2022. 10. 1. oracle sql 새로운접속 생성, 권한 , 시퀀스 생성 일단 시스템으로 접속 후 create user 접속이름 identified by 비밀번호; 권한 SELECT * FROM all_users; grant connect,dba,resource to user01; GRANT CREATE SESSION TO user01; GRANT CREATE TABLE TO user01; GRANT DROP ANY TABLE TO user01; GRANT CREATE SEQUENCE TO user01; 시퀀스 CREATE SEQUENCE Comments_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; 2022. 6. 16. 이전 1 다음 728x90