[MYSQL] DB백업, 복구, 권한부여

* 백업과 복구

1. 백업
mysqldump -u아이디 -p패스워드 --default-character-set=utf8 DB명> 백업파일명.sql

2. 복원
mysql -u아이디 -p패스워드 --default-character-set=utf8 DB명< 백업파일명.sql

* 권한부여

1. 아이디 생성
grant all privileges on *.* to 아이디 identified by '패스워드'


2. 실행권한들 모두 Y로 바꾸기
update user set
 Select_priv           = 'Y'
,Insert_priv           ='Y'
,Update_priv           ='Y'
,Delete_priv           ='Y'
,Create_priv           ='Y'
,Drop_priv             ='Y'
,Reload_priv           ='Y'
,Shutdown_priv         ='Y'
,Process_priv          ='Y'
,File_priv             ='Y'
,Grant_priv            ='Y'
,References_priv       ='Y'
,Index_priv            ='Y'
,Alter_priv            ='Y'
,Show_db_priv          ='Y'
,Super_priv            ='Y'
,Create_tmp_table_priv ='Y'
,Lock_tables_priv      ='Y'
,Execute_priv          ='Y'
,Repl_slave_priv       ='Y'
,Repl_client_priv      ='Y'
,Create_view_priv      ='Y'
,Show_view_priv        ='Y'
,Create_routine_priv   ='Y'
,Alter_routine_priv    ='Y'
,Create_user_priv      ='Y'
 where User = '아이디' ;


3. 반영하기
flush privileges;