mysql8.4创建新的高权限用户并使用mysql_native_password

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

flush privileges;