Openshift:如何远程访问MySQL? [英] Openshift: How to remote access MySQL?

问题描述

因此，我刚刚在Openshift上完成了JBoss应用服务器的设置，并连接了MySQL和 phpmyadmin 盒式磁带.我的问题是是否可以使用 MySQL Workbench 之类的应用程序远程访问数据库服务器?

So I just finished setting up a JBoss application server gear on Openshift and I attached a MySQL and phpmyadmin cartridges. My question is if there is a way to remote access to the database server using an app like MySQL Workbench?

推荐答案

您可以使用rhc port-forward将端口从数据库转发到本地计算机.在此处中查看教程.在这种情况下，端口转发的基本思想是可以将本地计算机上的端口转发到齿轮上的端口.因此，在您的情况下，您可以将本地计算机上的某些端口转发到mysql正在侦听设备中的连接的端口.然后，将MySQL Workbench连接到本地计算机上的端口.

You can use rhc port-forward to forward ports from your database to your local machine. Check out the tutorial here. The basic idea of port forwarding in this context is that you can forward ports on your local machine to ones on the gear. So in your case, you would forward some port on your local machine to the port mysql is listening on for connections in your gear. Then you would connect MySQL Workbench to the port on your local machine.

这篇关于Openshift:如何远程访问MySQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！