Table of Contents

1. Challenge

   Install and Configure MariaDB

   1. Install MariaDB:

   sudo yum install mariadb-server
   

   2. Ensure the MariaDB service has been started and set MariaDB to start at boot:

   sudo systemctl start mariadb
   sudo systemctl enable mariadb
   

   3. Secure the installation; there is no default password for root. Set a password, remove anonymous users, disallow remote root login, and remove the test database. Reload the privilege tables, following the prompt.

      sudo mysql_secure_installation
      

   4. Access the MySQL CLI as the root user, using the password you just provided:

      mysql -u root -p
      

   5. Create a new database, users; create the user jboss-eap and grant that user access to the database:

      create database users;
      grant all on users.* to 'jboss-eap' identified by 'pinehead';
      

   6. Log out of MySQL:

      exit
      

2. Challenge

   Add a Datasource

   1. Access the JBoss EAP CLI:

      cd /opt/jboss-eap
      sudo ./bin/jboss-cli.sh
      

   2. Connect to the server:

      connect
      

   3. Register the MySQL driver:

      /subsystem=datasources/jdbc-driver=mysql:add(driver-name=mysql,driver-module-name=com.mysql)
      

   4. Create the datasource:

      data-source add --name=MySQLDS --jndi-name=java:/MySqlDS 
      --driver-name=mysql --connection-url=jdbc:mysql://localhost:3306/users 
      --user-name=jboss-eap --password=pinehead
      

3. Challenge

   Test the Connection

   We can test the connection from the CLI with 1/subsystem=datasources/data-source=MySQLDS:test-connection-in-pool.