Remotely administer a OpenShift database using Navicat

In fact, phpMyAdmin this web-side MySQL database management tool is still very good, otherwise it will not be a MySQL database to match. But I think a lot of people should be like heavy China, not too like to use the web-side tools, always feel that the local software to the reality, Navicat this software is very good, although not free. Of course you can also use other GUI management tools, here Navicat to illustrate the OpenShift MySQL database remote management.

Get connection information for MySQL database

First, you need to prepare the database address, user name, password and other information. This can be obtained in your application interface. The address can be obtained after logging in to phpMyAdmin.

OK to turn on remote administration permissions

After logging in to PhpMyAdmin, open the MySQL database -user table to see if the permissions for remote administration are turned on, as shown in the second line, which indicates that remote administration permissions have been turned on.

Navicat establishing a MySQL connection

Create a new MySQL database connection in the Navicat toolbar or File menu and fill in the appropriate information. However, the remote database cannot be successfully connected at this time and an error message appears.

We also need to set up the SSH tab. Fill in the login information for your SSH. Hostname: The URL of your app, similar to *.rhcloud.com. Username: The long list of usernames you have, not the opnenshift login user name. As for how to get the public key, this is no longer spoken.

Click on the connection test, you can see the successful connection!

You can then connect, but a dialog box with a password entry will also pop up. The password here is OpenShift's login password.

Click OK and you can now manage your MySQL database in Navicat.

Other GUI management tools

Workbench, Sequel Pro, Heidisql, Dbforge Studio, DBTools Manager, MyDB Studio, SQLyog

Original address: http://hechonghua.com/openshift-mysql-navicat-remote-management/

The original source and this statement must be indicated in the form of a link when reproduced.

Remotely administer a OpenShift database using Navicat