![]() The official recommends using connector / J 8.0 above MySQL 5.6 The corresponding version of MySQL connector Java and Java: * MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, and 5.6. ![]() Summary of Connector/J Versions Connector/J version The corresponding versions of MySQL connector Java, MySQL and Java If the connection is successful, click Connect to pull OK We usually fill in orcl, depending on the situationĪfter filling in, you can click test. Xe in Sid input box indicates Oracle concise version. SID / Service Name: select one of the two. Port number: depending on the database to be connected, most of them are 1521 by default Host name: the * * IP * * address of the server where the database is located Password: enter the * * password of the connected database** User name: Specifies the * * user account of the database to connect to** Switch to granted roles tab, role name DBACheck the granted and default values, and click applyīy default, only Oracle can be connected, and other data needs to be configuredĬonnection name: you can write it by yourself In the user tab, fill in user name, new password and confirm password fill in the connection name, fill in the user name used to connect to the database, fill in the password corresponding to the user name, and fill in the first connection SYSTEM, fill in the entered when creating the database, and create other users after the connection is successful, and fill in the of the host where the database is located IP address, connect to local database localhost, fill in the database connecting to the ECS Public IP of cloud server, fill in the port number of the database, default 1521 fill in of the database, click the button below, the status will appear in the lower left corner: success information, click to connect successfullyĪdd the database successfully connected in the left tree, right-click other users, and click create user to open the create user window Right click the Oracle connection tab on the left, and click new connection to open the new / select database connection window Unzip downloaded zipFiles (can be unzipped to any location)Ĭonnect to the Oracle database and run the sqldeveloper.exe You can put Navicat and PLSQL tools aside for a while, and then step into the main topic,įirst, we go to the Oracle official website to download SQL developer (about 300 MB), which needs to be supported by JDK 1.8, so we need to configure the JDK 1.8 environment firstĭownload address: /technetwork/developer-tools/ sql-developer/downloads/index.html You can directly connect Oracle and MySQL in SQL developer. The popular databases in front of the market support connection. Oracle SQL Developer It is a very powerful and open-source SQL development tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |