Logo Help Center

Setting up the MySQL database for Enterprise Server 10

Setting up the MySQL database for Enterprise Server 10

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:

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.

Was this article helpful?
0 out of 0 found this helpful / Created: / Updated:
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.