Abstract: What tools do you use to access the database? The author works in Linux, and most commonly uses command line tools (mysql, Redis – CLI,mongo). Easy to use, but the graphical tools normally handle some work can be handy, this paper recommends Navicat, Redinav, RoboMongo graphical database management tools, etc.

Article source: Tao Teacher operation notes – wechat official account

MySQL graphical management tool

1. Navicat

  • Website: www.navicat.com.cn/

1.1 introduce Navicat

Navicat Premium is a great database development tool that allows you to connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL and SQLite databases simultaneously from a single application.

Advantages:

The interface is simple, the function is very powerful, support a variety of databases, support Chinese, provide free version.

1.2 Navicat installation

Software download: www.navicat.com.cn/download/na…

Installation:

Install on MAC and drag to the Application folder.

1.3 configuration Navicat

Create a link configuration:

Click the link icon to create a DB link. Navicat supports a variety of DB links. Let’s take MySQL as an example.

1.4 Navicat use

Execute SQL:

Data export:

It is worth mentioning that Navicat has a powerful data import/export function, including Excel, CVS, JSON and other file formats.

Support multiple file formats, such as export to Excel format.

Oracle Graphical management tool

2. Navicat

Navicat supports Oracle,SQL Server, SQLite and PostgreSQL databases in addition to MySQL. This section describes how Navicat accesses Oracle.

2.1 Navicat installation

Software download: www.navicat.com.cn/download/na…

2.2 configuration Navicat

Tnsnames. ora does not need to be configured for Navicat on MAC.

2.3 access to oracle

After DB links are configured correctly, oracle is accessed.

2.4 Oracle Connection Failed

Sometimes Navicat fails to connect to Oracle remotely. One possible reason is that the client needs to configure /etc/host. It could also be a firewall or a listener.

1) Oracle failed to connect

1. Is the Oracle service running properly? 2. Try reconfiguring the listener. 3, the firewall is not related to ah? If iptable is related, disable iptable on oracle machine.

Check if the listener is on
$lsnrctl status 
$lsnrctl start
$lsnrctl status 

$ncZ 192.168.56.103 1521$tnsping [email protected]
#
$sqlplus / as sysdba
SQL> startup force
Copy the code

Disable the firewall:

#iptable
$iptables -L
$iptables -F
cat  /etc/sysconfig/iptables
iptables-save > /etc/sysconfig/iptables

Disable the firewall permanently
service iptables stop
chkconfig iptables off
service ip6tables stop
chkconfig ip6tables off
##centos7 
systemctl stop firewalld
systemctl disable firewalld
# checkNc-z 192.168.56.103 1521 Connection to 192.168.56.103 port 1521 [TCP/CUBE - LM] Succeeded!Copy the code

2) Modify Oracle Hosts

The IP address must be the same as the server IP addressVim/etc/hosts 192.168.56.103 db01It is possible to configure host for MAC machines as well.
#sudo scutil --set HostName tao-opsMacBook
Copy the code

3. Oracle SQL Developer

  • www.oracle.com/cn/index.ht…

3.1 Software Introduction

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle databases in both traditional and cloud deployments. SQL Developer provides complete end-to-end PL/SQL application development.

3.2 Software Installation

Download: www.oracle.com/cn/tools/do…

3.3 Software Configuration

3.4 Software Use

If the configuration/test link is ok, you can start accessing Oracle data. Execute SQL

Redis graphical management tool

4. Redinav

  • Website: www.redinav.com/

4.1 Software Introduction

Redinav is a free graphical Client of Redis, which can be used to manage redis/ Redis-Cluster, support data operations, import/export operations, etc. A similar tool is the Redis GUI administration tool Redis Desktop Manager, but is not friendly to Redis-Cluster support.

4.2 Software Installation

Software download: download website www.redinav.com/ domestic: download.csdn.net/download/we…

4.3 Software Configuration

4.4 Software Use

Keys in redis-cluster can be easily exported.

MongoDB graphical management tool

5. RoboMongo

  • studio3t.com/
  • robomongo.org/download

5.1 Software Introduction

RoboMongo is a cross-platform MongoDB GUI client management tool that supports Windows, MacOS, and Linux. It features support for SSL connections to MongoDB servers as well as SSH tunnel connections. The RoboMongo query interface supports tree view, table view and text view, and can also save the query results for future use. Robomongo can choose its own version to download.

! RoboMongo] (upload images. Jianshu. IO/upload_imag…).

5.2 Software Installation

Download it at studio3t.com/download/

5.3 Software Configuration

Configuring RoboMongo is easy. Enter IP :port and password as shown in the figure below.

5.4 Software Use

Reference:

  • www.navicat.com.cn/
  • www.oracle.com/cn/index.ht…
  • www.redinav.com/
  • studio3t.com/download/