Skip to content

조회 수 7282 추천 수 0 댓글 0
?

단축키

Prev이전 문서

Next다음 문서

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

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄
mysql root 계정 재생성


/usr/local/mysql/bin/mysqld_safe --skip-grant-tables &

> use mysql;
> delete from user where User='root';
> insert into `user` VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
> update user set password=password('mysql root 패스워드') where user='root';
> flush privileges;
> exit

killall mysqld
/etc/init.d/mysqld start


  1. libmysqlclient.so.15: cannot open shared object file: No such file or directory

    Date2010.07.07 ByADMINPLAY Views22975
    Read More
  2. MySQL 튜닝 값을 탐지해주는 유용한 툴

    Date2012.02.23 ByADMINPLAY Views22495
    Read More
  3. Starting MySQL.Manager of pid-file quit without updating fi[실패]

    Date2010.01.28 ByADMINPLAY Views19997
    Read More
  4. ../depcomp: line 571: exec: g++: not found

    Date2010.11.26 ByADMINPLAY Views19627
    Read More
  5. MySQL 튜닝 query cache 설정

    Date2011.04.09 ByADMINPLAY Views19539
    Read More
  6. mysql old_password 문제

    Date2010.06.19 ByADMINPLAY Views18589
    Read More
  7. [MySQL 5.1.4] /bin/rm: cannot remove `libtoolT': No such file or directory

    Date2012.01.16 ByADMINPLAY Views18541
    Read More
  8. Mysql - Query Cache

    Date2011.04.09 ByADMINPLAY Views18523
    Read More
  9. Another app is currently holding the yum lock; waiting for it to exit 해결법

    Date2010.03.08 Byl2zeo Views18392
    Read More
  10. mysql - copying to tmp table

    Date2012.01.16 ByADMINPLAY Views18250
    Read More
  11. lower_case_table_names=1

    Date2010.04.02 ByADMINPLAY Views18176
    Read More
  12. MySQL의 호스트 블럭킹 & max_connect_errors

    Date2011.03.09 ByADMINPLAY Views17908
    Read More
  13. FULLTEXT 인덱스와 서치

    Date2011.04.09 ByADMINPLAY Views17579
    Read More
  14. MySQL 오류 테이블 복원

    Date2010.05.29 Byl2zeo Views17412
    Read More
  15. mysql 다중 서버 관리

    Date2012.12.17 ByADMINPLAY Views17403
    Read More
  16. MYSQL 4.0 --> 5.1 마이그레이션

    Date2012.01.16 ByADMINPLAY Views17290
    Read More
  17. MySQL errno 의미 확인

    Date2010.05.29 Byl2zeo Views16723
    Read More
  18. mysql innodb 설정확인

    Date2009.06.17 ByADMINPLAY Views16719
    Read More
  19. latin1 로 저장된 db 를 euckr 또는 utf8로 변환하는 방법

    Date2010.05.28 ByADMINPLAY Views16681
    Read More
  20. [MySQL] OPTIMIZE, TRUNCATE, 테이블복구, DB공간제한

    Date2010.05.29 Byl2zeo Views16608
    Read More
Board Pagination Prev 1 2 3 4 5 Next
/ 5

Copyright ADMINPLAY corp. All rights reserved.

abcXYZ, 세종대왕,1234

abcXYZ, 세종대왕,1234