Pace CS 396S - Study Notes (6 pages)

Previewing pages 1, 2 of 6 page document View the full content.
View Full Document

Study Notes



Previewing pages 1, 2 of actual document.

View the full content.
View Full Document
View Full Document

Study Notes

66 views


Pages:
6
School:
Pace University
Course:
Cs 396s - TOPIC: Servlets and databases

Unformatted text preview:

MySQL Database and Java Programs Downloading and Installing MySQL MySQL is a free database that can be downloaded from the web site http www mysql com The specific download URL is http dev mysql com downloads index html MySQL can be used to create a database and query it using Structured Query Language SQL After downloading MySQL onto your computer you can install it using the installer that comes with it There is an excellent tutorial on the MySQL web site The URL for it is http dev mysql com doc mysql en Tutorial html This gives extensive information on how to use MySQL To install MySQL after downloading unzip it into a folder called mysql and then in Windows Explorer click on setup exe If you downloaded the version that comes with an installer it will create a directory structure with a number of subfolders The important ones are bin and data The first contains the applications that run the database service and the second is where the databases you create will be stored While you are downloading and installing programs you might also want to get the MySQL Connector ODBC that allows you to connect to a MySQL database server from a Java program This can be found at http www mysql com products connector odbc This file MyODBCstandard 3 51 07 win exe is an application so all you have to do is click on it in Windows Explorer to install it When installed it registers the driver with the Windows operating system Starting and Stopping the MySQL Database Server There are two ways to start the MySQL server The simplest method is to run the file mysqld exe found in the bin folder This will create a Command Prompt window This window cannot be used or closed In order to close it you have to shut down the MySQL server This is done with the command mysqladmin u root shutdown This must be done in a second command prompt window When you type this command the first window will disappear but the second will not You can close it in the usual way with the X in the upper right hand



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Study Notes and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Study Notes and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?