DB 테이블 생성/권한설정

mysql 접속 : mysql -u{아이디} -p

1. 테이블 생성

CREATE DATABASE IF NOT EXISTS tv_partner;

2. 계정 생성

GRANT USAGE ON *.* TO user_tv_partner@localhost IDENTIFIED BY "pass_tv_partner";

GRANT USAGE ON *.* TO user_tv_partner@192.168.0.216 IDENTIFIED BY "pass_tv_partner";

GRANT USAGE ON *.* TO user_tv_partner@192.168.0.217 IDENTIFIED BY "pass_tv_partner";

3. 권한 설정

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON tv_partner.* TO user_tv_partner@localhost;

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON tv_partner.* TO user_tv_partner@192.168.0.216;

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON tv_partner.* TO user_tv_partner@192.168.0.217;

4. 적용

FLUSH PRIVILEGES;

5. DB 백업

mysqldump -uroot -p {DB명} < {DB백업.sql}

mysqldump -uroot -p tv_partner > tv_partner.sql

6. DB 백업 복구

mysql -uroot -p {DB명} < {DB백업.sql}

ex) mysql -uroot -p tv_partner < tv_partner.sql

** SCP 파일 전송

단일 파일 전송

scp tv_partner.sql root@xxx.xxx.xxx.xxx:/home/samback

폴더 통으로 전송

scp tv_partner.sql root@xxx.xxx.xxx.xxx:/home/samback