Mysql login path 설정

1. Login Path 등록

$ mysql_config_editor set --login-path=설정이름 --host=주소 --user=아이디 --port=포트 --password

 Enter password: *****

2. Print Login Path

$ mysql_config_editor print --login-path=설정이름
 [myroot]
 user = root
 password = *
 host = localhost
 port = 3306
# 전부 출력
 mysql_config_editor print --all 

3. Login Path 삭제

 mysql_config_editor remove --login-path=설정이름 

4. 접속

 $ mysql --login-path=설정이름 

Published by

shotan

Hi i'm cho

Leave a Reply

Your email address will not be published. Required fields are marked *