For Windows Users:
1.
Go to www.mysql.org
2.
Click on the downloads tab (http://dev.mysql.com/downloads/)
3.
Click on the large green download button, this will take you to a page
that will allow you to download the MySQL installer
4.
Press the blue download button next to Windows (x86) Msi
Installer 5.5.15.0.msi (185 MB)
5.
You 'll then need to entery your MYSQL user information or create an
account (its free)
6.
You'll eventually end up at a page that allows you to select a mirror
site to download from.
7.
Download and save the MSI file
8. If you are running firewall software, you'll need to enable
port 3306 for MySQL
9.
When the download is complete run the MSI file
*
Follow the instructions, when you get to the Choosing a Setup
Type, pick "Developer Default"
*
When you get to the MySQL Server Configuration, select "Developer
Machine"
*
enter your password for the "root" account, be sure to write this
down or tatoo it to your hand
For MAC Users:
1. You'll need to
download the server and workbench parts separately.
2. Go to http://dev.mysql.com/downloads/
3. Select MySQL Community Server
4. Select MAC OS- X as the platform
5. Download a version that matches
your O.S.
then ...
6. Download a Workbench, go back to
the downloads page
7. Scroll down and select MySQL
WorkBench
8. Select MAC OS X as the platform and
download the .DMG file
For more information, see the installation instructions http://dev.mysql.com/doc/refman/5.5/en/macosx-installation.html
For All Users:
For Java programs:
To create Java programs you'll need to download the connector,
this is a JAR library file
http://dev.mysql.com/downloads/connector/j/
or click here to
get the .jar file
To use MySQL in Netbeans,
Copy the jar file into the project folder (top level)Open the project, right click and select the propertiesClick on the Libararies CategoryPress the add JAR/Folder, then select the
mysql-connector-java-5.1.17-bin.jar file from your project- When you do a build, it will automatically copy the
mysql-connector-java-5.1.17-bin.jar to the lib folder in your dist
folder.
To Create a database
1) Start the My SQL Work Bench - click
here for the image
2) Double click on the "Local instance MySQL55_1_1"
3) Enter your password when requested to do so
4) To create a new database (Schema), click on the yellow cylinder
symbol on the center toolbar click here for
an image
5) Enter a name for the Schema and click "Apply", then click finish. click here for an image
6) Your new schema should appear in the list in the center of the
screen, click on it click here for an image
7) Double click on the Add Table item, click
here for an image
type in a Table name
at the bottom, click on the columns tab and fill in
the columns with their data types click here
for an image
when you are done, press apply
8) to add data to the table, just double click on the table name and
type in the values click here for an image
9) when you are done typing in data, press the green check box icon
(apply changes to data), this will bring up a sql script box, then
press apply. click here for an image
To Import a Database
1) Start the My SQL Work Bench - click
here for the image
2) On the right side of the display near the bottom of the Server
Administration column, select "Manage Import / Export"
3) Click on the "Import from Disk" in the center pane. click
here for the image
4) Turn on the "import from self contained file";
5) Press the browse button (...) to select your .SQL file - click
here for the image
6) Then press the "start import" button in the lower
right of the page
7) In the case of your assignment 4 "registrar.sql" file, this
will create a database called Registrar 4 and load the courses table.