How to Connect to MySQL Database in Eclipse IDE

[@bytegraftkids]

Thank you for taking out your time and patiently explaining everything in detail.

[@CodeJava]

Glad it was helpful!

[@vinayvini2628]

I am not finding that database development in an open-perspective path

[@CodeJava]

so you need to install database development tools via menu Help > Eclipse marketplace

[@namjoonsbrokewife159]

Hi! after I added JPA, my schema folder is not opening in the Data Source Explorer. please help me

[@aryajha4428]

I am not getting database development option in open perspective Any tips please?

[@CodeJava]

kindly follow this video: kzbin.info/www/bejne/nKmaXpV7opWdipI

[@vijaykumar-wu9jc]

Thank u for this video , from long time am using eclipse I was not knowing , now I learned this

[@CodeJava]

You are most welcome. I also know it recently.

[@All_In_One_Go_2002]

which password should we use @ 6:00 min. While giving test connection I am getting as ping failed. Please say what will the error, why I am getting as ping failed.

[@CodeJava]

that error means MySQL server is not running. So make sure it is running first.

[@cityisbetter]

5:49 it shows ''ping failed'' for me, pls help

[@CodeJava]

check MySQL server, make sure it is running and listening on the port you expect. Also check username and password, which maybe incorrect.

[@cityisbetter]

@@CodeJava thanks for the reply, i only had MySQL workbench open, later on realized i need to have MySQL server open

[@solitaryrocky1541]

In the JAR list, it doesn't let me add JAR/zip. Do I need to have JDBC drivers in the Name/Type tab?

[@CodeJava]

yes, you should see some JDBC drivers in that tab.

[@TrangPham-u5i]

Thank you for your sharing. Your video is very helpful. I have successfully set up the connection in my Eclipse.

[@CodeJava]

Glad it helped

[@lexigeib]

Hello, when you click on the page to specify the driver and you click on the mySQL JDBC Driver I don not have any versions being displayed. I went into prefrences and looked there too but the only drivers that are available are for ubuntu and linux. Is there more software I need to download in order to access the JDBC drivers?. I cannot add the jar file until I click on a version but there are no versions to click. Thank you.

[@CodeJava]

No more software needed. If you don't see any MySQL JDBC version, you can create a new generic JDBC driver and specify the database properties as shown in the video.

[@dvhuzg]

i'm using Eclipse IDE for Java Developer and it doesn't have Database Connection, so must I download the Eclipse Enterprise to use this function?

[@CodeJava]

Yes, or you can install a plugin. Follow this video: kzbin.info/www/bejne/nKmaXpV7opWdipI

[@shradhakamble9647]

Sir in my mysql open perspective no database development file there Pls reply sir🙏🏻

[@CodeJava]

kindly follow this video: kzbin.info/www/bejne/nKmaXpV7opWdipI

[@KCReddy24]

How come the database have tables ...was it created by you ? please explain

[@CodeJava]

yes, that's right. Suppose that we have an existing database before.

[@shammimunnisa1385]

Test connection throwing error: Ping failed,java.net.ConnectException MESSAGE: Connection refused: connect

[@wastedtv3853]

when i go to the open perspective portion i dont have any option for database development. what other option can i use to do this?

[@CodeJava]

check this video: kzbin.info/www/bejne/nKmaXpV7opWdipI

[@amb7247]

Is the ping failed due to Mysql not running on a server. Our user is trying to connect to it over VPN. Assuming we can cmd prompt ping the same server's hostname. Wasn't sure about other factors such as Db name, user/pass or port #. I never used the eclipse ide so I'm flying blind in support for the user.

[@CodeJava]

I think it would be firewall, network config issues in your case.

[@naumanarshad1146]

@@CodeJava how to solve it sir?

[@bercinn-g]

hi, thanks for this informative video but ı have an issue when ı try to make a conncection profile ı cannot see database development option in the open perspective part. How can ı fix it?

[@CodeJava]

you need to install it. Follow this video: kzbin.info/www/bejne/nKmaXpV7opWdipI

[@drfrost938]

i have mysql version6.3 can i still connect it? with this connector?

[@CodeJava]

it depends on the version of JDBC driver. Check compatibility on MySQL website.

[@drfrost938]

@@CodeJava im using mysql workbench 6.3 ce i hope its compatible

[@drfrost938]

anyway thank you for the video its good!

[@CharanMuktha]

But connection is empty sir in new ->data resource

[@jaisuriyar5259]

5:48 it shows "ping failed" while testing.

[@CodeJava]

Is the MySQL server running? Check JDBC URL (host, port, schema). Check username & password. One of this information is incorrect.

[@jaisuriyar5259]

@@CodeJava 👍

[@binduniharika343]

Ping failed while testing

[@DineshGgoogle]

Nice to see the name Rani Kumar Krishna :)

[@CodeJava]

it's a nice name, right?

[@edwinperera9133]

my option for database management in perspective is not showing

[@CodeJava]

you need to install DB tools first. Follow this video: kzbin.info/www/bejne/nKmaXpV7opWdipI

[@favioar]

Thank you very very much !!! Great video, you helped me a lot!! 👏👏👏

[@CodeJava]

Glad it helped!

[@alternativerey5127]

hey bro now i feel in love whit your knowledge

[@CodeJava]

So nice of you. Thanks for watching :)

[@muralikrishna1408]

After specifying the driver connection details, in the test connection process Iam getting the ping failed .what to do?

[@CodeJava]

Check if MySQL server is running or not.

[@niktacgaming6493]

How to check mysql is running??

[@CodeJava]

@@niktacgaming6493 if you're on Windows, open Task Manager, go to Services, look for MySQL

[@cardenaskristoffercharlesb7170]

Hi, thank you for uploading this. It is very helpful, but I have an issue whenever I try to test the connection, the ping always failed. How can i fix it? thank you

[@CodeJava]

is MySQL server actually running? Also check typos in JDBC URL, username, password...

[@hnq145]

Sao nhiều người dùng MySQL để kết nối với Java mà ko dùng Microsoft SQL Sever vậy ạ??? Mong a giải thích

[@CodeJava]

đơn giản vì MySQL là mã nguồn mở, nhẹ, nhanh nên phổ biến hơn SQL Server, vốn chủ yếu dùng trong doanh nghiệp.

[@farzanabegum708]

Thank you for your time. I have a question what is the difference if I connect database by using Query as Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","Password");

[@CodeJava]

the syntax may differ, yet the purpose is the same.

[@farzanabegum708]

@@CodeJava Thank you, Sir

[@User45823]

What is the password required for the root username? Is it my system password or do I need to separately set a new password for mysql? Everytime I'm giving my system password , it is showing error in connection. Please help🙏

[@CodeJava]

the root password is the one you set when installing MySQL server. If you don't remember, you can reset it.

[@User45823]

@@CodeJava i had installed eclipse ide initially then for connecting to mysql i installed the sql connector only...do i need to install anything else apart from it? i don't have any other installations related to sql in my system...

[@CodeJava]

@@User45823 oh, you need to have MySQL server installed on your computer. Or do you have a remote one to connect to?

[@User45823]

@@CodeJavano no I don't have any remote one to connect...then I need to install mysql server...thank you for helping 😊 will come back for help if I face further problems😅

[@chetansingh3284]

Sir database development show hi nhi ho raha h

[@CodeJava]

kindly follow this video: kzbin.info/www/bejne/nKmaXpV7opWdipI

[@surfeurdestemps3193]

Hi , how to connect to h2:mem database from eclipse? 😁

[@CodeJava]

I think it's not possible because H2 memory database runs in the same process of the application, whereas Eclipse database tool runs in another process.

[@surfeurdestemps3193]

@@CodeJava may be like this it's possible : eclipse.github.io/kura/builtin/h2-database.html

[@shivangisahgal3399]

No database development option is coming while opening open perspective

[@CodeJava]

perhaps your Eclipse version is not for Java EE developers. You can install database development from eclipse marketplace (Help > Eclipse marketplace)

[@jackmaxwell3134]

@@CodeJava no it's not. You need to follow @Shaun Pusey's comment here.

[@anumaamir3441]

What is the next step? how are we going to write the queries and java code?

[@CodeJava]

kindly follow this video: kzbin.info/www/bejne/mqaonJtuj9h5fdU and this one: kzbin.info/www/bejne/Z6GkZ2djm9ScsJo

[@tuaninhang2741]

I've tried for many times but it was always Ping Failed, could anyone give me a reason why??

[@CodeJava]

is MySQL running?

[@tuaninhang2741]

@@CodeJava oh yes, thank you. I've fixed my problem. your video is so great. thank you so much

[@melodi4564]

what if i forget my mysql password

[@CodeJava]

then you have to reset your root password. reference: stackoverflow.com/questions/16556497/mysql-how-to-reset-or-change-the-mysql-root-password

[@jimrogers4346]

good tank you my teacher

[@CodeJava]

You are welcome

[@mesleykuvedrieh4679]

I having a problem (ping fail)

[@CodeJava]

Something wrong with JDBC URL (port, user, pass.. incorrect). Or the server is not running.

[@merikhurshudyan7085]

my ping fails why is that?

[@CodeJava]

ensure that MySQL server is running.

[@ktn4]

I didn't know that I can use Eclipse like MySQL workbench in this way :O

[@CodeJava]

yeah, that's the power of an IDE (integrated development environment).

[@biswabikashparida9691]

My ping is getting failed please help

[@CodeJava]

Make sure MySQL server is running. Also check JDBC URL, username and password.

[@XFAWKES94X]

Zlatan? ..

[@CodeJava]

what do you mean?

[@keerthanalokeshkumar2877]

Thanks for this video.

[@CodeJava]

You are welcome.

[@jyotirmaydas5938]

what is the password given

[@CodeJava]

it's the password you set when installing MySQL.

[@yusufmustari]

Thanks dude

[@CodeJava]

Happy to help

[@sultanahmadsabawoon6030]

Yeah, Yea! :)

[@biswajyotidas6236]

Thank u my man

[@CodeJava]

Happy to help