Skip to content

Instantly share code, notes, and snippets.

@msaladna
Created March 25, 2020 18:03
Show Gist options
  • Save msaladna/c7cf1bc4ec921d3f04ab850b0ab132e8 to your computer and use it in GitHub Desktop.
Save msaladna/c7cf1bc4ec921d3f04ab850b0ab132e8 to your computer and use it in GitHub Desktop.
# Remove echo when you're ready for primetime
cpcmd -o json admin:collect '[mysql.enabled:1]' | jq -r 'keys[]' | while read SITE ; do
cpcmd -o json -d $SITE mysql:list-databases | jq -r 'values[]' | while read DB ; do
cpcmd -d $SITE -o json mysql:list-users | jq -r 'keys[]' | while read USER ; do
echo cpcmd -d $SITE mysql:set-privileges "'$USER'" "localhost" "'$DB'" "'[read:true,write:true]'"
done
done
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment