XP-rience

Something that I'd like to share with you!

Sunday, July 09, 2023

SSH private key authentication with WinSCP and PuTTY Gen

No comments :
Simplify your login process by using SSH keys for authentication when you are connecting to your server.1st step is to run the PuTTYGen software and generate a key.Save the private key to a file.Next, login into you server through SSH and create "~/.ssh" directory if it doesn't exists.chmod...
Read more

Sunday, April 02, 2023

PostgreSQL installation & connecting it to to Oracle SQL Developer/HeidiSQL

No comments :
pre {padding:10px;border:1px solid #444;background-color:#444;color:#fff;overflow-x:scroll;overflow:auto;} Install PostgreSQL DB, in my example here, installing it under Ubuntu by referring to below URL.https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-20-04 Login...
Read more

Saturday, July 30, 2022

Red Hat OpenShift port forwarding to access MySQL at port 3306

No comments :
Still continuing from my first post about Red Hat OpenShift, here is how to do port forwarding from your locahost port 3306 to MySQL hosted under Red Hat OpenShift. This is to enable the connection to the MySQL using your favorite MySQL client. I'm using HeidiSQL.1st, OC login to...
Read more

Thursday, July 28, 2022

Setting up Joomla 4 and MySQL under Red Hat OpenShift

No comments :
Continue from my first post about Red Hat OpenShift, here is how to setup Joomla 4/PHP/MySQL under Red Hat OpenShift.MySQL Start by adding MySQL from template.Most of the fields will be auto generated. Note that the database name is "sampledb"Continue and wait for the pod to up...
Read more

Saturday, July 23, 2022

How to connect phpMyAdmin to MariaDB under Red Hat OpenShift

No comments :
It is a container platform built for an open hybrid cloud.Get your trial account from https://www.redhat.com/en/technologies/cloud-computing/openshift if you haven't do so.Like me, I'm getting myself a developer sandbox with a trial length of 30 days just to understand how...
Read more