mysql-net · bgrainger · Oct 8, 2016 · Oct 8, 2016 · bgrainger · Oct 8, 2016
diff --git a/.ci/docker-run.sh b/.ci/docker-run.sh
@@ -0,0 +1,36 @@
+#!/bin/bash
+cd $(dirname $0)
+
+docker pull mysql:5.7
+docker run -d \
+	-v $(pwd):/etc/mysql/conf.d \
+	-p 3306:3306 \
+	--name mysql \
+	-e MYSQL_ROOT_PASSWORD='test' \
+	mysql:5.7
+
+for i in `seq 1 30`; do
+	# wait for mysql to come up
+	sleep 1
+	# try running the init script
+	docker exec -it mysql bash -c 'mysql -uroot -ptest < /etc/mysql/conf.d/init.sql' >/dev/null 2>&1
+	# exit if successful
+	if [ $? -eq 0 ]; then
+		docker exec -it mysql mysql -ussltest -ptest \
+			--ssl-mode=REQUIRED \
+			--ssl-ca=/etc/mysql/conf.d/ssl-ca.pem \
+			--ssl-cert=/etc/mysql/conf.d/ssl-client-cert.pem \
+			--ssl-key=/etc/mysql/conf.d/ssl-client-key.pem \
+			-e "SELECT 1"
+		if [ $? -ne 0 ]; then
+			>&2 echo "Problem with SSL"
+			exit 1
+		fi
+		echo "Ran Init Script"
+		exit 0
+	fi
+done
+
+# init script did not run
+>&2 echo "Unable to Run Init Script"
+exit 1
diff --git a/.ci/init.sql b/.ci/init.sql
@@ -0,0 +1,4 @@
+CREATE USER 'mysqltest'@'%' IDENTIFIED BY 'test;key=\"val'; GRANT ALL ON *.* TO mysqltest;
+CREATE USER 'no_password'@'localhost';
+CREATE USER 'no_password'@'172.17.0.1';
+CREATE USER 'ssltest'@'%' IDENTIFIED BY 'test'; GRANT ALL PRIVILEGES ON *.* TO 'ssltest'@'%' REQUIRE SSL;
diff --git a/.ci/server.cnf b/.ci/server.cnf
@@ -0,0 +1,4 @@
+[mysqld]
+ssl-ca=/etc/mysql/conf.d/ssl-ca.pem
+ssl-cert=/etc/mysql/conf.d/ssl-server-cert.pem
+ssl-key=/etc/mysql/conf.d/ssl-server-key.pem
diff --git a/.ci/ssl-ca-key.pem b/.ci/ssl-ca-key.pem
@@ -0,0 +1,27 @@
+-----BEGIN RSA PRIVATE KEY-----
+MIIEowIBAAKCAQEAy+3RJYYEDFEe2Ask2zU/wCb/+Rw10NAw1EYA7kXopAOC+9et
+eZu2qAAYntxf+V1CsgnJhrIzVNGeIHfSS5j5aE24zPKKjgu+1jSFT4uF+E6ZDguC
+va+xj0SLKAOsZVmYj0atAEJTyinTJRvlzLfSLUFcbgErCIIRBO6iPrh4t2I8u+9H
+7UP1CJL7hAknK/Fa0/xFMtgLiGIOHKawSD5/JGIyA9M8q/BQQWGIfpAYROWUJlKe
+EsD+AQDj0GJSmzUzI/SP3QxhwdKyA5S8nKhhUfrNQp8+8IZ6K2v0DcOPKBr8ATJk
+GJ5olS3gE7JLKlpzVqY0zOJQVDNDKVAKaavU/wIDAQABAoIBAGECWKPJBNP3Iv0T
+EA1XX2RBKTOPv+n9n7zbMEYo62paYUz8ZIGdGV8B7LRlkSJGwxt+nGd/DfwjW12G
+ontj4gFEN80G8/Juk/HCOkiEzs44VYbg4ujpU0YcDTaTyMbNwE0oCdQ9uS5Khy73
+/nFMYKc2mImb9KSvevklq/i6OHLDZ0bxTy1zizS1AgCNiDyMPLaoRscdHfPZlV95
+hmcrfbEbq+gfjoZWOL1F/He0pux74Z0QuhEuwtVwIkay79FlLmoigGyiCV5kFnPL
+SJ/xDH9sJdk/ok08mkYg1BrixuscrtXX9zM0IPw3y7wKVq0k9/rytIZiHdsuw7TQ
++3M8AkECgYEA6DljHx/Hj8JO4mPndyFbpvawTt0QgGIseK7OcbDFdyR3iWe2smyZ
+W1keWaOSmaTgc8KWMbbB6UfpVi/451pWQ0d9QBZo3FDvr0KiqWgxZZ5ycO26J+Z7
+h8b0nm+0bvAwWwvl0sCSHVS6jGtWVS56FZp/C9Y4Qq22tT7xa/wxWKUCgYEA4M7P
+gjgUupsScihYy+CjBxJmdP5P4Kv2DMgt/UngIIfSPvJWB/+Uc5j7skHrcNIN0Dz1
+c19n03TyC7LDO0NTebANET6jE+wlH1SbIPlDUC1A+fJxpAn8btsDkUzwbt5ZbzV9
+Vc0mE4rfY8lJWQ0OxJvPiCRD7w9seBOV3P9AodMCgYABBT+KQ3l9CD2QgR/jRiJA
++ZSMxCvuZIANh7cgiMZVX7Omxu3mmtORszKO8kkSo8bYu2ItlcAEZmyAFHXjjmIS
+qZ3DSlXroe9rtb9BP1P4PloCZQkMY9bnIdixWYxRcHzF6ad45Z++wUCQnWgjt7CR
+p7wnMSnOITVMVpp4/wK4gQKBgDfUpMxeSSee45HeW08m1tYmx7M+hW/yxQSfomxJ
+MJRjpt9jJ+KMor2ivL+kh2hZgny45uxkQVDOtl4ZY0sQiWarRlOGDtIfz4hcZrpl
+rUX4Ny7b+0UWBc8yLUykowGlzuhDjIEGlfI8hwYtMz4edBB38a6J8yUn23RmyM09
+xztpAoGBAKU6vg8xpOO86QYqA1GXA3075f+c5YzUqwi/QRrVm266nJb4/TtN6A+I
+y35uIRKRBNGmoRB2lkGWjBxAAvQoH8q03QFZKNYpjuVQ+FMNOPkLOTNUNmy6xBQ8
+H/C/m1DvqtrbZX7HW8YHQqG79rH6sfK6RZ2bPu1ppKc7kPBIjgbb
+-----END RSA PRIVATE KEY-----
diff --git a/.ci/ssl-ca.pem b/.ci/ssl-ca.pem
@@ -0,0 +1,22 @@
+-----BEGIN CERTIFICATE-----
+MIIDqzCCApOgAwIBAgIJAPl6eT/YDhDpMA0GCSqGSIb3DQEBCwUAMGwxCzAJBgNV
+BAYTAlVTMQswCQYDVQQIDAJOQzEMMAoGA1UEBwwDUlRQMRcwFQYDVQQKDA5NeVNx
+bENvbm5lY3RvcjEUMBIGA1UECwwLRW5naW5lZXJpbmcxEzARBgNVBAMMCmRvY2tl
+cmhvc3QwHhcNMTYxMDA4MTQwNTEzWhcNMjYwODE3MTQwNTEzWjBsMQswCQYDVQQG
+EwJVUzELMAkGA1UECAwCTkMxDDAKBgNVBAcMA1JUUDEXMBUGA1UECgwOTXlTcWxD
+b25uZWN0b3IxFDASBgNVBAsMC0VuZ2luZWVyaW5nMRMwEQYDVQQDDApkb2NrZXJo
+b3N0MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAy+3RJYYEDFEe2Ask
+2zU/wCb/+Rw10NAw1EYA7kXopAOC+9eteZu2qAAYntxf+V1CsgnJhrIzVNGeIHfS
+S5j5aE24zPKKjgu+1jSFT4uF+E6ZDguCva+xj0SLKAOsZVmYj0atAEJTyinTJRvl
+zLfSLUFcbgErCIIRBO6iPrh4t2I8u+9H7UP1CJL7hAknK/Fa0/xFMtgLiGIOHKaw
+SD5/JGIyA9M8q/BQQWGIfpAYROWUJlKeEsD+AQDj0GJSmzUzI/SP3QxhwdKyA5S8
+nKhhUfrNQp8+8IZ6K2v0DcOPKBr8ATJkGJ5olS3gE7JLKlpzVqY0zOJQVDNDKVAK
+aavU/wIDAQABo1AwTjAdBgNVHQ4EFgQUvHyfhJ1hlLFAXVKq1G/qk+0RmBYwHwYD
+VR0jBBgwFoAUvHyfhJ1hlLFAXVKq1G/qk+0RmBYwDAYDVR0TBAUwAwEB/zANBgkq
+hkiG9w0BAQsFAAOCAQEApSQKljLYVoDuvOSf9oLfpvbb5ltR6hXZz7PsTrg55nzk
+hS2N/nQxMuo85nJ4DvE98P/GK2qY6KfKuud+//uYRT5GYVQclEpcQ3Tx41HxReo0
+w9x5fWj3sg6m7Gtr2M6GH5onuyMH+cI6KkLUyJLBChlp/nBppDzKGFGQ1si0ozTR
+TEw+H0QAMibU5cRviP99w8AwQQPVBdQWzHrsGT8rUEGh3UVDX5fV2rvzUVMx56VB
+dSR98wk150RW3m4cs/6TGqJ3PE8GXDf86QwTorcsnO4j4kb6W68ZPIdJVlDgp0Tz
+WSqO4yFOy+ZCqh4epeh8g/d3FLUjEgjtkKPnzxlwmA==
+-----END CERTIFICATE-----
diff --git a/.ci/ssl-client-cert.pem b/.ci/ssl-client-cert.pem
@@ -0,0 +1,20 @@
+-----BEGIN CERTIFICATE-----
+MIIDTDCCAjQCAQEwDQYJKoZIhvcNAQELBQAwbDELMAkGA1UEBhMCVVMxCzAJBgNV
+BAgMAk5DMQwwCgYDVQQHDANSVFAxFzAVBgNVBAoMDk15U3FsQ29ubmVjdG9yMRQw
+EgYDVQQLDAtFbmdpbmVlcmluZzETMBEGA1UEAwwKZG9ja2VyaG9zdDAeFw0xNjEw
+MDgxNDA1NTlaFw0yNjA4MTcxNDA1NTlaMGwxCzAJBgNVBAYTAlVTMQswCQYDVQQI
+DAJOQzEMMAoGA1UEBwwDUlRQMRcwFQYDVQQKDA5NeVNxbENvbm5lY3RvcjEUMBIG
+A1UECwwLRW5naW5lZXJpbmcxEzARBgNVBAMMCmRvY2tlcmhvc3QwggEiMA0GCSqG
+SIb3DQEBAQUAA4IBDwAwggEKAoIBAQC1dqKk57xD46lUN9JbuWJ3P1WTwavPPf1t
+p1AqG6i/hVJ+oTxNsjjJiP4/K6/Cx2zlTtOfR9jLsf8s9OwNYLaojkT4tK7TyzVg
+49n9zovu5R4K0v9wNxNTgnSZ9vR2tuUz1jeBiovZ6U5RH4qK5POp7gr4cURfEw/4
+5SCXD/5WsF4iz1z3h5ooiWj5jOx4OoMfUpv9YsRXnYibVtFTI9CFBpsqW+nXfKip
+HwOaPT5cfY7ovOR52SRN86RIkXzCjlWV3IiBdO2wwHDT+rJJApmlP3tw+G49gR0I
+/MPZR8tdRPbrHBzfHn445dyoL1yqJrGyd80yCAzdhiN1TLAxpgvxAgMBAAEwDQYJ
+KoZIhvcNAQELBQADggEBAAyF0LiV7RH8iH+kV0qtxuJmfuAnQwuIKJ0miFnzI/8I
+8EUTD7lf6YsjmFDovpyxbwKoQ0IOedSxmwKx3XZx65Pb/QUJz+Sqq6WKIRnzbqe+
+2Efsung1+ZulNx56JhTzK+LCDydhQcXehgiTJW2mln2c032MkQCJ5ABRQS5XrwtC
+4bR65gNVgq6huR+CvCXawNgxNBJPcP/fRC/QJQg5U7oQad6zvA49wmow3Figtelc
+dCekxnbXentVYk+b6UfpPSLWSrLC/JHxhBVGE9j1PRso7AfI4zDLjiGANwugBBI3
+/cnubQzV6HFd4sxtyiBbjDBJV2U0nEUBNbBj3tgDajg=
+-----END CERTIFICATE-----
diff --git a/.ci/ssl-client-csr.pem b/.ci/ssl-client-csr.pem
@@ -0,0 +1,17 @@
+-----BEGIN CERTIFICATE REQUEST-----
+MIICsTCCAZkCAQAwbDELMAkGA1UEBhMCVVMxCzAJBgNVBAgMAk5DMQwwCgYDVQQH
+DANSVFAxFzAVBgNVBAoMDk15U3FsQ29ubmVjdG9yMRQwEgYDVQQLDAtFbmdpbmVl
+cmluZzETMBEGA1UEAwwKZG9ja2VyaG9zdDCCASIwDQYJKoZIhvcNAQEBBQADggEP
+ADCCAQoCggEBALV2oqTnvEPjqVQ30lu5Ync/VZPBq889/W2nUCobqL+FUn6hPE2y
+OMmI/j8rr8LHbOVO059H2Mux/yz07A1gtqiORPi0rtPLNWDj2f3Oi+7lHgrS/3A3
+E1OCdJn29Ha25TPWN4GKi9npTlEfiork86nuCvhxRF8TD/jlIJcP/lawXiLPXPeH
+miiJaPmM7Hg6gx9Sm/1ixFediJtW0VMj0IUGmypb6dd8qKkfA5o9Plx9jui85HnZ
+JE3zpEiRfMKOVZXciIF07bDAcNP6skkCmaU/e3D4bj2BHQj8w9lHy11E9uscHN8e
+fjjl3KgvXKomsbJ3zTIIDN2GI3VMsDGmC/ECAwEAAaAAMA0GCSqGSIb3DQEBCwUA
+A4IBAQCJMyH+JX5MgEXLnsum/WOf5Htk9Y1nTUviocDVFUISFRSp6ix70T3UM53G
+xd76JyphQt2uTqqZZNHD4ChWFhNl7vRqjv+qEad+d/jzawkVAZONrv8jQvOFYWEh
+wcUMXeS1X4QM814Q9U6geqOkybYBmjtpc6L7KglyaPjJSe57eMqMi6EmktvNKujc
+ysn0TP7rPYk8Zc3hrLD3Y+YTlPtKel5qqPe0KrHpv0CzcDvWTlNEaZWuToqor5jK
+xc2wP6VL7wg6ONgj7FE/Dn0u3l4usvKwhEZc8ejkY5WDM30st1U9qUOGI1B/eCIG
+frzfU7w74ny+7mumRfv0IPYlSbQL
+-----END CERTIFICATE REQUEST-----
diff --git a/.ci/ssl-client-key.pem b/.ci/ssl-client-key.pem
@@ -0,0 +1,27 @@
+-----BEGIN RSA PRIVATE KEY-----
+MIIEogIBAAKCAQEAtXaipOe8Q+OpVDfSW7lidz9Vk8Grzz39badQKhuov4VSfqE8
+TbI4yYj+Pyuvwsds5U7Tn0fYy7H/LPTsDWC2qI5E+LSu08s1YOPZ/c6L7uUeCtL/
+cDcTU4J0mfb0drblM9Y3gYqL2elOUR+KiuTzqe4K+HFEXxMP+OUglw/+VrBeIs9c
+94eaKIlo+YzseDqDH1Kb/WLEV52Im1bRUyPQhQabKlvp13yoqR8Dmj0+XH2O6Lzk
+edkkTfOkSJF8wo5VldyIgXTtsMBw0/qySQKZpT97cPhuPYEdCPzD2UfLXUT26xwc
+3x5+OOXcqC9cqiaxsnfNMggM3YYjdUywMaYL8QIDAQABAoIBAHJG2/Zt2aoHXUOk
+Q91vygq+3+3FMaW5rDe5/koGUScLlwAYGhnz+r8wfqzZnj5TyMg/9BWC8YyV89Uk
+COQD3AQaVGUrpE3M0zjJRScJRCaWM20to5/Pj2Qv665qT1nTpFQYu6vgzGHXA3Mj
+IeSGesyxFEeRTTVyk8Ryxyta7xk3uRfHulu7kCEXahLdVeF+PV5mxfiBp4KOb36n
+RHhaPYTauj0LIogOU1VJOf1Ji+XJdQUD+hUCmDs5y4iFqDPxQSeKztIogxpWFRzX
+tea5mQkn0JkKsDV6Va7JjOUCOgrcJX+fojU2g0lE4aEiUpgdg6ovrPbQw1VhaVqF
+YUHeKWECgYEA2KgdhhdkZlb6IYHrRpzbFZeaeWBQLPFbWE1LscKY3rc+w/fgLH+7
+WhHLwc7mHIEpY+yxYYsdIYPqhzoLvGnFn1pwJZbNFhzph6YJMddeEpkp0m9ROKFc
+dE8jL96RkDxY2/WQK6raQqJ25YEFOwa7b5gsdE1EwtPTDEfM8mbpOtsCgYEA1mp2
+k9CRr8uO6YTI8aMTafprcStwxh4FibEyKA1mVjHd4N/6bWHGAARdu1Pth3yd44nP
+E9KejXJXRqAn3KvK6cjSUfb3Tc8hZZ0EZAUsC/evR3G6mpb3e8LvfPayqgCUeHkp
+exLdz1BRBn+dukK0ehQFb2G5pjKPBe87MJ85ACMCgYBm0oqIfAuTIk49nsoJTiIP
+wk52skX6vmUqqCx3ZbJlaLQqDzbeB5Tj7zQze7zr5ES/frLEZ2Bg6plgqiStu8kl
+kqdMv5//kaMnVJ5igCLOUtBtZZU3eiVFsdUyP7/3oxxM7+MHRmOlYjNpQm04ET7d
+fGwEmjM6/4rW9jCHDl48JwKBgGfH5hcLp8hoBYc/zycuIJJ2NBT1ysMJ+vI3gyhh
+u/vSbSuQHZ1d6sFNW7T1HY4rohxlMobMthOOmXHEySaFPFTF8A7eM7tEm0ycoGht
+HHG6c+tnv8NdePI9Wz+oBLhGSZa6RnqcmiHjJSS5FjX2XXaNREgyC/LGm/VqYsLY
+/nTzAoGASG+SNUUNe3pzQIKku77qoqgXG1YDeFjvVSDDEZmDINZUxTITtFG80AiT
+cSt9YGmBV7Ghn93mGXDzF3ronP5vTKratrtFTSVo3/A73YMatnjLx+mJ/dt7dYCT
+dvH6WDbPwhy+pMvLGNsxWDtN7N4xj/ueLF2rXGu4zXJYfk+pteY=
+-----END RSA PRIVATE KEY-----
diff --git a/.ci/ssl-server-cert.pem b/.ci/ssl-server-cert.pem
@@ -0,0 +1,20 @@
+-----BEGIN CERTIFICATE-----
+MIIDTDCCAjQCAQEwDQYJKoZIhvcNAQELBQAwbDELMAkGA1UEBhMCVVMxCzAJBgNV
+BAgMAk5DMQwwCgYDVQQHDANSVFAxFzAVBgNVBAoMDk15U3FsQ29ubmVjdG9yMRQw
+EgYDVQQLDAtFbmdpbmVlcmluZzETMBEGA1UEAwwKZG9ja2VyaG9zdDAeFw0xNjEw
+MDgxNDA1MjJaFw0yNjA4MTcxNDA1MjJaMGwxCzAJBgNVBAYTAlVTMQswCQYDVQQI
+DAJOQzEMMAoGA1UEBwwDUlRQMRcwFQYDVQQKDA5NeVNxbENvbm5lY3RvcjEUMBIG
+A1UECwwLRW5naW5lZXJpbmcxEzARBgNVBAMMCmRvY2tlcmhvc3QwggEiMA0GCSqG
+SIb3DQEBAQUAA4IBDwAwggEKAoIBAQC7YAnrlatP6HJCrP/dBEmDyB4Bc2oR+1qC
+8JH64bWqtx7K7bgmAbqbaqIpYSLfC1lqXAM0zXR9RkzHhSM8+knfsZaygXdrzzIt
+fy5gS5lDx+yn81kL/gIopUFhuIeTDjB2XGIEb5bRpwcw/bTtasldwrOilAhtzkku
+eyNG51OUfrbrjd8rICfF5aJW+GR1788z+8Bjh4omAQjSLLi6YK/gN+kqZmiPXhh+
+5k0ebZS+vZEKWccvnnt82czlElVngym6ZzU1VMx6Ou03GhgZN8rrGQBcqF6geO/O
+3UbcHZ1Fc/Xuf2WB/Ndz/Nd8CTkpDgB86UQqwKfOsGvKO56CFXZ/AgMBAAEwDQYJ
+KoZIhvcNAQELBQADggEBAGvQUk//CM5RIXf0SQWlnfofTkf7N1anCbVWrJkqdAJC
+KwWP5oIRnFFQR0gidnFRqv/mQ8dMaxjW//WXA4L9T5ukhp3ApE6GCW8kk8qeG/fj
+laaxZH8v1wupZDQcDyMfToZLb4HVijnw4TrGeV/aSp2ia7ool4A/6HsARYIvO8lW
+eYbZHMGIKHd6NbNWadKMJJwQzw/qRFwmLCNQRaYmzf6kF+a02WRsGhwiUfaIAhh7
+NdH45kjGHD9vSJODt0oL0bnxOeAFhe23T7JV49DhBut6w5Ib5iIUTsFSQSWConQs
+2KzWut4M4gOzKdrBN6srhJG66tI2isXUAfp9UeRf60A=
+-----END CERTIFICATE-----
diff --git a/.ci/ssl-server-csr.pem b/.ci/ssl-server-csr.pem
@@ -0,0 +1,17 @@
+-----BEGIN CERTIFICATE REQUEST-----
+MIICsTCCAZkCAQAwbDELMAkGA1UEBhMCVVMxCzAJBgNVBAgMAk5DMQwwCgYDVQQH
+DANSVFAxFzAVBgNVBAoMDk15U3FsQ29ubmVjdG9yMRQwEgYDVQQLDAtFbmdpbmVl
+cmluZzETMBEGA1UEAwwKZG9ja2VyaG9zdDCCASIwDQYJKoZIhvcNAQEBBQADggEP
+ADCCAQoCggEBALtgCeuVq0/ockKs/90ESYPIHgFzahH7WoLwkfrhtaq3HsrtuCYB
+uptqoilhIt8LWWpcAzTNdH1GTMeFIzz6Sd+xlrKBd2vPMi1/LmBLmUPH7KfzWQv+
+AiilQWG4h5MOMHZcYgRvltGnBzD9tO1qyV3Cs6KUCG3OSS57I0bnU5R+tuuN3ysg
+J8Xlolb4ZHXvzzP7wGOHiiYBCNIsuLpgr+A36SpmaI9eGH7mTR5tlL69kQpZxy+e
+e3zZzOUSVWeDKbpnNTVUzHo67TcaGBk3yusZAFyoXqB4787dRtwdnUVz9e5/ZYH8
+13P813wJOSkOAHzpRCrAp86wa8o7noIVdn8CAwEAAaAAMA0GCSqGSIb3DQEBCwUA
+A4IBAQA9iB7OnltZGzrfLPmTTzRUdsX+BVupksJqBqpEnWrBU/2BuCTjt+a3sOHQ
+swiMfYYoXaqL/j70PEDP/PStYdPxjZUD/Jtz1+4HJvG2QJc9dkaUHQ78ofwFAXZ+
+lPfMoWbZi9dD7ZfgiKPYhVp/+eVQdnxbVvB2c8heKyIpO8BWzRrhU4HRgJirK5Vv
+9DduPJTSgYFvXw64QmgTyPlLF3N8U1bK12vc5fAOdDSemCUNwwhQq3S2kcbtZg0l
+tVK+9mym1bIXiOy5wE6SCyXAmx9qPx2RSgT6Vl3kC8nndq1YtveHIf1h3BHjzCgJ
+rrJbZh9vCRmK6xcLniegujcLJbeF
+-----END CERTIFICATE REQUEST-----
diff --git a/.ci/ssl-server-key.pem b/.ci/ssl-server-key.pem
@@ -0,0 +1,27 @@
+-----BEGIN RSA PRIVATE KEY-----
+MIIEpAIBAAKCAQEAu2AJ65WrT+hyQqz/3QRJg8geAXNqEftagvCR+uG1qrceyu24
+JgG6m2qiKWEi3wtZalwDNM10fUZMx4UjPPpJ37GWsoF3a88yLX8uYEuZQ8fsp/NZ
+C/4CKKVBYbiHkw4wdlxiBG+W0acHMP207WrJXcKzopQIbc5JLnsjRudTlH62643f
+KyAnxeWiVvhkde/PM/vAY4eKJgEI0iy4umCv4DfpKmZoj14YfuZNHm2Uvr2RClnH
+L557fNnM5RJVZ4Mpumc1NVTMejrtNxoYGTfK6xkAXKheoHjvzt1G3B2dRXP17n9l
+gfzXc/zXfAk5KQ4AfOlEKsCnzrBryjueghV2fwIDAQABAoIBAC2l4gTQu6GGAYAY
+4WSYzMgcEqNL2MV0tMI9lXLHVhi27/uEGl64ARwnyEXIclRgUXJF5EoS25RBcicR
+Wlpap3CltQ7b15oeKh1HZKb1A+utYwwvjrwLL79zMxB5gh3jUQ8kxoRKIzYEOQ5I
+YLGOWGxNKLIs2jjWDqISQa/eX1BHe3BYsFVCAdewcStQsUewZgJdynmGIyChAVak
+zyb1wA60Is9NjOoedthTFe+7QKX7jaseyReY56ZrkzaoSdZwfd/ha4Z4o8dqh3t3
+ElnanZ3qRKbw/4ata4kkM8c0r69pGSk4vYLRc1Xeva6POlrEE7Nqw606ZWjUrtyS
+pZRwmMECgYEA7rt4lgbVIzugdYKa0T1dTYFLLi1/VNSDSrq/iqfLRCMmcidmQSF2
+RBWPzmYrBajwU7zE83LQf5VkcxtIV88RRr0ju7dBhZL3sTLxQH1JXqtge77GbX77
+dyljBvCmO2GauHXp7JM33n4NMYR9288Ue0Aaa0CdKnXXy3WRSyMK1S8CgYEAyO2a
+lQQPIP1LSU9ZXVcjbWsuVDPHCQ1P6u2r4GALvGorQWcckBrkIF5GhVhCzzOfMfjh
+0b4/a8z7h5whyQYtQXz4YWk6ddFzi/ZUTCl28gdYyRhK1E6H26G60fe1e+2FRsw4
+HDsTgULdyyUpq6FBWHp/6PsZ/LvvboI99weWv7ECgYEAs4JV7wGePIr2YcXeId2x
+jbjdzhA6AZB2VLfNlTYMeuSvYQDNO8Ysho9r/bgHO49Hfr+fnKtFqdmsmXz3TceO
+5xELkHgAla7n/t8eVu6eP8g/mWzfCbCE55pAMxS6+kWvMGrBhblBNlS0GPrWJHU2
+omKWOvVv+GB57iwuH0BvQdMCgYA0IdH1z/PM72tVPg1FtpIulZyTpEuEAbw2jCwI
+L2NcI3/NnF9A1HlUHKHXfyr2b8JiSNzuepoh8jFg4hWx/rRHRZF8VL0iTJHaQrNk
+f22pJlbW9kKUCzwctD2wtMCVwu7Ni7cTPBC3fQ3m42GIcnJt7nq5jE0V0f0xgwFo
+0sM+QQKBgQCDnhFBCjUDv86fmj7d6Yp2WMSmGJT77rfj12qeHREtAJK04jhpXWMR
+bFJXCatA4kUmXbUEcAFAHRxZhaHx5Kvm3llAPjsSTd2g7+ag3qt13uZ32F2Qbef+
+XH2s4qTEa1mmX83PUC0ZNZrwDOMx6BTLWensnxc9Zmccvm4JC0uS/Q==
+-----END RSA PRIVATE KEY-----
diff --git a/.travis.yml b/.travis.yml
@@ -3,13 +3,11 @@ dist: trusty
 services: docker
 
 before_install:
-  - docker pull mysql:5.7
-  - docker run --name mysql -e MYSQL_ROOT_PASSWORD='test' -p 3306:3306 -d mysql:5.7
+  - chmod +x .ci/docker-run.sh && ./.ci/docker-run.sh
   - sudo sh -c 'echo "deb [arch=amd64] https://apt-mo.trafficmanager.net/repos/dotnet-release/ trusty main" > /etc/apt/sources.list.d/dotnetdev.list'
   - sudo apt-key adv --keyserver apt-mo.trafficmanager.net --recv-keys 417A0893
   - sudo apt-get update
   - sudo apt-get install -y dotnet-dev-1.0.0-preview2-003121
-  - docker exec -it mysql mysql -uroot -ptest -e "CREATE USER 'mysqltest'@'%' IDENTIFIED BY 'test;key=\"val'; GRANT ALL ON *.* TO mysqltest; CREATE USER 'no_password'@'172.17.0.1'; SET GLOBAL max_allowed_packet=104857600;"
 
 script:
   - dotnet restore

diff --git a/appveyor.yml b/appveyor.yml
@@ -12,8 +12,7 @@ build_script:
     dotnet build tests\SideBySide.New --configuration Release
 before_test:
 - cmd: |-
-    "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -u root --password=Password12! -e "CREATE USER mysqltest IDENTIFIED BY 'test;key=\"val'; GRANT ALL ON *.* TO mysqltest; CREATE USER no_password;"
-    "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -u root --password=Password12! -e "SET GLOBAL max_allowed_packet=104857600;"
+    "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -u root --password=Password12! < .ci\init.sql
 test_script:
 - cmd: |-
     dotnet test tests\MySqlConnector.Tests --configuration Release