Hello! I have been using MemSQL’s cluster-in-a-box Docker image for some local automated testing and it’s been working great. I use the
init.sql file to load up a schema and a small sample of real data at startup time.
My question is: is there a way to set the password for the ‘root’ user at startup so that it’s not blank? The reason I wanted to do this is because (I believe) it slightly improves our security in the case an attacker were to get access to this container. (Please correct me if I am wrong in thinking.)
My Dockerfile looks like the following:
FROM memsql/cluster-in-a-box:6.7.14-fa416b0a53-1.5.5-1.0.6 # This line does not work as I expected it to... RUN memsql-admin change-root-password --all --yes --password test # Add our schema and data files to load at container init time ADD ./init.sql /init.sql ADD ./data /data/
I had thought running the
change-root-password would work, but it does not.