Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Allow remote access to MySQL 8 Database
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