407176
MySQL 5.0.45 + Windows XP sp2 설치 - 짧게
393869
2007-08-08T12:13:01Z
http://idodream.springnote.com/pages/407176
2007-08-08T11:50:45Z
<p style="MARGIN-LEFT: 1em"></p>
<p> 2007/07/20</p>
<p> </p>
<ol>
<li>MySQL 다운로드<br />
MySQL Community Server 5.0.45 <a href="http://dev.mysql.com/downloads/" title="http://dev.mysql.com/downloads/" class="external"><span style="COLOR: #ff7635">http://dev.mysql.com/downloads/</span></a> - (Windows Essentials (x86))<br />
mysql-essential-5.0.45-win32.msi<br />
</li>
<li>설치<br />
다운 받은 mysql-essential-5.0.45-win32.msi 파일을 더블 클릭하여 실행 시킨다.<br />
C:\MySQL\MySQL Server 5.0\ 에 설치.<br />
<br />
Configure the MySQL Server now 를 체크하면 설치 시 다음 설정을 바로 할 수 있다.<br />
<ol>
<li><span style="COLOR: rgb(0,0,255)">Configuration Type</span> : <span style="COLOR: rgb(142,142,142)">Detailed/Standard Configuration</span></li>
<li><span style="COLOR: rgb(0,0,255)">S</span><span style="COLOR: rgb(0,0,255)"><span style="COLOR: rgb(0,0,255)">erver Type</span></span> : <span style="COLOR: rgb(142,142,142)">Developer Machine(use low memory), Server Machine(use medium memory), dedicated MySQL Machine</span></li>
<li><span style="COLOR: rgb(0,0,255)">Database Usage</span> : <span style="COLOR: rgb(142,142,142)">Multifunctional Database(InnoDB+MyISAM), Transactional Database Only, Non-TransactionalDatabase Only(MyISAM)</span></li>
<li><span style="COLOR: rgb(0,0,255)">InnoDB Tablespace Settings</span> : <span style="COLOR: rgb(142,142,142)">c:\MySQL\Datafiles\</span></li>
<li><span style="COLOR: rgb(0,0,255)">Approximate number of concurrent connection</span> : <span style="COLOR: rgb(142,142,142)">Decision Support(DSS)/OLAP (20), Online Transaction Processing(OLTP) (500), Manual Setting</span></li>
<li><span style="COLOR: rgb(0,0,255)">Networking options</span> : <span style="COLOR: rgb(142,142,142)">Enable TCP/IP Networking (Port Number : 3306)</span></li>
<li><span style="COLOR: rgb(0,0,255)">Server SQL mode</span> : <span style="COLOR: rgb(142,142,142)">Enable Strict Mode</span></li>
<li><span style="COLOR: rgb(0,0,255)">Default character set</span> : <span style="COLOR: rgb(142,142,142)">Standard Character Set (latin1/English,West Europ), Best Support For Multilingualism(UTF8), Manual Selected Default Character Set / Collation (latin1,ascii,euckr,utf8)</span></li>
<li><span style="COLOR: rgb(0,0,255)">Windows options</span> : <span style="COLOR: rgb(142,142,142)">Install As Windows Service (Service Name : MySQL5045), Include Bin Directory in Windows PATH</span></li>
<li><span style="COLOR: rgb(0,0,255)">Security options</span></li>
<li style="list-style: none">: <span style="COLOR: rgb(142,142,142)">Modify Security Settings (root password, Enable root access fromtemote machines), Create An Anonymous Account<br /></span></li>
</ol>
</li>
<li>마침<br />
설치 후 저절로 configuration file(c:\MySQL\MySQL Server 5.0\my.ini) 을 만듦.<br />
또 "C:\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\MySQL\MySQL Server 5.0\my.ini" MySQL5045 로 서비스에 등록 된 것을 볼 수 있다.</li>
<li>접속<br />
명령 프롬프트나 도스창에서 "c:\MySQL\MySQL Server 5.0\bin\mysql.exe" -uroot -p 를 입력하면 root 라는 아이디로 접속할 수 있다. (종료는 quit 또는 \q)<br />
<br />
C:\><span style="COLOR: #ff0000"><span style="COLOR: #ff0000"><span style="COLOR: #ff0000">"c:\MySQL\MySQL Server 5.0\bin\mysql.exe" -uroot -p<br /></span></span></span>Enter password: <span style="COLOR: #ff7635"><span style="COLOR: #ff0000">여기서 비밀번호 입력</span></span><br />
<br />
mysql> <span style="COLOR: #ff0000">show databases;</span><br />
+--------------------+<br />
| Database |<br />
+--------------------+<br />
| information_schema |<br />
| mysql |<br />
| test |<br />
+--------------------+<br />
7 rows in set (0.19 sec)<br />
<br />
mysql><span style="COLOR: #ff0000">quit</span><br />
<br />
C:\></li>
</ol>
<p>.</p>
http://idodream.myid.net/
http://idodream.myid.net/
38