Remotely Connecting to a Namecheap Database

DataGrip

Make a new connection

• ⌘ + ; to open the Data Sources and Drivers dialog, then ⌘ + N for a new connection.
  • Or Select the Plus Sign icon at the top left of the app > Data Source > MariaDB.
  • SSH/SSL tab
    • Check Use SSH tunnel
    • Click the three dots button to the far right of the Use SSH tunnel line to create a new tunnel (or select from the drop down if one has already been created for this Namecheap hosting account.)
      • Click the plus sign at the top left of the SSH Configurations dialog to add a new configuration.
      • Host: IP or default URL for the Namecheap hosting account.
      • Port: SSH port assigned to the Namecheap hosting account.
      • User name: Admin user name for the Namecheap account, i.e. the account that has ssh access.
      • Authentication type: Key pair
      • Private key file: (path to a key file downloaded from cPanel)

How to remotely connect to a MySQL database located on our shared server - Namecheap Knowledgebase