Skip to content

Instantly share code, notes, and snippets.

@ebta
Created February 7, 2022 14:27
Show Gist options
  • Save ebta/366ef40893c794619d357191ae3fd8e1 to your computer and use it in GitHub Desktop.
Save ebta/366ef40893c794619d357191ae3fd8e1 to your computer and use it in GitHub Desktop.
Allow remote connection to MySQL 8

Login using SSH, then run

mysql -uroot -p

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'YourSecurePassword';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
mysql> FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment