Skip to main content

Notice: Temporary shutdown of WoodWing Cloud Studio environments due to a critical PHP security release. Learn more

English (United States) Nederlands

Setting up the MySQL database for Enterprise Server 9

Updated

Note: Enterprise Server 9 is fully compatible with MySQL versions 5.0 and 5.1. However, we encourage customers to use MySQL 5.5.

Installing the MySQL database

The steps below refer to performing a clean installation of MySQL 5.5, or to performing an upgrade.

Clean installation

When performing a clean installation, follow the instructions as outlined on dev.mysql.com:

Upgrade

When performing an upgrade, follow these steps:

Step 1. Upgrade the version of MySQL.

See http://dev.mysql.com/doc/refman/5.5/en/upgrading.html.

Additional info for Windows: http://docs.oracle.com/cd/E17952_01/refman-5.5-en/windows-upgrading.html.

Step 2. Migrate the data.

See http://dev.mysql.com/doc/refman/5.5/en/faqs-migration.html

Note: For information about performance and scalability, see http://dev.mysql.com/tech-resources/articles/introduction-to-mysql-55.html.

Installing phpMyAdmin

Choose the platform on which you want to install phpMyAdmin:

Installation on Mac OS

Step 1. Copy the phpMyAdmin folder to the Web root.

Location: /Library/Web Server/Documents

Step 2. Open the file config.inc.php (found in the main phpMyAdmin folder) in your favorite editor and do the following:

Note: See the Configuration section in the file for an explanation of all values.

Step 2a. Change the following values to fit your environment:

  • Host (Here, Host means the MySQL server.)
  • User
  • Password
  • Authentication Mode

Step 2b. Insert the correct value for $cfg[‘PmaAbsoluteUri’].

Step 3. Test the phpMyAdmin page by accessing the following URL:

http://localhost/phpMyAdmin/index.php

Installation on Windows

Step 1. Copy the phpMyAdmin folder to the Web root.

Location: /Library/Web Server/Documents

Step 2. Open the file config.inc.php (found in the main phpMyAdmin folder) in your favorite editor and do the following:

Note: See the Configuration section in the file for an explanation of all values.

Step 2a. Change the following values to fit your environment:

  • Host (Here, Host means the MySQL server.)
  • User
  • Password
  • Authentication Mode

Step 2b. Insert the correct value for $cfg[‘PmaAbsoluteUri’].

Step 3. Test the phpMyAdmin page by accessing the following URL:

http://localhost/phpMyAdmin/index.php

Installation on Linux

Step 1. Perform the installation according to the type of Linux distribution: RPM, Apt, or manual download.

Note: For more information about the correct installation procedure, visit www.phpmyadmin.net/home_page/downloads.php.

Step 2. Open the file config.inc.php (found in the main phpMyAdmin folder) in your favorite editor and do the following:

Note: See the Configuration section in the file for an explanation of all values.

Step 2a. Change the following values to fit your environment:

  • Host (Here, Host means the MySQL server.)
  • User
  • Password
  • Authentication Mode

Step 2b. Insert the correct value for $cfg[‘PmaAbsoluteUri’].

Step 3. Test the phpMyAdmin page by accessing the following URL:

http://localhost/phpMyAdmin/index.php

Creating the database

Step 1. Access http://localhost/phpMyAdmin/index.php.

The phpMyAdmin page appears.

Step 2. From the MySQL Connection Collation list choose utf8_general_ci.

Step 3. In the Create a New Database box, enter the name Enterprise.

Step 4. Click Create.

Note: For information about performance and scalability, see http://dev.mysql.com/tech-resources/articles/introduction-to-mysql-55.html.

Reference Materials

Enterprise Server 9 documentation

Related articles

Comments

0 comments

Please sign in to leave a comment.