RadarURL
Skip to content
조회 수 5745 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

For Windows OS:

OK, I struggled with this for ages. There are various partial fixes that did not fix it for me on the web, but in the end the following worked:

If you've installed it, then uninstall (an earlier version that had been removed could have left crap that is causing an issue, so best to start off clean). Do this as follows:
- Add/Remove Programs and remove MySQL.
- Delete the Programs File/MySQL folder (it gets left behind)
- Delete the data file (where ever you stored it) #:MySQL DataFiles > This is assuming you have no data to as yet to worry about!!!!
- Run RegEdit and delete all the MySQL Keys (search and F3) and the half a dozen or so CLSIDs that coe up with just a single non-defailt key for MySQL. You can leave ADOBE keys that mention it if you have dreamweaver etc. As allways back up you registry first before choppig it!

OK. Now run te install and go through the config wizard until it fails at the start up. Then close it.

Now open up Services and open MySQL properties - I set it to run under the Administrator account rather than System/ANOther to ensure it had permissions.

Next, go to your new MySQL DataFile and delete 'ibdata1'.
Then go to 'C:Documents and SettingsAll UsersApplication DataMySQLMySQL Server 5.1data' and delete all tje 'ib_logfile' prefixed files (should be 0 and 1) - useful to notice the .err log here to which is a text file.

Then go back to Services and manually start it and all should be fine.

Hopefully I have saved you a few hourse peeing around with Windows - MySQL Devs, about time this bug was fixed eh? Been hanging around a long while now and the web is chok full of unanswered or half answered requests for help. Remember - some of us have no choice but to use Windows.

 

출처 : http://forums.mysql.com/read.php?22,144428,250105#msg-250105

?

  1. mySQL에서 사용자와 권한

    Date2004.04.16 By처누 Views7326
    Read More
  2. Mysql 기초-DB 설치, 관리자지정, 계정추가 등

    Date2004.06.06 By처누 Views7355
    Read More
  3. MySql 테이블 검사 및 복구하기 [ myisamchk ]

    Date2005.11.26 ByJaeSoo Views6892
    Read More
  4. mysql에서 사용자 계정 비밀번호 변경 방법

    Date2006.02.16 ByJaeSoo Views7859
    Read More
  5. MySQL에서 테이블을 생성할때 MyISAM과 InnoDB 어느것을 선택하나요?

    Date2010.01.25 ByJaeSoo Views7581
    Read More
  6. [Mysql] 범위 삭제 DELETE 쿼리

    Date2010.05.05 ByJaeSoo Views8115
    Read More
  7. mysql 4.x 버전의 euc-kr(latin1) DB를 mysql 5.x 버전으로 이전 하는법

    Date2011.04.30 ByJaeSoo Views8529
    Read More
  8. MySQL Dump뜨는 방법 및 복구 방법

    Date2011.06.08 ByJaeSoo Views10702
    Read More
  9. fedora core4 mysql 서버설치 및 windows client로 접속

    Date2011.06.16 ByJaeSoo Views12686
    Read More
  10. [Fedora 8] Mysql 5.0.67 설치

    Date2011.06.16 ByJaeSoo Views10362
    Read More
  11. Mysql DB 손상됬을경우 점검 및 복구 명령

    Date2011.09.16 ByJaeSoo Views9270
    Read More
  12. MySQL 재설치시 오류

    Date2011.11.15 ByJaeSoo Views7600
    Read More
  13. MySQL Data file 위치

    Date2011.11.15 ByJaeSoo Views5561
    Read More
  14. MySQL Plugin 'InnoDB' init function returned error.

    Date2011.11.15 ByJaeSoo Views5745
    Read More
  15. mysqlcheck 유틸리티 사용법(analyze, optimize, repair)

    Date2012.06.05 ByJaeSoo Views4627
    Read More
  16. 윈도우환경에서 MySQL 설치하기

    Date2013.03.13 ByJaeSoo Views3534
    Read More
  17. MySQL database 정보 import하기

    Date2013.03.13 ByJaeSoo Views1355
    Read More
  18. MySQL 테이블 형태 변경하기 MyISAM -> InnoDB(또는 InnoDB -> MyISAM)

    Date2013.03.19 ByJaeSoo Views1617
    Read More
  19. [MySQL] phpMyAdmin으로 MyISAM 테이블 형식을 InnoDB로 바꾸기

    Date2013.03.19 ByJaeSoo Views6768
    Read More
  20. 왜 MySQL 에서 InnoDB 를 써야하는가? InnoDB vs MyISAM 비교

    Date2013.04.12 ByJaeSoo Views3935
    Read More
Board Pagination Prev 1 2 Next
/ 2

PageViews   Today : 9143 Yesterday : 5037 Total : 21965195  /  Counter Status   Today : 8840 Yesterday : 4602 Total : 1191563

Edited by JAESOO

sketchbook5, 스케치북5

sketchbook5, 스케치북5

나눔글꼴 설치 안내


이 PC에는 나눔글꼴이 설치되어 있지 않습니다.

이 사이트를 나눔글꼴로 보기 위해서는
나눔글꼴을 설치해야 합니다.

설치 취소