수동으로 MySQL 설치

수동으로 MySQL  설치하는 방법입니다.

 

http://www.mysql.org/downloads/mysql/5.0.html#win32
 
실행

cd C:\mysql-5.0.37-win32\bin

C:\mysql-5.0.37-win32\bin>mysqld.exe

 

설치 확인

cd C:\mysql-5.0.37-win32\bin

C:\mysql-5.0.37-win32\bin>mysqladmin version
mysqladmin  Ver 8.41 Distrib 5.0.37, for Win32 on ia32
Copyright (C) 2000-2006 MySQL AB
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.0.37-community
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
Uptime:                 43 sec

Threads: 1  Questions: 1  Slow queries: 0  Opens: 12  Flush tables: 1  Open tabl
es: 6  Queries per second avg: 0.023

 

mysqlshow

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

C:\mysql-5.0.37-win32\bin>mysqlshow test
Database: test
+--------+
| Tables |
+--------+
+--------+

 

MY_DB라는 데이타베이스 생성

C:\mysql-5.0.37-win32\bin>mysqladmin -uroot create MY_DB

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

 

중지

C:\mysql-5.0.37-win32\bin>mysqladmin -u root shutdown

 

PATH 에 추가

C:\mysql-5.0.37-win32\bin

 

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

 

NT 서비스 등록

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

 

NT 서비스 제거

C:\mysql-5.0.37-win32\bin>mysqld-nt.exe --remove
Service successfully removed.