In this blog, we’ll discuss how to use “plugin: auth_socket” to change user password in MySQL 5.7. In
In Debian/Ubuntu it is pretty common to install MySQL/Percona Server with an empty password for the root user. After everything is configured and tested, then a password is set. This is not a good practice in production servers (or soon-to-be production servers), but you can do it for your own test servers. With regards to authentication, things have changed a bit in 5.7, and methods that worked before now need a different procedure.
Let’s say that you install 5.7 and don’t specify a password. You will see the following:
SELECT User, Host, HEX(authentication_string) FROM mysql.user; …[Read more]