1. 다운로드(mysql-5.5.12-win32.zip)
http://dev.mysql.com/downloads/mysql/5.5.html
2. 압축풀기
압축폴더 : C:\mysql\mysql-5.5.12-win32
3. mysql.ini 파일 작성
경로 : C:\mysql\mysql-5.5.12-win32\mysql.ini
----------------------------------------------------
[mysqld]
port=2233
basedir=C:\mysql\mysql-5.5.12-win32
datadir=C:\mysql\mysql-5.5.12-win32\data
character-set-server=utf8
collation-server=utf8_general_ci
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
----------------------------------------------------
4. MySQL 서버 NT 서비스에 등록
- 명령 프롬프트 관리자 권한으로 실행
----------------------------------------------------
C:\Windows\system32>cd C:\mysql\mysql-5.5.12-win32
C:\mysql\mysql-5.5.12-win32>bin\mysqld.exe --install "MySQL 5.5.12" --defaults-file=C:\mysql\mysql-5.5.12-win32\mysql.ini
Service successfully installed.
----------------------------------------------------
5. 서비스 시작하기
----------------------------------------------------
C:\mysql\mysql-5.5.12-win32>
net start "MySQL 5.5.12"
MySQL 5.5.12 서비스를 시작합니다..
MySQL 5.5.12 서비스가 잘 시작되었습니다.
----------------------------------------------------
6. 데이터베이스 접속
----------------------------------------------------
mysql -h localhost -u root -P 2233
----------------------------------------------------
7. 데이터베이스 생성
----------------------------------------------------
mysql>
create database db_test;
Query OK, 1 row affected (0.00 sec)
----------------------------------------------------
8. 사용자 추가
----------------------------------------------------
mysql>
use mysql;
Database changed
mysql>
create user 'test'@'%' identified by 'test00';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to 'test'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql>
----------------------------------------------------
JDBC 접속 테스트
----------------------------------------------------
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBCConnectTest {
public static void main(String[] args) throws Exception {
Connection conn = null;
String jdbc_driver = "org.gjt.mm.mysql.Driver";
String jdbc_url = "jdbc:mysql://192.168.0.62:2233/db_test";
try {
Class.forName(jdbc_driver);
conn = DriverManager.getConnection(jdbc_url, "test", "test00");
System.out.println(conn);
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
----------------------------------------------------
NT 서비스 지우기
- 명령 프롬프트 관리자 권한으로 실행
----------------------------------------------------
C:\mysql\mysql-5.5.12-win32>bin\mysqld.exe --remove "MySQL 5.5.12"
Service successfully removed.
----------------------------------------------------
