Access denied for user 'root'@'localhost' in Kubernetes

[Dannie Tjahjono]

Hi,

1) I creates mysql pod successfully, image: mysql:8.0, but I keep getting this error while trying to connect

$ k exec -it $pod -- bash
root@mysql-deployment-6b98dc844b-crjgf:/# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root@mysql-deployment-6b98dc844b-crjgf:/# echo $MYSQL_ROOT_PASSWORD
YUIidhb667

2) According to Google, I need to reset the root account. But how to reset if I can't even connect 🥴