MySQL 개발환경 구축

1. Database Download(MySQL Community Server 5.5.28)

(http://dev.mysql.com/downloads/mysql/)

2. Installation

Character-Set: UTF-8

3. Environmental Variables Setting

Path / C:\Program Files\MySQL Server5.5\bin;

4. Windows Service Registration

cmd > cd C:\Program Files\MySQL Server5.5\bin > mysqld --install

5. MySQL Connector/J Download

- MySQL Connector/J .zip파일 다운로드(http://dev.mysql.com/downloads/connector/j/) > 압축해제

- mysql-connector-java-5.1.22-bin.jar파일을 C:\Program Files\Java\jre7\lib\ext 와 C:\Program Files\Apache Software Foundation\Tomcat 7.0\lib 에 각각 복사

6. MySQL Workbench

Microsoft Visual C++ 2010 Redistributable과 .NET Framework 4가 추가적으로 필요

MySQL Management Tools

• MySQL Workbench: MySQL 설치하면 자동으로 깔림
• HeidiSQL: http://www.heidisql.com/download.php
• MySQL-Front: http://www.mysqlfront.de/
• sqlyog: http://code.google.com/p/sqlyog/downloads/list
• Toad for MySQL: http://www.quest.com/common/registration.aspx?requestdefid=11781