MySQL 수동설치

1. MySQL 다운받기 

경로 : http://dev.mysql.com/downloads/mysql/5.1.html

2. 압축풀기

7z.exe x mysql-noinstall-5.1.37-win32.zip -oC:\

3. C:\Windows\mysql.ini 작성

[mysqld]
# set basedir to your installation path
basedir=C:\mysql-5.0.37-win32
# set datadir to the location of your data directory
datadir=C:\mysql-5.0.37-win32\data

4. 윈도우 서비스에 등록 (관리자 권한으로 실행)

C:\mysql-5.1.37-win32\bin>mysqld.exe --install MySQL --defaults-file=%WINDIR%\mysql.ini
Service successfully installed.

5. 버전확인

C:\mysql-5.1.37-win32\bin>mysqladmin version
mysqladmin  Ver 8.42 Distrib 5.1.37, for Win32 on ia32
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.37-community
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
Uptime:                 52 sec

Threads: 1  Questions: 1  Slow queries: 0  Opens: 15  Flush tables: 1  Open tabl
es: 8  Queries per second avg: 0.19

6. 데이터베이스 목록 조회

C:\mysql-5.1.37-win32\bin>mysqlshow
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| test               |
+--------------------+