Editing Remotely Connecting to a Namecheap Database (section)

=== Make a new connection ===

<p class="alert alert-warning">You can do it this way, but if a tunnel has already been established via the command line, the port will already be in use and this method will fail. It is probably better to establish the tunnel on the command line, ignore the '''SSH''' option in the DataGrip connection dialog, and use the local port from the tunnel to connect to the remote database.</p>

* <kbd>&#8984;</kbd> + <kbd>;</kbd> to open the '''Data Sources and Drivers''' dialog, then <kbd>&#8984;</kbd> + <kbd>N</kbd> 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)''
***** '''cPanel''' > '''Security''' > '''SSH Access''' > '''Manage SSH keys''' > '''Public keys''' > ''(item named like `id_rsa`)'' > '''View/Download'''
***** Download the file and save it to `~/.ssh/`. Makes sense to rename it to `namecheap_rsa.pub` so as to overwrite any existing `id_rsa` files.
**** Click the '''Test Connection''' button.
***** Ignore the passphrase prompt.
***** A 2nd prompt will appear asking for a password. Enter the ssh account password.
**** The SSH configuration can be saved if the test connection was successful.
** '''General''' tab 
*** '''Host:''' 127.0.0.1 (Don't use "localhost" here.)
*** '''Port:''' 3306
*** '''User:''' MariaDB user name with access to the web app's database
*** '''Password:''' MariaDB password
*** '''Database:''' The web app's MariaDB database name
*** Click the '''Test Connection''' button
**** Ignore the '''passphrase''' prompt.
**** The next dialog will prompt for a '''password'''. Enter the ssh account's password.
*** The data source is ready to be saved if the test connection succeeds.