Database connection client use (DB2,ORACLE,MYSQL)

As some operations personnel, especially database operators, sometimes need to log into the database frequently, but if we every time to the server to log on locally, it is unrealistic, so we can remotely connect to the database.

Today, we introduce some database remote connection tools (graphical interface):

1. MySQL Client tool installation using

Locate the Running Program

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/77/84/wKioL1ZpMuuhFyUpAAAUjWfvzUI438.png "style=" float: none; "title=" 1.png "alt=" Wkiol1zpmuuhfyupaaaujwfvzui438.png "/>

Installation can

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/77/85/wKiom1ZpMnngThJjAADbxPjHom8003.png "style=" float: none; "title=" 2.png "alt=" Wkiom1zpmnngthjjaadbxpjhom8003.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/77/85/wKiom1ZpMnmTproaAAA4mlmw3Po240.png "style=" float: none; "title=" 3.png "alt=" Wkiom1zpmnmtproaaaa4mlmw3po240.png "/>

Enter the appropriate information to connect to the database

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/77/84/wKioL1ZpMuzjpDPEAAECYz8W-gA910.png "style=" float: none; "title=" 4.png "alt=" Wkiol1zpmuzjpdpeaaecyz8w-ga910.png "/>

2.orcle Database Installation Client (Orcle database is not the same as a normal database, you need to install the client first, and then install the Connection tool)

First installation of the first client tool

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/77/85/wKiom1ZpM3PDzqAMAAARe7bBWXw124.png "style=" float: none; "title=" 5.png "alt=" Wkiom1zpm3pdzqamaaare7bbwxw124.png "/>

Installation can

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/77/84/wKioL1ZpM-jC5pmLAALgubaIBqE957.png "style=" float: none; "title=" 6.png "alt=" Wkiol1zpm-jc5pmlaalgubaibqe957.png "/>

Select Administrator

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/77/84/wKioL1ZpM--zgJvOAAMl-qdj6Uw441.png "style=" float: none; "title=" 7.png "alt=" Wkiol1zpm--zgjvoaaml-qdj6uw441.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/77/85/wKiom1ZpM33xPachAAFDQ6l4WUs525.png "style=" float: none; "title=" 8.png "alt=" Wkiom1zpm33xpachaafdq6l4wus525.png "/>

After the client is installed, you need to configure the network service name of the database locally, or you cannot connect Plsql, click Net Manager

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/77/84/wKioL1ZpM_CSdc-vAAAwGyup4Ms188.png "style=" float: none; "title=" 9.png "alt=" Wkiol1zpm_csdc-vaaawgyup4ms188.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/77/84/wKioL1ZpNPqS7CVFAABzzMIrCh8691.png "style=" float: none; "title=" 10.png "alt=" Wkiol1zpnpqs7cvfaabzzmirch8691.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/77/85/wKiom1ZpNIfzaavNAAAuPb_9QRg304.png "style=" float: none; "title=" 11.png "alt=" Wkiom1zpnifzaavnaaaupb_9qrg304.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/77/84/wKioL1ZpNPqBtR0BAAAx4cZD21o346.png "style=" float: none; "title=" 12.png "alt=" Wkiol1zpnpqbtr0baaax4czd21o346.png "/>

Enter the IP for the database

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/77/84/wKioL1ZpNPqQ4Tu6AAA2XgQS9W8875.png "style=" float: none; "title=" 13.png "alt=" Wkiol1zpnpqq4tu6aaa2xgqs9w8875.png "/>

Install Plsql now

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/77/85/wKiom1ZpNIjhX-aXAABKs7G-qjg097.png "style=" float: none; "title=" 14.png "alt=" Wkiom1zpnijhx-axaabks7g-qjg097.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/77/86/wKiom1ZpNRnzttw2AACGkQ7zgKY935.png "style=" float: none; "title=" 15.png "alt=" Wkiom1zpnrnzttw2aacgkq7zgky935.png "/>

Enter the correct user name password to select the corresponding library

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/77/84/wKioL1ZpNYzSZRPyAABChOus2yM252.png "style=" float: none; "title=" 16.png "alt=" Wkiol1zpnyzszrpyaabchous2ym252.png "/>

3. Installing the DB2 Database

The DB2 database, like Oracl, is also required to install the client, installing the client first

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/77/86/wKiom1ZpNRmS930yAAANAQar0PI749.png "style=" float: none; "title=" 17.png "alt=" Wkiom1zpnrms930yaaanaqar0pi749.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/77/84/wKioL1ZpNY6jxO1AAACLBtDnNcw505.png "style=" float: none; "title=" 18.png "alt=" Wkiol1zpny6jxo1aaaclbtdnncw505.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/77/86/wKiom1ZpNRvAcRWcAAB6YaLcxIQ378.png "style=" float: none; "title=" 19.png "alt=" Wkiom1zpnrvacrwcaab6yalcxiq378.png "/>

Select a Typical installation

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/77/84/wKioL1ZpNY_Q4U_OAABdzp3UO_w668.png "style=" float: none; "title=" 20.png "alt=" Wkiol1zpny_q4u_oaabdzp3uo_w668.png "/>

Installing the Connection Tool QC

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/77/85/wKioL1ZpNp3Rm1EmAAAUaoV2_bs001.png "style=" float: none; "title=" 21.png "alt=" Wkiol1zpnp3rm1emaaauaov2_bs001.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/77/86/wKiom1ZpNiuAAX6iAABDAxewTBw962.png "style=" float: none; "title=" 22.png "alt=" Wkiom1zpniuaax6iaabdaxewtbw962.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/77/85/wKioL1ZpNp7RPPXmAAA7jXqwF2A212.png "style=" float: none; "title=" 23.png "alt=" Wkiol1zpnp7rppxmaaa7jxqwf2a212.png "/>

New Database

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/77/86/wKiom1ZpNjDgyDcMAAAP9KRKgTY111.png "style=" float: none; "title=" 24.png "alt=" Wkiom1zpnjdgydcmaaap9krkgty111.png "/>

These two write database IP and database when what system is installed

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/77/86/wKiom1ZpNjCjNwxLAACpZJIJx3k866.png "style=" float: none; "title=" 25.png "alt=" Wkiom1zpnjcjnwxlaacpzjijx3k866.png "/>

Instance name write library name, Port 50000

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/77/85/wKioL1ZpNzfAELfpAACxGjspRSE356.png "style=" float: none; "title=" 26.png "alt=" Wkiol1zpnzfaelfpaacxgjsprse356.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/77/86/wKiom1ZpNsSjUKQSAAATF1IWKnw035.png "style=" float: none; "title=" 27.png "alt=" Wkiom1zpnssjukqsaaatf1iwknw035.png "/>

The user name password to enter the database can be connected

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/77/85/wKioL1ZpNzehwCvvAAAbBd2QHNQ975.png "style=" float: none; "title=" 28.png "alt=" Wkiol1zpnzehwcvvaaabbd2qhnq975.png "/>

Database connection client use (DB2,ORACLE,MYSQL)