Laravel Community Tools by
Tighten
Nova Packages
Laravel Tricks
Forge Recipes
Forge Recipes
Staff Picks
All Recipes
Login
Staff Picks
All Recipes
Login
Back to Recipes
Create a MySQL User with All Privileges
9 years ago
uplyft
un-tested
Clone
bash
Copy
echo "Creating 'username' MySQL User..." PASS=false while read LINE do if [[ $LINE == password* ]] ; then PASS="${LINE/password = /}" break fi done < /etc/mysql/debian.cnf if [ $PASS ] then mysql -u"debian-sys-maint" -p"$PASS" -e"CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';" mysql -u"debian-sys-maint" -p"$PASS" -e"GRANT CREATE ROUTINE, CREATE VIEW, CREATE USER, ALTER, SHOW VIEW, CREATE, ALTER ROUTINE, EVENT, SUPER, INSERT, RELOAD, SELECT, DELETE, FILE, SHOW DATABASES, TRIGGER, SHUTDOWN, REPLICATION CLIENT, GRANT OPTION, PROCESS, REFERENCES, UPDATE, DROP, REPLICATION SLAVE, EXECUTE, LOCK TABLES, CREATE TEMPORARY TABLES, INDEX ON *.* TO'username'@'localhost';" mysql -u"debian-sys-maint" -p"$PASS" -e"FLUSH PRIVILEGES;" echo "Done." else echo "Oops. Something went wrong :/" fi PASS=false
Comments
No comments yet.
Log in
to leave a comment.