MySQL

1. System specification

• Operation system + Window, macOS, Linux
• Operation system + 2 Core CPU + 2GB RAM

2. Explanation

• Reason why we use this version in current guided document
  • Support Amazon RDS and MySQL Community Edition version 8.0, 5.7
  • In CALS, version 8 is used, so local version needs to be compatible to use.

3. Installation

1. After click on mysql download and access homepage, click on Select Version and then download latest version 8.0

   

2. Run downloaded installation file, select full options and then click on Next button.

• Developer Default : Install all products required for MySQL development

• Server only : Install MySQL server only

• Client Only : Install all product required for development except MySQL server

• Full : Install all product provided in MySQL.

• Custom : can control over all packages that user want to install and installation path that user want to use.

  

3. Review the requirements and click the Next button to continue.

   

4. If a popup appears with the message Product with missing requirements will not be installed or upgraded, click the Yes button.

   

5. A list of packages to be installed will be displayed. Click Execute to proceed with the installation.

   

6. Once the installation is complete, click the Next button to continue.

   

7. The following section displays the installation readiness status. Click the Next button to proceed.

   

8. Verify that Standalone MySQL Server / Classic MySQL is checked and click on Next button.

• Standalone MySQL Server / Classic MySQL Replication : Configure initial of Standalone MySQL server.

• Sandbox InnoDB Cluster Setup (for testing only) : create and configure InnoDB Cluster Sandbo instance in local to test

  

9. Check that Config Type is to Development Compute and then click on Next button.

   ※ Port 3306 is default but can change into the type that you want to use.

   

10. Set the initial password for root account, click on Next button.
    If you choose a simple password, a warning that it may be weak in term of sercurity.

11. This setting window for registering in Window service to run continuously in background.
    Click on the Next button to set it as default.

    

12. Click on Execute button and execute server configuration.

 ![Alt text](../../../../assets/extension/lambda/install/sql/sql12.png)

13. Once the server configuration is finished, click on Finish button.

 ![Alt text](../../../../assets/extension/lambda/install/sql/sql13.png)

14. The screen displays a list of product configuration. Click on Next button to continue.

    

15. Input password configured in root account and click on Check button.
    After verifying successfully to MySQL Server, click on the Next button.

    

16. Click on Execute button to apply the option listed in Configuration Steps.

 ![Alt text](../../../../assets/extension/lambda/install/sql/sql16.png)

17. Once the configuration is finished, click on Finish button.

 ![Alt text](../../../../assets/extension/lambda/install/sql/sql17.png)

18. Once installation is finished, click on Finish button.

    

1.1. After that, connect to localhost with DB Client.

※ Guide document proceed with dbeaver.

1.2. After establishing the connection, open editor and create following query. Execute it to verify that server is functioning properly.