mysql: create super user with access to all tables

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’;