Search…
ENGLISH
I would like to use MySQL Workbench in the goormIDE. What should I do?

Setting mysql.cnf

1. Edit file.
vim /etc/mysql/mysql.conf.d/mysqld.cnf as below.
1
#bind-address = 127.0.0.1 Must be commented
Copied!
2. Restart the mysql server.
1
service mysql restart
Copied!

Allow permission to an account of MySQL.

Following as below.
1
$ mysql -u root -p
2
Enter password:
3
Welcome to the MySQL monitor. Commands end with ; or \\g.
4
Your MySQL connection id is 4
5
Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu)
6
7
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
8
9
Oracle is a registered trademark of Oracle Corporation and/or its
10
affiliates. Other names may be trademarks of their respective
11
owners.
12
13
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.
14
15
mysql> GRANT ALL ON *.* TO [email protected]'%' IDENTIFIED BY 'pass';
16
Query OK, 0 rows affected, 1 warning (0.00 sec)
17
18
mysql> FLUSH PRIVILEGES;
19
Query OK, 0 rows affected (0.00 sec)
Copied!

Setting port forwarding for MySQL.

  1. 1.
    Click [CONTAINER][Port Forwarding Configuration] in the top menu.
  2. 2.
    Select MySQL in type and click [Register].

Access MySQL server in the goormIDE container by mysqlsh

Follow as below
1
$ mysqlsh [email protected]:59700
2
Please provide the password for '[email protected]:59700':
3
Save password for '[email protected]:59700'? [Y]es/[N]o/Ne[v]er (default No):
4
MySQL Shell 8.0.19
5
6
Copyright (c) 2016, 2019, Oracle and/or its affiliates. All rights reserved.
7
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
8
Other names may be trademarks of their respective owners.
9
10
Type '\\help' or '\\?' for help; '\\quit' to exit.
11
Creating a session to '[email protected]:59700'
12
Fetching schema names for autocompletion... Press ^C to stop.
13
Your MySQL connection id is 6
14
Server version: 5.7.29-0ubuntu0.18.04.1 (Ubuntu)
15
No default schema selected; type \\use <schema> to set one.
16
MySQL 54.184.110.197:59700 ssl JS >
Copied!
Last modified 1mo ago