Skip to content

Instantly share code, notes, and snippets.

@Obooman

Obooman/grant_root_remote_access.txt

Forked from tinchodev/grant_root_remote_access.txt
Created March 23, 2017 13:28
Show Gist options
  • Save Obooman/fd0d7606efc14b6da3f6e57d0b784302 to your computer and use it in GitHub Desktop.
Save Obooman/fd0d7606efc14b6da3f6e57d0b784302 to your computer and use it in GitHub Desktop.
Download ZIP
Grant Root Remote Access MySQL
Raw
grant_root_remote_access.txt
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Edit /etc/mysql/my.cnf
Comment address binding bind-address = 127.0.0.1 to #bind-address = 127.0.0.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment