Installing MySQL

Learn how to install MySQL databases for CSP components

  1. Log in to the node on which you want to install the MySQL metastore.
  2. Install MySQL and the MySQL community server, and start the MySQL service:
    yum localinstall \
    https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
    
    yum install mysql-community-server
    
    systemctl start mysqld.service
  3. Obtain the randomly generated MySQL root password.
    grep 'A temporary password is generated for root@localhost' \
    /var/log/mysqld.log |tail -1
    
  4. Reset the MySQL root password. Enter the following command. You are prompted for the password you obtained in the previous step. MySQL then asks you to change the password.
    /usr/bin/mysql_secure_installation