mysql 5.7 account create
grant all privileges on *.* to 'id'@'%' identified by 'password';
grant insert,select,update,delete,execute,lock,drop tables on *.* to 'betsfront'@'192.168.7.%' identified by 'wXaQANRTJg1hE640';
grant insert,select,update,delete,execute,lock tables on *.* to 'betsfront'@'192.168.7.%' identified by 'wXaQANRTJg1hE640';
flush privileges;

mysql 8 account create
create user pinkey@'%' identified by'pinkey2014!@#';
grant all privileges on *.* to 'pinkey'@'%';

덤프용 계정생성
grant all privileges on *.* to 'gambledump'@'192.168.7.%' identified by 'dump 1234@#$';

password change
set password for 'kadminwin'@'192.168.7.%' = password('zpdlelql 83721@#$');

Clear permission
revoke all on *.* from 'chosunfront'@'192.168.7.%';

Give permission
grant all privileges on *.* to 'kadminwin'@'192.168.7.%' identified by 'zpdlelql 83721@#$' with grant option;
with grant option
drop any table

Modify permission to give permission
REVOKE GRANT OPTION ON *.* FROM bullsadmin;

프리시저 권한관련
procedure definer change
show procedure status;
show function status;

-- update mysql.proc set definer='ddakbet_admin@%' where db='mydb_ddakbet';

함수 권한설정
select * from mysql.proc where type = 'FUNCTION';
update mysql.proc set define='' where type = 'FUNCTION';

함수 생성가능하게 설정
function create error
SET GLOBAL log_bin_trust_function_creators = 1; 

mysqldump 로 dump 파일 생성
mysqldump -u username -p --databases DumpTest > dduummpp.sql
mysqldump -u admin -p Whwh-123- --databases DumpTest > dduummpp.sql

mysqldump --set-gtid-purged=OFF -h '위치입력' -u root -p database_name > database_name.sql

local DB가 아닌 외부 DB에서 dump file 가져올 때
mysqldump -h host -u username -p --databases DBName > dumpfile.sql
 mysqldump --routines --events --single-transaction --comments -h192.168.7.69 -P 13789 -ubetsdev -p'bets 32484#@!' --databases mydb_bets > mydb_bets.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p --databases mydb_betgo> mydb_betgo.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines -u admin -p --databases mydb_betgo > mydb_betgo.sql

mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -d --routines -u admin -p --databases statistics > statistics.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --events --single-transaction -P 24045 -u admin -p --databases log > log.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 24045 -u admin -p --no-create-info --no-create-db --skip-opt static_origin > static_origin.sql

mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --single-transaction -P 24045 -u admin -p'ProjecT24!#' static_origin static_head_office_markets_origin > static_head_office_markets_origin.sql

mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p --no-create-info --no-create-db --skip-opt --ignore-table=main.static_game_id_manager main > main_data.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p --no-create-info --no-create-db --skip-opt log > log_data.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p --no-create-info --no-create-db --skip-opt statistics> statistics_data.sql

mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxhDB#241208$' --databases statistics --tables statistics_source_data > statistics_source_data.sql

mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines -u admin -p'dizkahxhDB#241208$' --ignore-table=main.dividend_information --databases main > main.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines -u admin -p'dizkahxhDB#241208$' --databases statistics > statistics.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines -u admin -p'dizkahxh#123#' --databases log > log.sql

mysqldump --set-gtid-purged=OFF -h rds-staging-aurora.cluster-ro-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines -u admin -p'dizkahxh#123#' --databases static_origin> static_origin.sql

Whwh-123-
mysql 명령어로 가져오기
기존 DB이름을 동일하게 사용하고 싶을 때
mysql -u root -p < dduummpp.sql

새로운 DB에 넣고 싶을 때
mysql -u root -p newDB < dduummpp.sql
mysql -u root -p --database newDB < dduummpp.sql

mysql -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 24045 -u admin -p statistics < statistics.sql
mysql -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 24045 -u admin -p main < main.sql
mysql -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 24045 -u admin -p log < logl.sql

mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 20251 -u admin -p'dizkahxh#123#' --database statistics< statistics.sql
mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 20251 -u admin -p'dizkahxh#123#' --database main < main.sql
mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 20251 -u admin -p'dizkahxh#123#' --database static_origin < static_head_office_markets_origin.sql

mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxh#123#' --database mydb_gamble < mydb_gamble_20250228_090223.sql
mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxh#123#' --database mydb_nova < mydb_nova_20250228_090227.sql
mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxh#123#' --database mydb_noble < mydb_noble_20250228_090230.sql
mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -P 20251 -u admin -p'dizkahxh#123#' --database mydb_bets < mydb_bets_20250310_142149.sql

mysql -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxhDB#241208$' --database mydb_gamble < mydb_gamble_20250228_090223.sql
mysql -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxhDB#241208$' --database mydb_nova < mydb_nova_20250228_090227.sql
mysql -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxhDB#241208$' --database mydb_noble < mydb_noble_20250228_090230.sql
mysql -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxhDB#241208$' --database mydb_bets < mydb_bets_20250312_102409.sql
mysql -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxhDB#241208$' --database static_origin < static_origin.sql

mysql -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxhDB#241208$' --database static_origin < static_head_office_markets_origin.sql

겜블2사 덤프 넣기
mysqldump -h192.168.7.42 -P 33060 -u neodb -p'spdh827142 #@!' --databases mydb_nova < mydb_nova_20250228_090227.sql
mysqldump -h192.168.7.42 -P 33060 -u neodb -p --databases mydb_noble < mydb_noble_20250228_090230.sql


-------------------
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' -P 24045 --databases statistics > statistics.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' -P 24045 --databases static_origin > static_origin.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --single-transaction -u admin -p'ProjecT24!#' -P 24045 --databases main > main.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' -P 24045 --databases main > main.sql

mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' -P 24045 --databases log > log.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' -P 24045 --databases mydb_bets > mydb_bets.sql

mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' -P 24045 --databases mydb_gamble > mydb_gamble.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' --databases mydb_nova > mydb_nova.sql
mysqldump --set-gtid-purged=OFF -h rds-test-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'ProjecT24!#' --databases mydb_noble > mydb_noble.sql


mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --single-transaction -u admin -p'dizkahxhDB#241208$' --databases mydb_gamble > mydb_gamble_20250219_144820.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --single-transaction -u admin -p'dizkahxhDB#241208$' --databases mydb_nova > mydb_nova.sql
mysqldump --set-gtid-purged=OFF -h rds-live-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com --routines --single-transaction -u admin -p'dizkahxhDB#241208$' --databases mydb_noble > mydb_noble.sql

devfront
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < main.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306 --databases main  < main_proc.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < statistics.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < static_origin.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < log.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_betgo.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_bets.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_gamble.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_nova.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_noble.sq

mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306
mysql -h rds-staging-aurora.cluster-cpeko4aoszr7.ap-northeast-1.rds.amazonaws.com -u admin -p'dizkahxh#123#' -P20251

mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_gamble.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_nova.sql
mysql -h 172.31.45.82 -u devwork -p'dnjzm2025 !@#' -P13306  < mydb_noble.sql