Skip to content

Instantly share code, notes, and snippets.

@malikkurosaki

malikkurosaki/create user.md

Created June 26, 2019 07:37
Show Gist options
  • Save malikkurosaki/57d3db58ba254cba43eddf5830a87be0 to your computer and use it in GitHub Desktop.
Save malikkurosaki/57d3db58ba254cba43eddf5830a87be0 to your computer and use it in GitHub Desktop.
Download ZIP
mysql create new user for all ip
Raw
create user.md

mysql create user

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment