Skip to content

Instantly share code, notes, and snippets.

@davedavis

davedavis/gist:3d49c0966a1314966b928427991122e4

Created November 1, 2020 22:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davedavis/3d49c0966a1314966b928427991122e4 to your computer and use it in GitHub Desktop.
Save davedavis/3d49c0966a1314966b928427991122e4 to your computer and use it in GitHub Desktop.
Download ZIP
Allow remote access to MySQL 8 Database
Raw
gistfile1.txt
Comment out or set the IP of the bind address manually in /etc/mysql/my.cnf
Restart the service.
Create the user AGAIN (Because MySQL treats users on localhost and users on remote as different)
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment