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.

Connect to the MySQL server in the goormIDE container using mysqlsh

Please connect using the command below.

Last updated

Was this helpful?