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. No Image 05Jul
    by JAESOO
    2016/07/05 by JAESOO
    Views 123 

    mysql이 cpu를 많이 점유하고, DB와의 연결상태가 좋지 않을때

  2. No Image 17Mar
    by JAESOO
    2015/03/17 by JAESOO
    Views 143 

    Mysql slow-query를 이용한 로그 분석

  3. No Image 17Mar
    by JAESOO
    2015/03/17 by JAESOO
    Views 172 

    Mysql 데몬 문제 해결 방안 (cpulimit)

  4. No Image 16Mar
    by JAESOO
    2015/03/16 by JAESOO
    Views 733 

    리눅스 실시간으로 로그 보기 tail 명령어

  5. No Image 16Mar
    by JAESOO
    2015/03/16 by JAESOO
    Views 487 

    mysql 5.5.x my.cnf 참고

  6. No Image 16Mar
    by JAESOO
    2015/03/16 by JAESOO
    Views 545 

    Mysql Slow query log 등록

  7. No Image 16Mar
    by JAESOO
    2015/03/16 by JAESOO
    Views 158 

    MYSQL 성능 향상 정리

  8. No Image 16Mar
    by JAESOO
    2015/03/16 by JAESOO
    Views 418 

    MySQL Query Cache 사용법

  9. No Image 25Dec
    by JAESOO
    2014/12/25 by JAESOO
    Views 181 

    Mysql 에서 Got a packet bigger than 'max_allowed_packet' bytes 오류

  10. No Image 25Dec
    by JAESOO
    2014/12/25 by JAESOO
    Views 308 

    MySQL 내부 변수 max_allowed_packet

  11. No Image 17Nov
    by JAESOO
    2014/11/17 by JAESOO
    Views 299 

    Mysql binary log 정리, 삭제 주기 설정

  12. No Image 17Nov
    by JAESOO
    2014/11/17 by JAESOO
    Views 529 

    MySQL 로그 파일 관리 2 - 로그 파일 남기기

  13. No Image 17Nov
    by JAESOO
    2014/11/17 by JAESOO
    Views 416 

    MySQL 로그 파일 관리 1 - 설정

  14. No Image 17Nov
    by JAESOO
    2014/11/17 by JAESOO
    Views 232 

    MySQL Binary Log 지우는 방법

  15. No Image 17Nov
    by JAESOO
    2014/11/17 by JAESOO
    Views 4003 

    MySQL 설치/사용시 발생 에러 유형별 대처방법

  16. No Image 17Nov
    by JAESOO
    2014/11/17 by JAESOO
    Views 288 

    Mysql 데이터 폴더의 mysql-bin.xxx 파일들 관련 삭제 및 초기화 방법

  17. No Image 07Jul
    by JAESOO
    2014/07/07 by JAESOO
    Views 1685 

    MySQL my.cnf 파일 수정으로 mysql 서버 튜닝하기

  18. No Image 07Jul
    by JAESOO
    2014/07/07 by JAESOO
    Views 1256 

    MySQL에 원격 접속 허용

  19. No Image 23Jan
    by JaeSoo
    2014/01/23 by JaeSoo
    Views 1280 

    mysql에서 (테이블명) is marked as crashed and should be repaired 에러시

  20. 왜 MySQL 에서 InnoDB 를 써야하는가? InnoDB vs MyISAM 비교

Board Pagination Prev 1 2 Next
/ 2

PageViews   Today : 4568 Yesterday : 5037 Total : 21960620  /  Counter Status   Today : 4431 Yesterday : 4602 Total : 1187154

Edited by JAESOO

sketchbook5, 스케치북5

sketchbook5, 스케치북5

나눔글꼴 설치 안내


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

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

설치 취소