Maxprograms
Software Development & Consulting Services
Site menu:
Swordfish Tutorials
Installation of MySQL 5 on Microsoft Windows
Visit MySQL download page and scroll down until you find Windows downloads. Get Windows Essentials (x86) package from a mirror. You can also click on this direct link to download the program.
Locate the installer (mysql-essential-5.0.15-win32.msi), double-click on it and you will see this welcome image:
Click on Next and the Setup Type screen will appear
Select Typical and click on Next.The installer will inform you the installation type and where the program will be installed in a screen like this:
Click on Install button to start the installation. A dialog with a progress bar will be displayed.
Wait until 100% has been reached and then move to the next step. The following screen will appear:
It is not necessary to login to your existing MySQL account or to create an account to perform the installation. Select Skip Sign-Up and click on Next to complete the installation.
You must now configure MySQL server before you can use it.
Make sure that the option Configure the MySQL Server now is selected and then click on the Finish button. The configuration wizard will start and you will see another welcome screen:
Click on Next button to start the configuration procedure. The following dialogue will be displayed:
Select Detailed Configuration and click on Next to configure the amount of memory that will be assigned to the MySQL server.
Check that Developer Machine is selected. This option gives you the best performance for running Swordfish.
Click on Next to select the type of databases that you will use in the following dialogue:
Select Transactional Database Only. This option ensures that you will not loose data if you encounter a problem while translating.
Click on Next to configure where databases will be stored. Leave default values as they are in the following dialogue.
Do not be tempted to modify the default values. Click on Next and adjust the number of users manually.
Change the number of users to 5. This is enough in most cases. Click on Next to enable TCP/IP protocol.
Accept the default values suggested by the wizard and click on Next once again to select the default character set.
Select Best Support for Multilingualism to set UTF-8 as default charater set. Be careful, make sure that the the middle option is selected and not the default one.
Click on Next and tell MySQL that it should run as a Windows service. Ensure that the upper check box is selected and then click on Next.
In the next screen you must enter a password for "root", the owner of all databases. Select Enable root access from remote machines even if you don't have a network.
Finally, click on the Execute button to finish with the configuration.
A connection error dialog may appear if you are running Windows XP. You will have to adjust the firewall settings if this happens.
If you encounter this problem, keep the error dialog open and do the following:
- Open Windows Control Panel.
- Double click on the "Firewall Configuration" icon and when the firewall applet starts select the "Exceptions" tab at the top.
- Click on the "Add Port" button and a smaller dialogue will appear.
- Enter "MySQL" in the upper text box and "3306" in the lower one.
- Click on "Accept" and MySQL will appear on the list of programs allowed by the firewall.
Close the firewall applet and the Control Panel. Go back to the error connection dialog and click on the Retry button. Let the wizard write a configuration file. If the wizard says that it can't start MySQL service don't worry, it was started in the first attempt.
Restart Windows.
MySQL should be running if you followed all steps.
Start Swordfish and select Create Database from Database menu. Fill the database creation dialogue with these values:
| Database Name | enter a name in one word |
| Database Type | select MySQL 5.x from the list |
| Server Name | localhost |
| Port Number | 3306 |
| User Name | root |
| Password | the password that you assigned to root |
and the database will be created.