1. ssh 비번 변경
케이윈
데브 : Qoqofh1234 !@#
라이브 
웹 : Rkclwlq1234 @#$
디비 : Enqjrl1234 @#$   Enqjrdl1234 @#$
어드민 : Dhwlddj1234 @#$

케이윈 케이플레이 api 서버
kplay 1234!@#

roaqmf 2022!@#
갬블
라이브
웹 : Qkqpzb1234 @#$
디비 : Rkakrnl1234 @#$
어드민 : Gkdlxm1234 @#$


온오프
dhsdhvm1234 !@#

set password for 'admin'@'%' = password('Dhsdhvm 72621$#@');
set password for 'onoff'@'127.0.0.1' = password('Dhsdhvm 72621$#@');
admin / Dhsdhvm 72621$#@
port : 13289

rmq, kwin-rmq
qkskvmfptm 1234@#$

케이윈 3~5시
조선 3시
겜블 4시

2. 디비 비번 변경
케이윈
set password for 'kadminwin'@'%' = password('zpdldnls 2938!@#');
set password for 'kpwin'@'192.168.7.%' = password('zpdldnls 2938!@#');

조선
set password for 'chosunadmin'@'%' = password('whtjs 2034!@#');
set password for 'chosunfront'@'192.168.7.%' = password('whtjs 2034!@#');

온오프
set password for 'admin'@'%' = password('dhsdhvm 0514!@#');
set password for 'onoff'@'127.0.0.1' = password('dhsdhvm 0514!@#');

겜블
set password for 'gambleadmin'@'%' = password('rpaqmf 28364#@!');
set password for 'gamblefront'@'192.168.7.%' = password('rpaqmf 28364#@!');
set password for 'root'@'localhost' = password('rpaqmf 28364#@!');
update mysql.user set Password = password('rpaqmf 28364#@!') where User = 'root';

벳고
set password for 'betgoadmin'@'%' = password('qptrh 2937!@#');
set password for 'betgofront'@'192.168.7.%' = password('qptrh 2937!@#');
FLUSH PRIVILEGES;

벳츠
set password for 'betsdev'@'%' = password('bets 15987!@#');
set password for 'betsdump'@'192.168.7.%' = password('bets 15987!@#');
set password for 'betsfront'@'192.168.7.%' = password('bets 15987!@#');
FLUSH PRIVILEGES;


-- sql

INSERT INTO mysql.user (host,user,password) VALUES (‘14.52.211.218′,’kadminwin’,password(‘kadmin 1234@#$’));

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’14.52.211.218’;

FLUSH PRIVILEGES;

update mysql.user set User = 'kadminwin' where User ='kadminwin1';
grant all privileges on *.* to 'kadminwin'@'%' identified by 'kadmin 1234@#$’';


create user kadminwin@'14.52.211.218' identified by'pinkeyfront2022!@#';
set password for 'kadminwin'@'14.52.211.218' = password('kadmin 1234@#$');
set password for 'kadminwin'@'%' = password('kadmin 1234@#$');
set password for 'kpwin'@'192.168.7.%' = password('kfornt 1234@#$');

-- sql

set password for 'gambleadmin'@'%' = password('gadmin 1234@#$');
set password for 'gamblefront'@'192.168.7.%' = password('gfront 1234@#$');


set password for 'gambleadmin'@'%' = password('Groqkfdydeh 2345#@!');
set password for 'gamblefront'@'192.168.7.%' = password('Gvmfhrmfoa 2345#@!');

\
온오프
디비포트 13289 변경
디비계정 생성
onfront / onfront 2022!@# (프로그램)
onadmin / onwork 2022!@# (워크벤치)
root / fnxm 2002!@#(비번 및 접급권한 설정)

-- sql
grant insert,select,update,delete,execute,lock tables on *.* to 'onadmin'@'192.168.7.%' identified by 'onwork 2022!@#';
grant all privileges on *.* to 'onfront'@'%' identified by 'onfront 2022!@#';
set password for 'root'@'%' = password('fnxm 2002!@#');

flush privileges;