Skip to main content

Database Access Using Other Apps

  • The IP address used by the user’s computer can be found by typing the link in the browser or via Command Prompt (CMD) by typing curl

IP check display -

IP check display - CMD

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

Data Stores Page - Details

  • Click the Firewall tab, click the Create trusted source button

Data Stores Page - Details

  • Type the IP obtained from or from Command Prompt (CMD) then click the Create button

Input IP Address

Success Notification

  • Click the Services tab, click the Copy to Clipboard button

Services Tab

Services Tab - Connection Information

Detailed Connection Information

mysql Type of database connection used
ccxadmin The username used to log in to the database
0iBd3yG1NxkxKKHm Password used to enter the database Host servers
3306 Server ports
ccxdb Database name

  • Open the database processing application installed on the user’s computer, for example DBeaver
  • Click File then click New

DBeaver - New Connection

  • Click Database Connection then click Next

DBeaver - Database Connection

  • Click MySQL then click Next

DBeaver - Select Database

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

Image DBeaver - Connection Settings

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

DBeaver - Connection Test Results

  • In DBeaver section Database Navigator can be seen Database ccxdb

DBeaver - Database ccxdb