Skip to main content

Setting up the MySQL database for Enterprise Server 10

  • Updated

Info: This article contains references to macOS. Running Enterprise Server 10 on macOS is only supported on Enterprise Server version 10.8 or lower.

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:

ClosedInstallation on macOS

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

ClosedInstallation 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

ClosedInstallation 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.

Related articles

Comments

Do you have corrections or additional information about this article? Leave a comment!

Do you have a question about what is described in this article? Please contact support here.


0 comments

Please sign in to leave a comment.