ReadyMage Help
  • ReadyMage
  • USER PORTAL
    • User Portal Access
    • Change Password
    • Two-Factor Authentication
  • Project Management
    • Project List
    • Project Settings
      • General Info
      • Git Management
      • Environments
      • Members and roles
      • Security
        • Deletion Protection
        • TFA Enforcement
      • Delete Project
  • Application Management
    • Magento Details
    • Domain Management
    • Logs & Monitoring
    • Backups
      • Backup process
      • Disaster recovery process
    • Deployments
      • Pipeline Deployments
      • Pipeline Configuration file
        • Migration guide from 0.x.x to 1.0.0
      • Deploy without build cache
    • GitHub Management
    • SSH Access
      • SSH Usage
      • Database Access using Graphical Interface
      • Troubleshooting
    • IP Whitelist
    • Password Authentication
    • Database & Media
    • Search Engine Bots Discovery
    • Maintenance Page
      • Website Access During Maintenance
      • ReadyMage Maintenance Page
  • Service Management
    • Server-Side Rendering
    • SFTP
    • NewRelic
    • Packagist Modules
    • Cloudflare
  • Infrastructure Management
    • Autoscale
    • Sleep Mode
    • Manage Services
    • Historical Resource Usage
  • PROJECT DEVELOPMENT
    • Node.js version
    • Store access
    • Creating a Production Environment
    • Additional Environments
    • ScandiPWA, PWA Studio, Hyva, or Luma
    • Project Migration to ReadyMage
    • SSH Access for Magento CLI, database and media
    • Code customization and local setup
    • Extension installation
    • Add translations (switch locale)
    • Existing ScandiPWA Project Code Migration
    • Database and media migration
    • Redirect setup
    • Connect CDN and WebP optimization
    • Email setup
    • Changing the Domain & Multi-Store Set up
    • Internal service addresses
    • Kibana filters and useful CLI commands
    • Persistent directories
  • FAQ
    • General
    • Autoscaling
    • Billing
    • User Portal Options
    • Services connected to ReadyMage
    • Hosting, managing resources and autoscaling
    • Source Code Management
    • ScandiPWA and Magento Versions, Commerce Edition and Upgrades
    • Supported software versions
Powered by GitBook
On this page
  • macOS
  • Linux and Windows

Was this helpful?

  1. Application Management
  2. SSH Access

Database Access using Graphical Interface

PreviousSSH UsageNextTroubleshooting

Last updated 10 months ago

Was this helpful?

You can access the database using a graphical interface that supports SSH connection.

macOS

1. Configure SSH Access

Follow this guide to set up SSH access.

2. Get database connection details

After making a successful SSH connection use this command:

cat .my.cnf

Note the following details

  • host

  • user

  • password

3. Setup Sequel Pro

Visit the Sequel Pro official website to set it up.

4. Configure Database Connection

Enter the following details from the data you got in step 2:

  • MySQL Host

  • Username

  • Password

Other details:

  • SSH Host by region:

    • USA Ohio: ssh.ohio.us.i.readymage.com

    • Europe Ireland: ssh.ireland.eu.i.readymage.com

    • Europe Stockholm: ssh.stockholm.eu.i.readymage.com

  • SSH Port - 22

  • SSH User: copy from User Portal following this guide

  • SSH Password: enter only if you have set a password for your SSH when generating it on your computer

Press Connect to connect to your database.

Linux and Windows

1. Configure SSH Access

Follow this guide to set up SSH access.

2. Get database connection details

After making a successful SSH connection use this command:

cat .my.cnf

Note the following details

  • host

  • user

  • password

3. Setup MySQL Workbench

Download available here. Setup instructions for Linux and Windows.

4. Configure Database Connection

Make sure to select Standard TCP/IP over SSH as the Connection Method.

Enter the following details from the data you got in step 2:

  • MySQL Host

  • Username

  • Password

Other details:

  • SSH Host by region (port included):

    • USA Ohio: ssh.ohio.us.i.readymage.com:22

    • Europe Ireland: ssh.ireland.eu.i.readymage.com:22

    • Europe Stockholm: ssh.stockholm.eu.i.readymage.com:22

  • SSH User: copy from User Portal following this guide​

  • SSH Password: enter only if you have set a password for your SSH when generating it on your computer

  • SSH Key File: choose your SSH private key file location.

After filling in the connection parameters click Test Connection and you should see the following window:

Click OK, then OK to save your connection settings and your created connection will be available in the MySQL Connections list.