티스토리 뷰

Database

수동으로 MySQL 설치

파란크리스마스 2007. 8. 1. 08:09
728x90
수동으로 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.
댓글
300x250
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2024/03   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
글 보관함