JDBC for MySQL - Herong's Tutorial Examples

∟MySQL Installation and Setup

This chapter provides tutorial notes on MySQL installation and setup. Topics include downloading, installing and starting MySQL database server; using mysqladmin tool; using command line tool; creating new database and new user.

MySQL Installation on macOS

MySQL Installation on Windows

mysqladmin - MySQL Admin Tool

mysql - Command Line Tool

Creating Database and User with MySQL Monitor

Takeaways:

• MySQL Community Server is a free open source database server.
• Downloading and installing MySQL Community Server is really easy and simple.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

►MySQL Installation and Setup

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Using Connection Pool with JDBC

 Archived Tutorials

 References

 Index

 Full Version in PDF/EPUB

MySQL Installation and Setup - Updated in 2026, by Herong Yang