# Using MySQL Workbench with goormIDE

### Configure mysqld.cnf

Edit /etc/mysql/mysql.conf.d/mysqld.cnf using vi.

```
#bind-address = 127.0.0.1 <- make it comment
```

Please enter the command below to restart mysql.

```
service mysql restart
```

### Grant permission to MySQL account

Please grant permission using the command below.

```
$ 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 Port Forwarding Configuration

1. From the top menu, click **\[Container] → \[Port Forwarding Settings]**
2. Select **\[MySQL]** as the type and click the **\[Register]** button.

<figure><img src="/files/L7UZZuZMvuuK3O7CndYx" alt=""><figcaption></figcaption></figure>

### Connect to the MySQL server in the goormIDE container using mysqlsh

Please connect using the command below.

```
$ mysqlsh root@54.184.110.197:59700
Please provide the password for 'root@54.184.110.197:59700': 
Save password for 'root@54.184.110.197: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 'root@54.184.110.197: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 >
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.goorm.io/en/goormide/07.-faq/using-mysql-workbench-with-goormide.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.