Skip to content

Instantly share code, notes, and snippets.

@sarpavci

sarpavci/create-homestead-user.sql

Last active October 12, 2020 10:55
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sarpavci/b304d79a30d7d1df478b3bb03daf1242 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sarpavci/b304d79a30d7d1df478b3bb03daf1242 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql create homestead user
Raw
create-homestead-user.sql
CREATE USER 'homestead'@'localhost' IDENTIFIED WITH mysql_native_password BY 'secret';
GRANT ALL PRIVILEGES ON * . * TO 'homestead'@'localhost';
FLUSH PRIVILEGES;
-- Show user grants
-- SHOW GRANTS username;
-- Revoke permissions
-- REVOKE ALL PRIVILEGES ON * . * TO 'homestead'@'localhost';
-- Drop user
-- DROP USER ‘homestead’@‘localhost’;
-- ALTER USER 'homestead'@'localhost' IDENTIFIED WITH mysql_native_password BY 'secret';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment