# Database Access Using Other Apps

* The IP address used by the user's computer can be found by typing the link in the browser [**https://ifconfig.me/**](https://ifconfig.me/) or via **Command Prompt (CMD)** by typing **curl ifconfig.me**

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.56%20Tampilan%20cek%20IP-ifconfig.me.PNG" alt=""><figcaption><p>IP check display - https://ifconfig.me/</p></figcaption></figure>

\\

\
IP check display - CMD

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.56.a%20Tampilan%20cek%20IP-cmd.PNG" alt=""><figcaption></figcaption></figure>

* Go to **RDBMS** page. On the **Data Stores** page, click the **Details** button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.57.a%20Data%20Store%20Details.png" alt=""><figcaption><p>Data Stores Page - Details</p></figcaption></figure>

* Click the **Firewall** tab, click the **Create trusted source** button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.57%20Tab%20Firewall.PNG" alt=""><figcaption><p>Data Stores Page - Details</p></figcaption></figure>

* Type the IP obtained from **<https://ifconfig.me/>** or from **Command Prompt (CMD)** then click the **Create** button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.57.b%20Input%20IP%20di%20firewall.png" alt=""><figcaption><p>Input IP Address</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.57.c%20Notifikasi%20Sukses.png" alt=""><figcaption><p>Success Notification</p></figcaption></figure>

* Click the **Services** tab, click the **Copy to Clipboard** button.

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.58%20Tab%20Services.PNG" alt=""><figcaption><p>Services Tab</p></figcaption></figure>

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.59%20Tab%20Services-Connection%20Information.png" alt=""><figcaption><p>Services Tab - Connection Information</p></figcaption></figure>

<table><thead><tr><th width="325"></th><th>Description</th></tr></thead><tbody><tr><td><strong>mysql</strong></td><td>Type of database connection used</td></tr><tr><td><strong>ccxadmin</strong></td><td>The username used to log in to the database</td></tr><tr><td><strong>0iBd3yG1NxkxKKHm</strong></td><td>Password used to enter the database</td></tr><tr><td><strong>103.168.135.24</strong></td><td>Host servers</td></tr><tr><td><strong>3306</strong></td><td>Server ports</td></tr><tr><td><strong>ccxdb</strong></td><td>Database name</td></tr></tbody></table>

* Open the database processing application installed on the user's computer, for example **DBeaver.** Click **File** then click **New.**

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.80%20Create%20connection.PNG" alt=""><figcaption><p>DBeaver - New Connection</p></figcaption></figure>

* Click **Database Connection** then click **Next.**

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.81%20Select%20Wizard.PNG" alt=""><figcaption><p>DBeaver - Database Connection</p></figcaption></figure>

* Click **MySQL** then click **Next.**

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.83%20Select%20DB.PNG" alt=""><figcaption><p>DBeaver - Select Database</p></figcaption></figure>

* In **Connection Setting**, fill in the **Server Host**, **Port**, **Database**, **Username**, **Password** sections according to **Table 9.11 Connection Information Details.**

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.85%20koneksi%20db%20eaver.PNG" alt=""><figcaption><p>Image DBeaver - Connection Settings</p></figcaption></figure>

* Then press the **Test Connection** button, if successful appears **Connection Test**

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.86%20koneksi%20berhasil.PNG" alt=""><figcaption><p>DBeaver - Connection Test Results</p></figcaption></figure>

* In **DBeaver** section **Database Navigator** can be seen **Database ccxdb.**

<figure><img src="https://putri.box.cloudeka.id/cloudeka-assets/static/images/9rdbms/9.87%20Database%20ccxdb.PNG" alt=""><figcaption><p>DBeaver - Database ccxdb</p></figcaption></figure>