Installing MySQL

This section provides a step-by-step guide to installing MySQL.

Procedure

  1. Install the MySQL server. 
    yum install mysql-server
  2. Enable the MySQL server. 
    systemctl enable mysqld
  3. Connect a MySQL database server as the root user. 
    mysql -u root
  4. Create a database named vrm in MySQL. 
    mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| vrm                |
+--------------------+
5 rows in set (0.00 sec)
  5. Create two users cdpapp_rw and cdpapp_ro users along with permissions as shown below. 
    CREATE USER 'cdpapp_rw'@'%' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, RELOAD, REFERENCES, INDEX ON . TO cdpapp_rw@%;
CREATE USER 'cdpapp_ro'@'%' IDENTIFIED BY 'password';
GRANT SELECT ON . TO cdpapp_ro@%;
FLUSH PRIVILEGES;
  6. Finally, copy the initial data dump in the database. 
    # mysql -u <user> -p -P <Port> -D vrm < <path_to_dumpfile> eg. vrm_schema_only_dump.sql
# mysql -u <user> -p -P <Port>-D vrm < <path_to_dumpfile> eg. db_dump.sql