Skip to content

Instantly share code, notes, and snippets.

@mul14

mul14/create_new_user.sql

Last active November 16, 2020 12:26
Show Gist options
  • Save mul14/40f3a2b3326381cfe800991a229c3f08 to your computer and use it in GitHub Desktop.
Save mul14/40f3a2b3326381cfe800991a229c3f08 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL/MariaDB mysql_native_password
Raw
create_new_user.sql
CREATE USER 'mul14'@'localhost' IDENTIFIED BY 'secret_password';
GRANT ALL PRIVILEGES ON *.* TO 'mul14'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Raw
update_root_password.sql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment