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:
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:
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:
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:
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
Comment
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.
0 comments
Please sign in to leave a comment.