[Notes: This is an excerpt (Section 25.6) of Chapter 25, Accessing Databases with JDBC, from our best-selling textbook Java How to Program, 6/e. This tutorial may refer to other chapters or sections of the book that are not included here. When you purchase this book you also get free access to the Web-based Java Multimedia Cyber Classroom, 6/e, for six months. The Cyber Classroom includes audio descriptions of the examples in Chapters 1-14, solutions to approximately one-half of the end-of-chapter exercises, interactive true/false self-assessment questions and a searchable Web-based e-book. Permission Information: Deitel, Harvey M. and Paul J., JAVA HOW TO PROGRAM, ©2005, pp. 1206-1207. Electronically reproduced by permission of Pearson Education, Inc., Upper Saddle River, New Jersey.]

Java RowSet Tutorial, Setup Part 2: Instructions on Setting MySQL User Account

For the JDBC examples in this book to execute correctly, you need to set up a user account that allows users to create, delete and modify a database. After MySQL is installed, follow the steps below to set up a user account (these steps assume MySQL is installed in its default installation directory):

C:\mysql\bin>mysql -h localhost -u root

mysql> USE mysql;
mysql> INSERT INTO user SET Host='localhost', User='jhtp6',
       Password=PASSWORD('jhtp6'), Select_priv='Y',   
       Insert_priv='Y', Update_priv='Y', Delete_priv='Y',
       Create_priv='Y', Drop_priv='Y', References_priv='Y',
       Execute_priv='Y';
mysql> FLUSH PRIVILEGES;
mysql> exit;