| ID | First Name | Last Name | Credit Card Number | CVV | Expiry Date | SSN | Mobile Number | Date of Birth |
|---|
Open your terminal and execute the following commands:
USERNAME=$(kubectl get secret db-secret -o jsonpath="{.data.username}" | base64 --decode)
PASSWORD=$(kubectl get secret db-secret -o jsonpath="{.data.password}" | base64 --decode)
POD_NAME=$(kubectl get pods -l app=mysql -o jsonpath="{.items[0].metadata.name}")
kubectl exec -it pod/$POD_NAME -- mysql -u $USERNAME -p$PASSWORD webappdb -e "select * from users;"