Configure MariaDB:

  • Install the MariaDB Server and Client packages:
1dnf install -y mariadb mariadb-server
  • Enable and Start the MariaDB service using systemctl:
2systemctl enable mariadb.service
3systemctl start mariadb.service
  • Secure the MariaDB installation:
4mysql_secure_installation
  • Answer the questions as follows:
    • Enter current password for root (enter for none): Press Enter (there is no password)
    • Switch to unix_socket authentication [Y/n] Press n for no
    • Change the root password? [Y/n] Press n for no
    • Remove anonymous users? [Y/n] Press y for yes
    • Disallow root login remotely? [Y/n] Press y for yes
    • Remove test database and access to it? [Y/n] Press y for yes
    • Reload privilege tables now? [Y/n] Press y for yes

Create a Database:

  1. Login to Webmin on the Web Server from your Client: https://192.168.g#.s#5:10000
  2. Refresh the modules
  3. Go to Servers: MySQL Database Server
  4. Click create a new database
  5. Name it wordpress
  6. Character set is: utf8 (UTF-8 Unicode)
  7. Collation order is: utf8_bin (UTF-8 Unicode)
  8. Click create
  9. Click User Permissions
  10. Create a new user named, wpuser
  11. Set password to our course password
  12. Allow any hosts
  13. Click create
  14. Return to database main page and click Database Permissions, then select Create new database permissions
  15. In the Databases section, select your new database from the dropdown
  16. Set the Username to wpuser
  17. Set the Hosts to Any
  18. Select all of the permissions
  19. Click the Create button
  20. Poweroff your server and take a Snapshot
  21. Once snapshot is finished, power your server back on