A.3 Create a MySQL Database for Core JSTL Examples

A.3 Create a MySQL Database for Core JSTL Examples

To create the database used in this book's examples, you must be running MySQL and you must start the MySQL administrative tool.

When you install MySQL, you can specify whether you want MySQL to start when you boot your computer. If you chose not to start MySQL at startup, you will need to start it manually. To do that, go to the $MY_SQL/bin directory (where $MY_SQL is the directory in which you installed MySQL ”presumably that directory is C:\mysql ) ”and double-click on the icon for the MySQL administrative tool, which is circled in Figure A-4.

Figure A-4. The MySQL bin Directory and the MySQL Administrative Tool

If you chose to start MySQL when you boot your computer, you should see a stoplight in your task bar. If you click on that stoplight, you will see a pop-up menu with a Show me menu item. If you select that menu item, the MySQL administrative tool window will open .

After you start the MySQL administrative tool, either by double-clicking the icon circled in Figure A-4 or by selecting the menu item in your task bar, you should see a window like the top picture in Figure A-5.

Figure A-5. The MySQL Administrative Tool for Windows

You need to create one database for this book's database examples, so click on the Database tab in the MySQL administrative tool, and you should see something similar to the bottom picture in Figure A-5.

To create a database, right-click on your computer's name (that name is MARIKO in Figure A-6) and a pop-up menu will appear. Select Create database from that pop-up menu and type the name of the database in the dialog box that is displayed, as shown in the top picture in Figure A-6. You need to create a database named core-jstl .

Figure A-6. Creating the Core JSTL Database

When you have created the database, your MySQL administrative tool should look like the bottom picture in Figure A-6.