Skip to content

Instantly share code, notes, and snippets.

@devarajchidambaram
Created October 25, 2018 05:52
Show Gist options
  • Save devarajchidambaram/d25e84b8f77a9810aa6d88672e14519c to your computer and use it in GitHub Desktop.
Save devarajchidambaram/d25e84b8f77a9810aa6d88672e14519c to your computer and use it in GitHub Desktop.
Grant all permissions to mysql data base to access every IP

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION; Query OK, 0 rows affected (0.13 sec)

mysql> commit; Query OK, 0 rows affected (0.00 sec)

mysql>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment