In this tutorial we will go over how to encrypt a text file that we can store in public storage without any security concerns. Suppose you are running an application in a cloud platform, and you are running daily backup of SQL files and want to store it securely in block storage somewhere in the
In this tutorial, I will be using CentOS 7 to generate self-signed certificates. You can use any Linux operating system as long as it is Openssl install. To install Openssl follow the below guide: Openssl installation CentOS, Redhat, Fedora: Ubuntu, Debian Generating certificate with password Command: Interactive view: Verify output Generating certificate without password Command:
To create a new user in MySQL follow the below steps: Create new MySQL user Once the user is created, you will need to set permissions to grant access to the database. Here I will first create a testdb to create a new database to set permissions. Create new database Assign permissions to database Update
Download rpm package and configure yum repository Disable mysql5.7: Enable mysql8.0: Verify: Disabling default MySQL modules Installation Service start stop start: status check: Changing temp password after installation The above output will display the default password Z#5m,9wsmlw in the console. Changing password by following below setup command Interactive setup: Connecting to MySQL server
Make sure you are familiar with connecting to a Kubernetes cluster, have the Nginx ingress controller configured with a certificate manager, and have a MySQL database pod deployed. Only then, can you proceed. Follow this guide if you do not have MySQL deployed. Follow this guide to set up Nginx ingress and cert manager. PhpMyAdmin
Base64 encoding is a method of encoding binary data into an ASCII (text-based) format. In Linux and other computing environments, Base64 encoding is commonly used to represent binary data in a human-readable form. This encoding is used for different purposes. It encodes binary files for transmission over protocols that use text. It can also embed
To convert string value to base64, follow the below steps in the PowerShell command line window: Encoding to base64 string: Output: Decoding base64 string: Output:
NOTE: This tutorial assumes you know how to connect to a Kubernetes cluster. Create secrets to securely store MySQL credentials Output: Persistant volume and MySQL deployment Execute the below command to create persistent volume: Output: Execute the below command to deploy MySQL pod: Output: Exposing MySQL as a Service Output: Output:
