Buy Percona ServicesBuy Now!

MySQL 8.0.4 RC: auth_socket Users Beware!

 | January 24, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Security

MySQL 8.0.4 RC

The news that the latest MySQL 8.0.4 RC (release candidate) is available is indeed exciting. Unfortunately for users of the auth_socket plugin, dangers lie in wait! Back in November 2015, I reported Failure of auth_socket authentication with sha256_password as default. This prevents users that identify with the auth_socket plugin from logging in after SHA256 authentication has been […]

Read More

Encrypt your –defaults-file

 | October 12, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

encrypt

This blog post will look how to use encryption to secure your database credentials. In the recent blog post Use MySQL Shell Securely from Bash, there are some good examples of how you might avoid using a ~/.my.cnf – but you still need to put that password down on disk in the script. MySQL 5.6.6 and later introduced […]

Read More