PyMySQL
diff --git a/‎.travis.yml
+5-1 b/‎.travis.yml
+5-1
diff --git a/‎.travis/initializedb.sh
+9 b/‎.travis/initializedb.sh
+9
diff --git a/‎sha256_test.py
-26 b/‎sha256_test.py
-26
diff --git a/‎tests/__init__.py b/‎tests/__init__.py
diff --git a/‎tests/test_auth.py
+63 b/‎tests/test_auth.py
+63
@@ -35,13 +35,14 @@ matrix:
       python: "3.4"
     - env:
         - DB=mysql:8.0
+        - TEST_AUTH=yes
       python: "3.7-dev"
 
 # different py version from 5.6 and 5.7 as cache seems to be based on py version
 # http://dev.mysql.com/downloads/mysql/5.7.html has latest development release version
 # really only need libaio1 for DB builds however libaio-dev is whitelisted for container builds and liaio1 isn't
 install:
-  - pip install -U coveralls unittest2 coverage cryptography
+  - pip install -U coveralls unittest2 coverage cryptography pytest
 
 before_script:
   - ./.travis/initializedb.sh
@@ -51,6 +52,9 @@ before_script:
 
 script:
   - coverage run ./runtests.py
+  - if [ "${TEST_AUTH}" = "yes" ];
+    then pytest -v tests
+    fi
   - if [ ! -z "${DB}" ];
     then docker logs mysqld;
     fi
 
@@ -37,6 +37,15 @@ if [ ! -z "${DB}" ]; then
         docker cp mysqld:/var/lib/mysql/server-cert.pem "${HOME}"
         docker cp mysqld:/var/lib/mysql/client-key.pem "${HOME}"
         docker cp mysqld:/var/lib/mysql/client-cert.pem "${HOME}"
+
+        # Test user for auth test
+        mysql -e "
+            CREATE USER
+                user_sha256   IDENTIFIED WITH 'sha256_password' BY 'pass_sha256',
+                nopass_sha256 IDENTIFIED WITH 'sha256_password',
+                user_caching_sha2   IDENTIFIED WITH 'caching_sha2_password' BY 'pass_caching_sha2'
+                nopass_caching_sha2 IDENTIFIED WITH 'caching_sha2_password'
+                PASSWORD EXPIRE NEVER;"
     else
         WITH_PLUGIN=''
     fi
 
@@ -0,0 +1,63 @@
+"""Test for auth methods supported by MySQL 8"""
+
+import os
+import pymysql
+
+# pymysql.connections.DEBUG = True
+# pymysql._auth.DEBUG = True
+
+host = "127.0.0.1"
+port = 3306
+
+ca = os.expanduser("~/ca.pem")
+ssl = {'ca': ca, 'check_hostname': False}
+
+
+def test_sha256_no_password():
+    con = pymysql.connect(user="nopass_sha256", host=host, port=port, ssl=None)
+    con.close()
+
+
+def test_sha256_no_passowrd_ssl():
+    con = pymysql.connect(user="nopass_sha256", host=host, port=port, ssl=ssl)
+    con.close()
+
+
+def test_sha256_password():
+    con = pymysql.connect(user="user_sha256", password="pass_sha256", host=host, port=port, ssl=None)
+    con.close()
+
+
+def test_sha256_password_ssl():
+    con = pymysql.connect(user="user_sha256", password="pass_sha256", host=host, port=port, ssl=ssl)
+    con.close()
+
+
+def test_caching_sha2_no_password():
+    con = pymysql.connect(user="nopass_caching_sha2", host=host, port=port, ssl=None)
+    con.close()
+
+
+def test_caching_sha2_no_password():
+    con = pymysql.connect(user="nopass_caching_sha2", host=host, port=port, ssl=ssl)
+    con.close()
+
+
+def test_caching_sha2_password():
+    con = pymysql.connect(user="user_caching_sha2", password="pass_caching_sha2", host=host, port=port, ssl=None)
+    con.close()
+
+    # Fast path of caching sha2
+    con = pymysql.connect(user="user_caching_sha2", password="pass_caching_sha2", host=host, port=port, ssl=None)
+    con.query("FLUSH PRIVILEGES")
+    con.close()
+
+
+def test_caching_sha2_password_ssl():
+    con = pymysql.connect(user="user_caching_sha2", password="pass_caching_sha2", host=host, port=port, ssl=ssl)
+    con.close()
+
+    # Fast path of caching sha2
+    con = pymysql.connect(user="user_caching_sha2", password="pass_caching_sha2", host=host, port=port, ssl=None)
+    con.query("FLUSH PRIVILEGES")
+    con.close()