mysql configuration commands.
-- https://stackoverflow.com/questions/14779104/how-to-allow-remote-connection-to-mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
-- https://easyengine.io/tutorials/mysql/remote-access/
SELECT * from information_schema.user_privileges where grantee like "'root'%";
-- https://dev.mysql.com/doc/refman/8.0/en/set-password.html
SET PASSWORD FOR 'jeffrey'@'localhost' = 'auth_string';
SET PASSWORD = 'auth_string';
SELECT CURRENT_USER();
-- https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/
use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit