Windows : [JEE Environment] MySQL : Installation, Configuration and Final Deployment
posted 20 November 2005, Sunday
MYSQL INSTALLATION
The MySQL version we are installing is version 5.0. Version 4.X maybe more stable and more familiar to most developers, but the belief of using the newest and most competent version is the only justification for version 5.0's use in the target environment.
The installation file name for the version 5.0 is mysql-5.0.15-win32.zip.
Since you'll be at the site downloading the MySQLadmin mysql-administrator-1.1.5-win.msi.
Now that we have the download the installation steps are listed below:
- Unzip mysql-5.0.15-win32.zip to our staging directory c:\Scratch which reults in a full directory path of C:\Scratch\mysql-5.0.15-win32
- Launch C:\Scratch\mysql-5.0.15-win32\Setup.exe
- Follow the steps of the setup installer.
- Select custom installation
- Install to C:\Servers\MySQL5.0\
- Add Script Examples (Figure 4)
Selecting script examples provides reasonable study information.
Figure 4
Figure 5
- (Figure 5)
Figure 5- (Figure 6)
Lets go ahead and configure the system now. Essentially, in windows we will make this a webservice and automatically have it start. If you are running SQL Server, postGres etc.... You'll have to make a decision if you would like this installed as a service.
- (Figure 7)
- (Figure 8)
- (Figure 9)
- (Figure 10)
- (Figure 11)
- (Figure 12)
- (Figure 13)
- (Figure 14)
- (Figure 15)
- (Figure 16)
- (Figure 17)
Figure 6
Continue to configure instance.
Figure 7
Select detailed configuration in order to control the service but most importantly so we can see what exactly is gettting configured.
Figure 8
Since we are developing and learning new technologies with this "Base Line JEE" evinronment our configuration will be to choose the Devloper Machine.
Figure 9
Select transactional is chosen as we get into transcational inmplementations in the future to describe, demonstrate and implement transactional solutions.
Figure 10
This solution falls under a low volume of connections, as a resutl the Decision Support (DSS)/OLAP is selected.
Figure 11
Setup TCP/IP networking and port assignment.. Leave defaults.
Figure 12
Select Character set that fits your situation.
Figure 13
Choose windows service, select service name of "MySQL" or a name that suits you, and finally insure the bin directory is in the path in order to launch tools from a command prompt. ie : MySQL.exe
Figure 14
Set a password and naturally on that you will remember. I do not enable root access as this is my development computer and no need to access it remotely. If you feel comfortable with enabling root acces and know enough about the concerns do what you feel is best. This document does not suggest enabling root access.
Figure 15
Let her rip!!
Figure 16
Confirmation is shown on successful implementation. you may receive a message that request a retry as the service did not startup in the speccified time the progtram alotted. Its best to check the services and insure MYSQL is running. If not wait, either way wait a reasonable amount of time and try again.
Figure 17
Next step is to check the validity and accurate installation.
Execute the MYSQL shortcut. You'll be prompted for a password. Enter your password.
Enter show databases:
mysql> show databases;
+--------------------+
| Database
+--------------------+
| information_schema
| mysql
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> use test;
Create a table foo in Database "test"
mysql> CREATE TABLE foo (a TINYINT NOT NULL);
Query OK, 0 rows affected (0.58 sec)
mysql> show tables;
+----------------+
| Tables_in_test
+----------------+
| foo
+----------------+
1 row in set (0.00 sec)
NOTE: If you received the results above MySQL is installed correctly
MYSQL ADMIN INSTALLATION
MySQL's admin tool is a fairly new tool and provides a better interface than the standard MySQL.exe. The installation is fairly simple and
will require the username and password that was created in the MySQL DB installation.
Goto the folder C:\Scratch\MySQLAdmin and execute the mysql-administrator-1.1.5-win.msi installation. Install the Tool in the following directory:
C:\Servers\MySQL\MySQL Administrator 1.1\