Skip to content

Instantly share code, notes, and snippets.

@jamesattard
Created September 19, 2014 13:18
Show Gist options
  • Select an option

  • Save jamesattard/506a7cc815a8f998c551 to your computer and use it in GitHub Desktop.

Select an option

Save jamesattard/506a7cc815a8f998c551 to your computer and use it in GitHub Desktop.
root@m-mysql01# mysql -u root -p -e "INSERT INTO mysql.user (Host,User) values ('10.250.1.100','haproxy_check'); FLUSH PRIVILEGES;"
root@m-mysql01# mysql -u root -p -e "GRANT ALL PRIVILEGES ON *.* TO 'mycoolapp'@'10.250.1.100' IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment