aws bitnami mysql 암호 분실

cat bitnami_application_password

여기서 나오는걸로 일단 도전해보고 안되면

 

UPDATE mysql.user SET authentication_string=password('암호') WHERE user='root'; FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY '암호'; FLUSH PRIVILEGES;

UPDATE mysql.user SET password=PASSWORD('암호') WHERE user='root' FLUSH PRIVILEGES;
FLUSH PRIVILEGES

UPDATE mysql.user SET authentication_string=password('암호') WHERE user='root';
FLUSH PRIVILEGES

 

mysql 정지 -> safemode로 mysql 실행해준 후에 -> bitnami mysql restart 스크립트 실행

 

 

 

docs.bitnami.com/ibm/infrastructure/mysql/administration/change-reset-password/