Tip: Use SQL Developer to connect to MySQL database
Most of the people use Oracle SQL Developer to connect to Oracle database only.
We can use SQL Developer to connect to MySQL and SQL Server databases also.
To connect to different types of databases, we have to use appropriate drivers in SQL Developer.
Here I am showing configuring SQL Developer to connect to MySQL Database
Step 1: Download the driver file from the below URL
Step 2: Extract .zip file and get "mysql-connector-java-5.0.8-bin.jar" file.
Step 3: Now open SQL Developer navigate to the below path to add the above jar file.
Tools -> Preferences -> Database(expand it) -> Third Party JDBC Drivers
Step 4: Click "Add entry" button and browse previously extracted .jar file.
Most of the people use Oracle SQL Developer to connect to Oracle database only.
We can use SQL Developer to connect to MySQL and SQL Server databases also.
To connect to different types of databases, we have to use appropriate drivers in SQL Developer.
Here I am showing configuring SQL Developer to connect to MySQL Database
Step 1: Download the driver file from the below URL
Step 2: Extract .zip file and get "mysql-connector-java-5.0.8-bin.jar" file.
Step 3: Now open SQL Developer navigate to the below path to add the above jar file.
Tools -> Preferences -> Database(expand it) -> Third Party JDBC Drivers
Step 4: Click "Add entry" button and browse previously extracted .jar file.
Step 5: We are almost done. Now try to create new connection in SQL Developer.
Step 6: Now you will see new tab for MySQL Database in connection creation window.
Similarly we can find other jdbc drivers to connect to other database types.
CHEERS :)
Great post.
ReplyDeletehttps://www.viki.com/users/aftabkasem41_620/about
Interesting blog, here a lot of valuable information is available, it is very useful information Keep do posting i like to follow this informatica online training
ReplyDeleteSAP BW on Hana training
sap sd training
osb training
oracle scm training
abinitio training
spark training