MySQL설치 1067에러해결, 한글처리 :: 2007/04/27 02:01

/프로그래밍/DB

< MySQL 윈도우에 설치하기 >
*MySQL 4.0.18 버전(server & client)
1  우선 mysql-4.0.18-win 폴더안의 setup.exe를 실행시키세요.
 
설치 프로그램을 실행시키면 MySQL이 자동으로 설치 되구요,,
이때 설치폴더는 C:\\아래에 깔리도록 놔두세요. (그냥 무조건 OK만 누르시면 됩니다)
 
2  MySQL 설치프로그램을 실행해도 아직 서비스가 실행되지 않는 상태기 때문에 쓸 수가 없어요
cmd 창을 띄워서 c:\\mysql\\bin로 가셔서 'mysqld-nt --install'이라고 치세요
그러면 서비스를 시작할 수 있는데 이걸로 되는게 아니라 관리도구의 서비스를 열고 MySQL 서비스를 실행시켜야 합니다
자동이라고 되어 있어서 컴터를 재부팅 시키면 실행되게 되어 있어서 재부팅 하지 않으려면 직접 시작시켜야 하죠
 
3  MySQL이 제대로 설치되어 있나 확인하려면 cmd 창에서 c:\\mysql\\bin로 가셔서 mysql이라고 쳐보면 되요
잘 깔렸으면 mysql> 이렇게 될거에요
 
이것으로 MySQL 설치 끝-


< MySQL 암호 변경 및 암호 잊어버렸을 때 해결 >

1. mysql 서비스 중지 시키기
 관리자의 서비스 실행시켜서 중지 누르면 됩니다.

2. 'mysqld --skip-grant &'로 권한 check 없이 mysql 실행하기

3. 'mysql -u root mysql' 로 mysql 로 들어가기

4. root 암호 변경
update user set password=password('xxxxx') where user = 'root'

5. 권한 다시 reload 하기
flush privileges;

6. 종료
mysql>\q

7. 서비스 다시 살려 확인
8. mysql -u root -p   엔터


=== MySQL 1067 error 해결, 한글해결  ====

아래의 내용을 복사해서 c:\windows 안에  my.ini파일을 만든다
자신의 mysql경로를 제대로 지정해줘야함

[WinMySQLAdmin]
Server=c:/mysql/bin/mysqld-max.exe
[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data

[mysqld]
language=c:/mysql/share/korean/
default-character-set=euc_kr


[client]
default-character-set=euc_kr

[mysqldump]
default-character-set=euc_kr

c:\windows 에 저장하고


아래 실행

c:/mysql/bin>mysqld-max-nt --install


아래 실행하면 끝
net start mysql  

이올린에 북마크하기

Trackback(165) : Comment(12)
Trackback Address :: http://sooyong.net/tt/trackback/14

  • jugar casino gratis

    Tracked from ganancias casinos pagina web | 2008/05/01 05:37 | DEL

    Based on <a href=http://groups.google.es/group/juliana1520/web/poker-caribe-portales-internet>poker caribe portales internet</a> <a href=http://groups.google.com/group/shawntae5251/web/metro-pcs-ringtones>metro pcs ringtones</a>

  • les casinos en ligne

    Tracked from gioco d azzardo poker | 2008/05/01 17:49 | DEL

    Prendete <a href=http://groups.google.com/group/hayley4293/web/play-online-casino>play online casino</a> <a href=http://groups.google.com/group/amir8494/web/ringtones-for-verizon-wireless-phone>ringtones for verizon wireless phone</a>

  • ruleta online gratis

    Tracked from online poker software | 2008/05/02 04:51 | DEL

    Liebst <a href=http://blog.360.yahoo.com/blog-1Vwh8jQzeqo8JLPH8NAEJM8qiZnA3g--?p=143>texas holdem poker rule</a> <a href=http://blog.360.yahoo.com/blog-ARrPFQs6cakA8eUdiShsgTFPRw2K?p=5>money tree payday loan</a>

  • poker rules

    Tracked from poker online | 2008/05/02 23:24 | DEL

    Breathe <a href=http://blog.360.yahoo.com/blog-SuKoIFU1fqlO0hk80PY84Q--?p=60>poker online</a> <a href=http://groups.google.fr/group/tessa6115/web/regles-poker-holdem>regles poker holdem</a>

  • low interest payday loan

    Tracked from poker instant bonus | 2008/05/03 01:37 | DEL

    Based on <a href=http://blog.360.yahoo.com/blog-rrMFy.84KvPvpgQEXSgw9bjhDGHCFA--?p=17>reglas poker juego</a> <a href=http://stanze-da-poker-bbmt.blogspot.com/>stanze da poker</a>

  • free online texas holdem game

    Tracked from video poker machines | 2008/05/03 04:02 | DEL

    Through <a href=http://videopokermachinespfo.blogspot.com/>video poker machines</a> <a href=http://blog.360.yahoo.com/blog-CxRY4JsgK_MMtXfHsflv04xasJNABQ--?p=55>poker gratuito</a>

  • casino club poker

    Tracked from free keno | 2008/05/03 04:22 | DEL

    Lots of <a href=http://blog.360.yahoo.com/blog-pCYpT_E6eqKpXOx5FWrzj9aVUKA-?p=70>club player casino</a> <a href=http://blog.360.yahoo.com/blog-Tl41O3ozaa_39TxH.IeNqv6mQBRM?p=48>kostenlose casino online</a>

  • poker zum gratis downloaden

    Tracked from descargas juegos de poker | 2008/05/03 05:19 | DEL

    Offer <a href=http://groups.google.de/group/camille1027/web/texas-holdem-odds>texas holdem odds</a> <a href=http://groups.google.it/group/harris7978/web/american-roulette>american roulette</a>

  • strategia poker

    Tracked from géant casino | 2008/05/03 05:49 | DEL

    Come <a href=http://forumcasinoenligneselt.blogspot.com/>forum casino en ligne</a> <a href=http://tavolimultigiocatoripokerlbu.blogspot.com/>tavoli multigiocatori poker</a>

  • slots download

    Tracked from www poker gratis | 2008/05/03 05:53 | DEL

    One of <a href=http://blog.360.yahoo.com/blog-lKPYbKg8fqK8xk6HFKSL9TFxv6TL?p=42>online games poker texas</a> <a href=http://pokergamekostenlos-rbhg.blogspot.com/>poker game kostenlos</a>

  • 7 card stud hands

    Tracked from roulette game | 2008/05/03 13:03 | DEL

    Immer <a href=http://blog.360.yahoo.com/blog-FO_548I.Iv9KWt8pcxeSZ0W2g6c-?p=66>first premier bank credit card application</a> <a href=http://blog.360.yahoo.com/blog-WChWBBA5erOeh847Pmbn?p=34>regle poker casino</a>

  • video poker for winners

    Tracked from poker multijugador gratis | 2008/05/03 14:36 | DEL

    Avoid <a href=http://dueceswildvideopokerskv.blogspot.com/>dueces wild video poker</a> <a href=http://blog.360.yahoo.com/blog-Q2c_XEoic6Pm5.4WzICHp5zAT32c?p=53>los mejores casinos online</a>

  • 30 day payday loan

    Tracked from los mejores poker promociones | 2008/05/04 13:16 | DEL

    Bueno <a href=http://toppokerenlineasin.blogspot.com/>top poker en linea</a> <a href=http://blog.360.yahoo.com/blog-L7p5yoY_K_RrylY6ixLIfuId?p=53>online backgammon gambling</a>

  • online poker guide

    Tracked from fax instant loan no payday | 2008/05/04 17:15 | DEL

    Cher <a href=http://groups.google.fr/group/rushi5911/web/poker-en-ligne-sur-mac>poker en ligne sur mac</a> <a href=http://blog.360.yahoo.com/blog-L4vgvyg8erTkz50mV2dyo.yrYgIdIA--?p=62>casino blackjack gratuites</a>

  • slotmachine spielen

    Tracked from 7 card stud tips | 2008/05/04 19:46 | DEL

    I am <a href=http://blog.360.yahoo.com/blog-caGFYuU8LP78.mUaHn7YtR.UPEjZNQ--?p=28>deutsches online poker</a> <a href=http://blog.360.yahoo.com/blog-Y..K0QkherPoZeSDThM4xHQh0w--?p=77>slotmachine spielen</a>

  • holdem poker tipps

    Tracked from casino online roulette | 2008/05/05 00:00 | DEL

    Why <a href=http://blog.360.yahoo.com/blog-xE1QG109cqQkOPD379Hnd2J2Kg--?p=76>business card credit find small</a> <a href=http://echte-casinospiele-vmy.blogspot.com/>echte casinospiele</a>

  • descargar juego de casino

    Tracked from ruleta americana web | 2008/05/05 16:13 | DEL

    Si <a href=http://metodos-ganar-ruleta-wpws.blogspot.com/>metodos ganar ruleta</a> <a href=http://ruleta-americana-webumk.blogspot.com/>ruleta americana web</a>

  • streap poker

    Tracked from come giocare a poker | 2008/05/05 19:43 | DEL

    Elegir <a href=http://blog.360.yahoo.com/blog-PSMqsqA7LvGZKZ3GzH0OEiBhkUwx1A--?p=32>strip poker game</a> <a href=http://groups.google.fr/group/michele6066/web/jouer-poker-online>jouer poker online</a>

  • wal mart credit card application

    Tracked from come giocare poker | 2008/05/05 22:42 | DEL

    Quite <a href=http://blog.360.yahoo.com/blog-HwuTGKs_daf.te.8_YYfcC6v847VGQ--?p=65>card consolidation credit uk</a> <a href=http://blog.360.yahoo.com/blog-yelB2Ewhfr_Ei.zPtrMgTLFePuc-?p=74>bad card credit visa</a>

  • www casino online

    Tracked from wo kann man poker spielen | 2008/05/06 01:45 | DEL

    In particular <a href=http://blog.360.yahoo.com/blog-6wT.O8M6fq9T4YLCNraSbU10?p=5>play slots online</a> <a href=http://groups.google.de/group/corrielia874/web/online-poker-startguthaben>online poker startguthaben</a>

  • online poker review

    Tracked from multiplayer video poker | 2008/05/06 04:14 | DEL

    More than one of <a href=http://blog.360.yahoo.com/blog-WqKLyDY9eqvz3CWVrxxq0cu_DcYzzw--?p=14>gioco video poker gratis</a> <a href=http://blog.360.yahoo.com/blog-ofNyoyw1cqKhZ6jbAW8O4ePpo3r9ng--?p=56>24 ringtones</a>

  • internet poker ohne download

    Tracked from poquer poquer | 2008/05/06 04:46 | DEL

    As the <a href=http://blog.360.yahoo.com/blog-VWZUylgwaaE3pvtuywtTsYLYUwWyHw--?p=29>party poker bonus code</a> <a href=http://blog.360.yahoo.com/blog-D1G3wvshfqeHeFfe._kNMrnwhQ--?p=31>euro casino</a>

  • bad credit gas card

    Tracked from telecharger jeux casino | 2008/05/06 11:37 | DEL

    Before that <a href=http://blog.360.yahoo.com/blog-16bAT9A8erQDzQ9cVcPI7gd9Iymi?p=203>cash advance loan illinois</a> <a href=http://blog.360.yahoo.com/blog-RpZWwEA6aaNrpl72y0Ft5nEf?p=37>internet credit card processing services</a>

  • motorola razr ringtones v3

    Tracked from online casino costa rica | 2008/05/06 12:14 | DEL

    Doesn''t <a href=http://blog.360.yahoo.com/blog-PCE8OoY6LKcCebMb3c.ZFRoViKPlUA--?p=22>best online casino gambling</a> <a href=http://online-spiele-roulettevllt.blogspot.com/>online spiele roulette</a>

  • poker frei spielen

    Tracked from poker 50 gratis | 2008/05/06 12:20 | DEL

    Heutzutage <a href=http://onlinepokersoftware-deak.blogspot.com/>online poker software</a> <a href=http://pokergratis-try.blogspot.com/>poker 50 gratis</a>

  • poker downloaden

    Tracked from online poker free | 2008/05/06 15:35 | DEL

    Similarly <a href=http://groups.google.de/group/dena8027/web/poker-2-spielen>poker 2 spielen</a> <a href=http://secured-credit-card-application-kau.blogspot.com/>secured credit card application</a>

  • download free ringtones wwe

    Tracked from card credit debt help online | 2008/05/06 23:26 | DEL

    When <a href=http://blog.360.yahoo.com/blog-lOAODLg3L_VpI1TtPuxuhPFqHxmD?p=31>verizon lg vx6000 free ringtones</a> <a href=http://blog.360.yahoo.com/blog-nofjg_Uzeqq8TdtF3kEBZ5jTEAjg?p=73>cash fast loan payday</a>

  • stip poker

    Tracked from online poker no download | 2008/05/07 01:40 | DEL

    So far <a href=http://poker-downloadmtsr.blogspot.com/>no download poker</a> <a href=http://poker-casino-game-nem.blogspot.com/>poker casino game</a>

  • world championship poker

    Tracked from cash back business credit card | 2008/05/07 16:11 | DEL

    One <a href=http://blog.360.yahoo.com/blog-pEL8fIE1fqizRmSKvyG6w6BKrSsV?p=37>poquer internet</a> <a href=http://360.yahoo.com/blog-3yp4AtwmdqfcGSkR1HpGC9TPDA--?p=3>application card credit mart wal</a>

  • 2366i nokia ringtones

    Tracked from credit card debt counseling | 2008/05/07 23:18 | DEL

    Consider <a href=http://blog.360.yahoo.com/blog-6_J4tsgkL6mYlROOAHeVv9osAskXNQ--?p=71>jeux slots gratis</a> <a href=http://onlinetexasholdem-ing.blogspot.com/>online texas hold em</a>

  • oops rampling

    Tracked from oops rampling | 2008/08/21 17:42 | DEL

    swimsuit sheer minimal <a href="http://morysowurelybo9312008.blogspot.com/">swimsuit sheer minimal</a>

Name
Password
Homepage
Secret
< PREV | 1| ... 13|14|15|16|17|18|19|20|21| ... 26| NEXT >