How to configure Mysql root password on Oracle Linux 8

• Login to your server as root.
• By default, there is no password for mysql root.
• mysql -u root -p
• Alter user 'root'@'localhost' identified WITH mysql_native_password by 'StrongPassword';
• flush privileges;
• exit;

Now, try to connect to Mysql as root user. It works!

git@github.com: Permission denied (publickey)

 Error when cloning git after adding SSH key. Below is the error

git@github.com: Permission denied (publickey).

fatal: Could not read from remote repository.

Fix :

First make sure you have added SSH key correctly. On right hand side of top corner under profile, you can see settings. In setting click on SSH and GPG keys and add your key as authentication keys.

Then login to the server or desktop from where you generated the key or have its private key, 

# eval `ssh-agent -s`

# ssh-add ~/.ssh/id_rsa

Wait for some time and try git clone, it will work.

OCI Instance Principals Authentication

OCI Instance Principals Authentication

In OCI, one of the authentication mechanism is using "Instance Principals". Here we don't need to use a key to execute OCI CLI commands, instead of key we are allowing OCI Compute instance the permission to execute CLI commands.

In this video you can see the steps.

1. Get the OCID of the compute instance

2. Create a Dynamic group

3. Create a Policy

4. Validate the setup

5. Execute your CLI commands {oci os object put --bucket-name backup-bucket --file sc_laundry_db-202412181734507003.sql --auth instance_principal}

Few Links for further read

https://www.ateam-oracle.com/post/calling-oci-cli-using-instance-principal

https://docs.oracle.com/en-us/iaas/tools/oci-cli/3.51.0/oci_cli_docs/cmdref/os/object/put.html