Installing the MySQL Add-on

This section provides instructions for installing the MySQL add-on for Parallels Pro Control Panel 10.3.4. Before installing the add-on, ensure that you have installed the following software on your Parallels Pro Control Panel server:

• MySQL 4.1 or 5.0: For information about downloading and installing the latest version of MySQL, that is, version 5.0, go to MySQL Web site.
• While installing MySQL 5.0, ensure that you accept the default options in the installation wizard except for the following:

  MySQL Server Instance Configuration window:

  • Select the Server Machine option.
  • Select the Non-Transactional Database Only option.
  • Clear the Enable Strict Mode check box.
  • Select the Best Support For Multilingualism option.
  • Select the Include Bin Directory in Windows PATH check box.
• MyODBC 3.51: For information about downloading and installing MyODBC 3.51, go to MySQL Web site. Install MyODBC 3.51 using the default options.

Note: Since the password encryption is different in MySQL 4.1 and 5.0 than its previous versions, you cannot access the database using phpMyAdmin 2.x provided with Parallels Pro Control Panel. To change this password encryption to support phpMyAdmin 2.x:
After installing MySQL 4.1 or 5.0 on the server, go to the directory where MySQL is installed. If you have installed MySQL in the default location, then the path is C:\Program Files\MySQL\MySQL Server < version_no >, where <version_no> is the version of MySQL. For example, C:\Program Files\MySQL\MySQL Server 4.1.
Open the my.ini file present in this directory, type old-passwords in the [mysqld] section, save the file, and close it.
Open a command window, and run the following commands:
net stop mysql
net start mysql
PhpMyAdmin 2.x can now be used to access MySQL 4.1 or 5.0. You can now proceed to installing the MySQL add-on as described below.

To install the MySQL add-on:

1. Connect to the Parallels Pro Control Panel 10.3.4 server using the console or terminal services and log in as the administrator.
2. Browse to the directory where the Parallels Pro Mysql Addon.10.3.4.msi file is present.
3. Run Parallels Pro Mysql Addon.10.3.4.msi.

   The Parallels Pro Mysql Addon installation window opens.

4. Click Next. The Customer Information window opens. It will prompt you to enter a password.

   While installing MySQL 4.1 or 5.0, if you have set the root password, ensure that you specify the same password in this window. If you have not set any root password for MySQL, then do not enter anything in the Password text box.

5. Click Next.
6. Click Install. The progress bar in the window indicates that the add-on is being installed.
7. Click Finish to complete the installation.

   The MySQL add-on is installed.

   An installation log named MysqlInstall.log is created and placed in the < install_dir >\Logs directory, for example, if you have installed Parallels Pro Control Panel 10.3.4 in the default location, then the path is C:\Program Files\Ensim\WEBppliance\Logs. You can view this log file to verify that the add-on has been installed and registered successfully.