Using multiple containers in a pod using minikube

I’m trying to create a pod with multiple containers but it’s failing eventually. This is my yaml definition to create the pod.

apiVersion: v1
kind: Pod
metadata:
name: web
labels:
tier: prod
spec:
containers:
- name: http
image: httpd
- name: mysql
image: mysql

And this is the error I see,
Normal Pulled 7m25s kubelet Successfully pulled image “mysql” in 3.438834346s
Warning BackOff 3m48s (x21 over 8m16s) kubelet Back-off restarting failed container

$ kubectl get pods
NAME READY STATUS RESTARTS AGE
web 1/2 CrashLoopBackOff 6 9m21s

Can I get help or any suggestions ?

Need to check out the logs.

kubectl logs web -c http
kubectl logs web -c mysql

Hey, @asakth
Have a look in shared logs:-

$ kubectl logs web -c mysql
2021-06-29 12:18:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.25-1debian10 started.
2021-06-29 12:18:42+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2021-06-29 12:18:42+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.25-1debian10 started.
2021-06-29 12:18:42+00:00 [ERROR] [Entrypoint]: Database is uninitialized and password option is not specified
    You need to specify one of the following:
    - MYSQL_ROOT_PASSWORD
    - MYSQL_ALLOW_EMPTY_PASSWORD
    - MYSQL_RANDOM_ROOT_PASSWORD

You need to specify one of the fields in the mysql container.