LogNotes

SELECT User, Host FROM mysql.user WHERE User='root';

CREATE USER 'root'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;


GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_password' WITH GRANT OPTION;
FLUSH PRIVILEGES

ALTER USER 'root'@'%' IDENTIFIED VIA mysql_native_password USING PASSWORD('pass'); 
FLUSH PRIVILEGES;