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