구름IDE 에서 MySQL Workbench를 사용하고 싶어요

mysqld.cnf 설정

vi로 /etc/mysql/mysql.conf.d/mysqld.cnf을 아래와 같이 편집해주세요.

#bind-address = 127.0.0.1 주석해야함

아래의 명령어를 입력하여 재시작해주세요.

service mysql restart

MySQL 계정에 권한 부여

아래의 방법으로 권한을 부여해주세요.

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \\g.
Your MySQL connection id is 4
Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql> GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'pass';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MySQL 포트포워딩 설정

1. 상단 메뉴에서 [컨테이너] → [포트포워딩 설정]을 클릭하세요.

2. 유형을 MySQL 선택한 뒤 [등록] 버튼을 클릭하세요.

mysqlsh로 goormIDE 컨테이너 안에 있는 MySQL server 접속

아래의 방법으로 접속하세요.

$ mysqlsh [email protected]:59700
Please provide the password for '[email protected]:59700': 
Save password for '[email protected]:59700'? [Y]es/[N]o/Ne[v]er (default No): 
MySQL Shell 8.0.19

Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.

Type '\\help' or '\\?' for help; '\\quit' to exit.
Creating a session to '[email protected]:59700'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 6
Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu)
No default schema selected; type \\use <schema> to set one.
MySQL  54.184.110.197:59700 ssl  JS >