WSL 2.x and MySQL Server

commands.sql

# Allow access to SQL

UPDATE mysql.user SET plugin='mysql_native_password' WHERE User='root'
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'
# You should now have access via: `mysql -u root -p` using the password `root`

# Allow access via any host

CREATE USER 'root'@'%' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

# Allow access via your own PC

CREATE USER 'root'@'<hostname>.mshome.net' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'<hostname>.mshome.net'
FLUSH PRIVILEGES;