# https://cloud.google.com/compute/docs/instances/sql-server/setup-mysql#ubuntu

ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootPass';
# the following command shows the threads running, including the current connection.
SHOW processlist;
# to generate a list of users.
SELECT User, Host, authentication_string FROM mysql.user;
SELECT host, user FROM mysql.user WHERE user LIKE '%%';
SELECT host, user FROM mysql.user WHERE user LIKE '%roo%';

show status like 'wsr%';

# https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
# https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
# https://dev.mysql.com/doc/refman/8.0/en/alter-user.html