Skip to content

Instantly share code, notes, and snippets.

@jkullick

jkullick/mysql-change-allowed-hosts.md

Last active December 29, 2016 13:34
Show Gist options
  • Save jkullick/04d8026188ce0b71abd85bb987d6334b to your computer and use it in GitHub Desktop.
Save jkullick/04d8026188ce0b71abd85bb987d6334b to your computer and use it in GitHub Desktop.
Download ZIP
Change Allowed Hosts in MySQL
Raw
mysql-change-allowed-hosts.md 
UPDATE mysql.user SET host = '10.0.0.%' WHERE user != 'root';
UPDATE mysql.db SET host = '10.0.0.%' WHERE user != 'root';
FLUSH PRIVILEGES;

Source

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment