How to run a .sql file inside a sql image in Dockerfile?

I need to execute some script in a mysql image and need to create a new image out of it.

FROM mysql:5.7.29
COPY ./multicore.sql /bin
ENV MYSQL_ROOT_PASSWORD=root
RUN /bin/bash -c "mysql -uroot -proot 
    && source > /bin/sample.sql"

So when i execute this Dockerfile i’m getting the following error. The sample.sql run perfectly fine. The error i’m getting is

Sending build context to Docker daemon  116.7kB
Step 1/4 : FROM mysql:5.7.29
 ---> 84164b03fa2e
Step 2/4 : COPY ./multicore.sql /bin
 ---> 54738bfd2ce2
Step 3/4 : ENV MYSQL_ROOT_PASSWORD=root
 ---> Running in 0efc6d84aedb
Removing intermediate container 0efc6d84aedb
 ---> aab5ba5fb5a4
Step 4/4 : RUN /bin/bash -c "mysql -uroot -proot     && source > /bin/sample.sql"
 ---> Running in 526d17218da3
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
The command '/bin/sh -c /bin/bash -c "mysql -uroot -proot     && source > /bin/sample.sql"' returned a non-zero code: 1

Source: StackOverflow