How to Connect MySql from Eclipse using Data Source Explorer

Question

I need help. Could you please answer these question? I would like to connect eclipse to my database and I have tried these in eclipse: Window>Show View>Other>Data Source Explorer. After that we get Database Connections under the eclipse and then right click on the database connection and click on New... then select MySql under Connection Profile Types: and I click on New Driver Definition. Under New Driver Definition dialog, there exists MySql JDBC Driver with specific System Version. I choose one, but the OK button is disabled. Also at the top it says: "Unable to locate JAR/zip in file system as specified by the driver definition: mysql-connector-java-xxx-bin.jar".

How can I specify a Driver Template and Definition Name under New Driver Definition dialog of Data Source Explorer (in Data Tools Platform)

Mr.Fredrick Gauss i have install the MYSQL 5.1 but it showing the same error ...... is there any other method to slove these problem ? Will Know the another method could please post it — DurgaPrasad Ravula, Aug 11 '15 at 12:10

score 9 · Answer 1 · answered Aug 11 '15 at 07:17

9

I dont know your Eclipse version or your MySql server version but for Kepler and mysql 5.5 server, here what I did. First I downloaded mysql connector java jar file(mysql-connector-java-5.1.36-bin.jar) from http://dev.mysql.com/downloads. Then On the New Driver Definition dialog page, I choose MySQL JDBC Driver|MySQL|5.1 under Name/Type tag. Go to JAR List tab Clear all and Add JAR/Zip... and choosed my already downloaded jar file. Finally at the Properties tab I filled them like this:

Connection URL: jdbc:mysql://localhost:3306
Database Name: MyDatabaseNameHere
Driver Class: com.mysql.jdbc.Driver
Password: MyPasswordHere
User ID: root

In the end, OK butten changed to enabled and that is all.

answered Aug 11 '15 at 07:17

Fredrick Gauss

5,126
1
28
44

my eclipse version is mars latest version , my Sql version is 5.6 – DurgaPrasad Ravula Aug 11 '15 at 07:29
please consider my error here Error : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO) – DurgaPrasad Ravula Aug 11 '15 at 07:30
while iam doing what i mentioned the procedure i get these error Unable to locate JAR/zip in file system as specified by the driver definition: mysql-connector-java-5.1.0-bin.jar. – DurgaPrasad Ravula Aug 11 '15 at 07:35
what is your operation system? did you downloaded .jar file from mysql site? – Fredrick Gauss Aug 11 '15 at 07:46
ya i have downloaded the file . – DurgaPrasad Ravula Aug 11 '15 at 12:11
you should have connected to your mysql instance from command prompt/terminal before setting the connection properties just to make sure connection string is ok – Fredrick Gauss Aug 11 '15 at 13:00
Just now i checked in command prompt ....... Connection is ok . and i have downloaded operating system windows7 x64bit – DurgaPrasad Ravula Aug 12 '15 at 04:38
last status:Just now i checked in command prompt ....... Connection is ok . and i have downloaded operating system windows7 x64bit – – DurgaPrasad Ravula Aug 12 '15 at 11:18
error:Unable to locate JAR/zip in file system as specified by the driver definition: mysql-connector-java-5.1.0-bin.jar – DurgaPrasad Ravula Aug 12 '15 at 11:19
Thank you Fredrick Gauss for supporting to my project – DurgaPrasad Ravula Aug 13 '15 at 04:55
I see you didnt do what i suggested. You need to download mysql-connector-java-5.1.0-bin.jar file from internet. In the JAR tab you need to edit its path. – Fredrick Gauss Aug 13 '15 at 07:58
I am getting connection success but SSL file is not there ... could any one no the problem ?please tell me..... – DurgaPrasad Ravula Aug 14 '15 at 09:45
Your problem and your definitions are not clear so I think no one would try to solve your problem. I think you have to get online-interactive support.Maybe [chat] . Or you can prepare a video demonstrating what are you doing during these steps. – Fredrick Gauss Aug 14 '15 at 11:39
still got the same error; com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client – Francesco Dassisis Jul 02 '20 at 19:43

score 4 · Answer 2 · answered Aug 22 '16 at 09:47

4

I also faced same issue. Just download the specific mysql JAR file needed. Now you need to add it to the JAR files tab. But before doing it click on clear all. That is the important step.

answered Aug 22 '16 at 09:47

Binoy S Kumar

289
4
9

How to Connect MySql from Eclipse using Data Source Explorer

2 Answers2