Installing MySQL 8.0 for SailPoint IQ: A Step-by-Step Guide

SailPoint IQ is a powerful identity governance solution, and to make the most of it, you need a reliable database backend. MySQL 8.0 is a popular choice, offering robust performance and compatibility.

In this guide, I’ll walk you through the step-by-step process of installing MySQL 8.0 on a Windows machine and configuring it for your SailPoint IQ 8.4 deployment.

Step 1: Download MySQL 8.0

1. Visit the official MySQL downloads page https://dev.mysql.com/downloads/mysql/
2. Select the Windows operating system.
3. Choose the MySQL Community Server version.
4. Download the Windows installer (MSI) package.

Step 2: Run the Installer

1. Double-click the downloaded MSI file to launch the installer.
2. Choose the Custom installation type for greater control over the process.
3. Follow the on-screen prompts to select the installation directory and desired components.

Step 3: Set Root Name and Password

1. During configuration, you’ll be asked to create a MySQL root account.
2. Choose a strong and secure password. Store it safely, as you’ll need it to administer your database.

Step 4: Set Port to 3306

1. Ensure the default MySQL port 3306 is set. This is crucial for smooth communication with SailPoint IQ.
2. If the port is in use by another application, you’ll need to change it, ensuring you note the new port number for later configuration in SailPoint IQ.

Step 5: Complete the Installation

1. Proceed through the remaining installation steps.
2. Important: Leave the “Start the MySQL Server at System Startup” option selected, so your database is always available.

Step 6: Connect to MySQL

1. Open a command prompt (cmd.exe).
2. Navigate to the MySQL installation directory (e.g., cd C:\Program Files\MySQL\MySQL Server 8.0\bin)Type:

mysql -uroot -p

and press Enter.

3. Enter the root password you created during installation.

Step 7: Verify Installation

1. Once connected, run the command:

show databases;

2. You should see a list of default databases, ensuring installation was successful.

Step 8: Configure SailPoint IQ

1. During your SailPoint IQ 8.4 installation, you’ll be prompted to provide database connection details.

That’s it! You’ve successfully installed MySQL 8.0 and configured it for SailPoint IQ 8.4 on Windows. You’re now ready to begin on efficient identity governance.

Let me know if you would like me to refine this further or write additional stories related to SailPoint IQ!