Toad for MySQL 설치

Toad for MySQL 설치

MySQL용 토드

• 프리웨어

1 다운로드

• http://www.quest.kr/common/registration.aspx?requestdefid=11781 접속
• 이름 등 각종 정보 입력
• [V] 본인은 계약서를 읽었고, 이에 동의합니다.
• [로그인] 클릭
• [Toad for MySQL Freeware] 클릭하여 Quest_Toad-for-MySQL-Freeware_63.exe 다운로드

2 설치

• Quest_Toad-for-MySQL-Freeware_63.exe 실행
• "Welcome to ..." --- [Next >]
• "License Agreement Page 1" --- [Next >]
• "License Agreement Page 2" --- (O) I accept the license agreement --- [Next >]
• "User Infomation" --- [Next >]
• "Destination Folder" --- [Next >]
• "Register File Extensions" --- [Next >]
• "Updating System" --- 자동 설치 진행 --- "Toad is optimizing ..."
• "Toad ... successfully installed" --- [ ] Launch Release Notes. --- [Finish]
• "Configuration Wizard" --- (O) Default --- [Finish]

3 접속 설정

• File --- New --- Connection
• "Create New Connection" --- Host: 서버주소 --- User: 사용자명 --- Password: 패스워드 --- [V] Save password --- [Save]

왼쪽 Connection Manager에 등록되었다.

• 등록된 접속정보를 더블클릭하면 접속된다.

4 환경설정

• Tools --- Options...
• ( Environment - General )

Action to perform on startup: Open editor

[ ] Play Toad sound on startup

[ ] Check for updates on startup

[ OK ]

5 같이 보기

• MySQL 워크벤치
• MySQL 외부 접속 허용
• MySQL SSH 터널링
• MySQL 캐릭터셋 utf8 설정 (Toad for MySQL 엑셀 import 한글 깨짐 해결)
• phpMyAdmin
• DBeaver