Appendix D. Installing MySQL

These instructions describe how to install MySQL locally, which may be done for a POC, UAT, or other testing environment.

  1. Install MySQL.

    2. You can get the repository from: https://dev.mysql.com/downloads/repo/yum/.
    For example:

    sudo yum install https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
    sudo yum install mysql-server

  2. Start MySQL.

    3. sudo systemctl start mysqld
    sudo systemctl status mysqld

    During the installation process, a temporary password is generated for the MySQL root user. Locate it in the mysqld.log with this command:

    sudo grep 'temporary password' /var/log/mysqld.log

  3. Configure MySQL.

    4. sudo mysql_secure_installation

    This command prompts for the default root password and then requires you to change it.

  4. Test MySQL.

    5. mysqladmin -u root -p version

  5. Create the database for CASPClosedUnbound’s Crypto Asset Security Platform (“CASP”) provides the advanced technology and the architecture to secure crypto asset transactions..
    1. Log into MySQL.

      2. mysql -p<root password> -u root

    2. Create the database called casp.

      3. create database casp

  6. Load the CASPClosedUnbound’s Crypto Asset Security Platform (“CASP”) provides the advanced technology and the architecture to secure crypto asset transactions. schema.

    7. mysql -p<root password> -u root casp < /opt/casp/sql/casp-mysql.sql