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
      • Deploy without build cache
      • Queue Tab (Launching soon)
      • Settings Tab (Launching soon)
        • Automatic Deployments
        • ReadyMage Maintenance Page
          • Website Access During Maintenance
      • Notifications Tab (Launching soon)
        • Managing email notifications
        • Managing Slack notifications
      • Pipeline Deployments
      • Pipeline Configuration file
        • Migration guide from 0.x.x to 1.0.0
    • SSH Access
      • SSH Usage
      • Database Access using Graphical Interface
      • Troubleshooting
    • IP Whitelist
    • Password Authentication
    • Database & Media
    • Search Engine Bots Discovery
  • 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 1 month ago

Was this helpful?

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

macOS

1. Configure SSH Access

Follow 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 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

    • Canada Central: ssh.central.ca.i.readymage.com

    • Middle East UAE: ssh.central.me.i.readymage.com

  • SSH Port - 22

  • 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

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

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

    • Canada Central: ssh.central.ca.i.readymage.com:22

    • Middle East UAE: ssh.central.me.i.readymage.com:22

  • 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.

SSH User: copy from User Portal following

Follow to set up SSH access.

Download available . Setup instructions for and .

SSH User: copy from User Portal following

this guide
this guide
here
Linux
Windows
this guide​
this guide
Sequel Pro official website