Remotely administer a OpenShift database using Navicat

Source: Internet
Author: User
Tags phpmyadmin

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.