Viewing Tokenized Data
| ID | First Name | Last Name | Credit Card Number | CVV | Expiry Date | SSN | Mobile Number | Date of Birth | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | QfFY | nQI | 0096 5192 3332 4785 | 142 | 6015 | 240-91-2103 | (649) 335-9958 | 76/63/1980 | Lwkv@example.com |
| 2 | Vnmy | nQI | 0456 0637 6370 8905 | 849 | 9119 | 366-25-7797 | (290) 389-1597 | 02/92/1990 | MlHD@example.com |
| 3 | QfFY | nQI | 2322 4108 4537 1922 | 450 | 6304 | 113-72-0715 | (739) 931-5836 | 04/72/1965 | DnvMDP@sdfgs.com |
Instructions to directly fetch this information from the database:
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;"