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;

[file-name 000186_2025-08-29_11-25-29.txt]