Thursday, 1 October 2015

Install mysql on your system and connecting it to NetBeans

1) Download mysql setup for your system for e.g. mysql-5.6.26-winx64.
2) Copy it in any folder at any location.
3) And set Variable home for my sql like below.
4) Add the above variable(with bin) in path variable.
5) Now go to bin folder of mysql and run mysqld.exe to run mysql.
6) To verify if mysql is connected or not, run cmd and type mysql. It should be like below.

7) Now for connection to Nebeans, go to services tab in NetBeans >>Serivces Tab >> Databases
8) Right click on the Databases  >> 
            New Connection >> 
            Select MySQL(Connector/J driver) >> 
            Select Driver File(if not there) mysql-connector*bin*.jar >> 
            Next >> 
            Fill the details (Generally passwrod is empty for root user) 
            Next >>
            Finish.
9) One option will be there to connect. Connect the database and use.

No comments:

Post a Comment