This page (revision-1) was last changed on 17-May-2021 01:16 by UnknownAuthor  

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version -1 and -1

At line 1 added 34 lines

[{TableOfContents}]

!!! 참고 URL

*[mysql Window 서비스 등록|http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html]

*[한서버에 두개의 mysql 버전 설치하기|http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_install&wr_id=65586&sca=&sfl=wr_subject%7C%7Cwr_content&stx=mysql5&sop=and]

*[mysql.com의 설치 문서 | http://dev.mysql.com/doc/refman/4.1/en/installing-binary.html]

!!!Mysql Install

*[리눅스에서 Mysql 5.1.x 설치|Mysql5.1.x_Install_Linux]

*[리눅스에서 Mysql 5.0.x 설치|Mysql5.0.x_Install_Linux]

*[리눅스에서 Mysql 4.1.x 설치|Mysql4.1.x_Install_Linux]

*[리눅스에서 Mysql 5.0.x, 4.1.x 복합 설치|Mysql5.0.x_4.1.x_Install_Linux]

!!!root password 수정

{{{

bin/mysqladmin -u root -p password 'new-password'

}}}

!!!비밀번호를 잊었을때

{{{

./bin/safe_mysqld --user=root --skip-grant-tables & // 임시모드실행

./bin/mysql (비밀번호 변경)

}}}

!!!백업, 복구

{{{

서버데이터를 덤프

mysql/bin/mysqldump --default-character-set=utf8 -uroot -p xxxx > xxxx.dump

서버에 다시 올림

mysql -uroot -p --default-character-set=utf8 xxxx < xxxx.dump

}}}