Change user password in MySQL 5.7 with "plugin: auth_socket"

In this blog, we'll discuss how to use "plugin: auth_socket" to change user password in MySQL 5.7.