참고 URL#

Mysql Install#

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

Add new attachment

Only authorized users are allowed to upload new attachments.
« This page (revision-) was last changed on 17-5월-2021 01:16 by UnknownAuthor