Skip to content

Instantly share code, notes, and snippets.

@serweb-labs

serweb-labs/adduser.sh

Created September 29, 2019 20:17
Show Gist options
  • Save serweb-labs/8d7be2a0e9b5d1cae9374f04ea102494 to your computer and use it in GitHub Desktop.
Save serweb-labs/8d7be2a0e9b5d1cae9374f04ea102494 to your computer and use it in GitHub Desktop.
Download ZIP
add user to mysql and add privileges on prefix db
Raw
adduser.sh
CREATE USER 'el_user'@'%' IDENTIFIED BY 'elpass';
GRANT ALL PRIVILEGES ON el_user_*.* TO 'cleek_dba'@'%';
GRANT ALL PRIVILEGES ON `el_user_\_%` . * TO 'el_user'@'%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment