-
Notifications
You must be signed in to change notification settings - Fork 1
3. MySql 서버 접속 방법 (IDE & code)
HyoJung Yoon edited this page Jul 27, 2023
·
5 revisions
필요한 public ip, rasa key file, user name, password는 모두 노션 application.yaml 관리
페이지에 있습니다
-
Database
>DataSource
>MySql
선택
![스크린샷 2023-07-16 오후 5 59 28](https://private-user-images.githubusercontent.com/77730511/253794753-9108ffb0-acb6-4444-a84c-3a59194a43f7.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk3NTkwNzEsIm5iZiI6MTcxOTc1ODc3MSwicGF0aCI6Ii83NzczMDUxMS8yNTM3OTQ3NTMtOTEwOGZmYjAtYWNiNi00NDQ0LWE4NGMtM2E1OTE5NGE0M2Y3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjMwVDE0NDYxMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTYxMmFmOTNjN2MzNDRmNjhmOWUxMTlmNzliYjdhOTQzZGFkNDAyZTU3NmZhMDI0NGE4NzQyM2UyNzg0MDg1MDcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.b0tIiQCFVk-3D1pOa9nLsxVwGBCAoOI1NJC_OaF6Ss0)
-
SSH/SSL
탭 > use SSH Tunnel >...
선택 > host, username, port 작성, private key file에서 키 파일 선택
![스크린샷 2023-07-16 오후 6 02 46](https://private-user-images.githubusercontent.com/77730511/253794936-9402820f-4ee5-487c-b619-2eb0849017a2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk3NTkwNzEsIm5iZiI6MTcxOTc1ODc3MSwicGF0aCI6Ii83NzczMDUxMS8yNTM3OTQ5MzYtOTQwMjgyMGYtNGVlNS00ODdjLWI2MTktMmViMDg0OTAxN2EyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjMwVDE0NDYxMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWNhZjZiNjhkMzMzYmI1ZmNjODkwOTVkMDllZmEyOGNlYzdiNGJhZTNhYTMzMmY1MjY2ZWViOWQ4OTgzNTY1YjImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.MpxaxntJj_jVGQRekx9xr7HPeMrK3EGBAPz1J3jPF80)
![스크린샷 2023-07-16 오후 6 03 59](https://private-user-images.githubusercontent.com/77730511/253794956-30fa4320-ed33-465b-86a2-9e47c8780389.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk3NTkwNzEsIm5iZiI6MTcxOTc1ODc3MSwicGF0aCI6Ii83NzczMDUxMS8yNTM3OTQ5NTYtMzBmYTQzMjAtZWQzMy00NjViLTg2YTItOWU0N2M4NzgwMzg5LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjMwVDE0NDYxMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWY2OGEyYTY3MjM0ZTFlNGUxOTkzMzg1YTc4ZGIxYjhmYjJiNzZkMmE3OWYzMWY0ZDdlZjk0YTUyNzk2ZDZkYTImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.MHnTjvdw8pIoMHTX82xmpfaM07FN4Raxs8NYQ6clb44)
- port의 경우 ssh로 접속하므로 22, private key는 bastion server를 열 때 만들어둔 키 파일 사용
- 접속 확인
![스크린샷 2023-07-16 오후 6 04 18](https://private-user-images.githubusercontent.com/77730511/253794958-d31bbf76-a575-4b26-9602-f9c986ab2c32.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk3NTkwNzEsIm5iZiI6MTcxOTc1ODc3MSwicGF0aCI6Ii83NzczMDUxMS8yNTM3OTQ5NTgtZDMxYmJmNzYtYTU3NS00YjI2LTk2MDItZjljOTg2YWIyYzMyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjMwVDE0NDYxMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTk5ZTY5MThjMmI5YzU5OTA0NmIxZTVjYzVhN2NmOTZkNWUzNzJmNGI3MzQ5OTI3NDExNjM5MTdlMzI2NzliOWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.GTOEBuXQGnw-tze-G4j6V9pMaf2PKhEl0zIhtmLz2Cc)
-
General
탭에서 host, port, user, password 작성 (database는 비워두면 default 설정된 것으로 접속)
![스크린샷 2023-07-16 오후 6 09 28](https://private-user-images.githubusercontent.com/77730511/253795191-7dbf71ed-54ca-4f5b-9b88-bd670a645180.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk3NTkwNzEsIm5iZiI6MTcxOTc1ODc3MSwicGF0aCI6Ii83NzczMDUxMS8yNTM3OTUxOTEtN2RiZjcxZWQtNTRjYS00ZjViLTliODgtYmQ2NzBhNjQ1MTgwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjMwVDE0NDYxMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTk2YmIyYzkwZDk0NTRhMDk1NjFlYzAzYzQzMDgwNDJiYzY3YTQyODFkZTcxMDgyNWE0ZTNjMjMwYjcyY2Y0YzcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.qEwRrKT41IspDgp1tpzIaCNSDwbBJ9h7HiyYt8X0RY4)
- test connection 확인
![스크린샷 2023-07-16 오후 6 11 53](https://private-user-images.githubusercontent.com/77730511/253795294-494bca9f-e97d-47b6-8548-fc5d6d2c2e6a.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk3NTkwNzEsIm5iZiI6MTcxOTc1ODc3MSwicGF0aCI6Ii83NzczMDUxMS8yNTM3OTUyOTQtNDk0YmNhOWYtZTk3ZC00N2I2LTg1NDgtZmM1ZDZkMmMyZTZhLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjMwVDE0NDYxMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTNhYzkyYTk4ZDNmOWQxMjk4MDIxNzNhYmZkMDJjYjU2ZDViZWI4NDU0YzZlZmVjYzgzYzljMWZiODIzZjM4NTAmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.KVopzUs3NEso4tw-QYsx_XXcDZd1KouYpQXRnI_WfDc)
spring:
datasource:
driver-class-name: {드라이버 패키지이름}
username: {mysql 유저이름}
url: jdbc:mysql://localhost:[forwardedPort]/{db이름}
password: {mysql 유저 패스워드}
ssh:
remote_jump_host: {Bastion server public ip}
ssh_port: {설정한 ssh port 번호}
user: {bastion server user 이름}
private_key: {프로젝트 내 private key 위치}
database_port: {bastion server에서 오픈한 데이터베이스 포트번호}
spring:
datasource:
driver-class-name: {드라이버 패키지이름}
username: {mysql 유저이름} <<< 확인
url: {mysql url}/{db이름}
password: {mysql 유저 패스워드} <<< 확인
ssh:
remote_jump_host: {Bastion server public ip} << 확인
ssh_port: {설정한 ssh port 번호, 보통 22}
user: {bastion server user 이름} << 확인
private_key: {프로젝트 내 private key 위치} << 확인
database_port: {bastion server에서 오픈한 데이터베이스 포트번호, 보통 3306}
- bastion server 접속
ssh -i "{private key 이름}" {ssh.user}@{bastion server public ip}
- mysql 접속
mysqlsh --sql -u {username} -h {oracle mysql public ip}
- mysql 로그인
Please provide the password for '{username}@{oracle mysql public ip}': {password}