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 https://ifconfig.me/ or via Command Prompt (CMD) by typing curl ifconfig.me


IP check display - https://ifconfig.me/



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 https://ifconfig.me/ 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


Description
mysql Type of database connection used
ccxadmin The username used to log in to the database
0iBd3yG1NxkxKKHm Password used to enter the database
103.168.135.24 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


×