orchardup / docker-mysql Goto Github PK

In https://github.com/orchardup/docker-mysql/blob/master/run#L17 :

GRANT ALL PRIVILEGES ON . TO 'root'@'%';

should read

GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;

else the user 'root'@'%' is not able to grant privileges to other users.

See also sameersbn/docker-gitlab#17

MySQL normally uses timezone tables in its mysql databases. These are needed if you want to set the used timezone on a per-connection basis:

set time_zone = 'Europe/Berlin'

These tables are generated by the mysql_tzinfo_to_sql command: http://dev.mysql.com/doc/refman/5.5/en/mysql-tzinfo-to-sql.html

If you are trying to use the above command on the docker-mysql container, this fails with:
Unknown or incorrect time zone: 'Europe/Berlin'

Is it possible to log all MySQL queries to a file or stdout?

I created a docker image and installed java in that. How can i run a java file which is in my system through that container. Can a kinow about the commands and command line statements to compile and run a java file from anywhere by just using the docker image. How can i deploy an file to docker image?

Following the instructions:

jhf$ docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=xehVg1IpVhEmlwRMG orchardup/mysql
WARNING: Local (127.0.0.1) DNS resolver found in resolv.conf and containers can't use it. Using default external servers : [8.8.8.8 8.8.4.4]
e6a16063663b99e39e615e4448b4f1f6ed3753ec4ba094f8bf4885d70d2ac473
jhf$ docker ps -a
CONTAINER ID        IMAGE                    COMMAND               CREATED             STATUS              PORTS               NAMES
e6a16063663b        orchardup/mysql:latest   /usr/local/bin/run    4 seconds ago       Exit 1                                  cranky_mccarthy     
jhf$ docker logs e6a
/usr/sbin/mysqld: error while loading shared libraries: libz.so.1: cannot open shared object file: Permission denied
jhf$