CREATE USER 'username' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'
caching_sha2_password problem
CREATE USER ''@'your_server_ip ' IDENTIFIED WITH mysql_native_password BY 'your_password';
CREATE USER 'username' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'
caching_sha2_password problem
CREATE USER ''@'your_server_ip ' IDENTIFIED WITH mysql_native_password BY 'your_password';