Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Java Data Analysis

You're reading from   Java Data Analysis Data mining, big data analysis, NoSQL, and data visualization

Arrow left icon
Product type Paperback
Published in Sep 2017
Publisher Packt
ISBN-13 9781787285651
Length 412 pages
Edition 1st Edition
Languages
Concepts
Arrow right icon
Author (1):
Arrow left icon
John R. Hubbard John R. Hubbard
Author Profile Icon John R. Hubbard
John R. Hubbard
Arrow right icon
View More author details
Toc

Table of Contents (14) Chapters Close

Preface 1. Introduction to Data Analysis 2. Data Preprocessing FREE CHAPTER 3. Data Visualization 4. Statistics 5. Relational Databases 6. Regression Analysis 7. Classification Analysis 8. Cluster Analysis 9. Recommender Systems 10. NoSQL Databases 11. Big Data Analysis with Java A. Java Tools Index

MySQL Workbench

We will be creating and accessing our MySQL databases by two different methods: by running our own independent Java programs and through a user interface tool named MySQL Workbench.

To download and install MySQL Workbench, go back to https://dev.mysql.com/downloads/ and select MySQL Workbench. Select your platform and click on the Download button. Then, run the installer.

In the window that comes up, drag the MsSQLWorkbench.app icon to the right, into the Applications folder:

MySQL Workbench

Figure A-14. Installing MySQL Workbench

After a few seconds, the app's icon will appear in the Applications folder. Launch it, and affirm that you want to open it:

MySQL Workbench

Figure A-15. Running the MySQL Workbench installer

Note that one connection is defined: localhost:3306 with the user root. The number 3306 is the port through which the connection is made.

Now that we have MySQL Workbench installed, we can test it. The main window for the app is shown in Figure A-16.

MySQL Workbench

Figure A-16. The MySQL Workbench main window...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image