Skip to content

Instantly share code, notes, and snippets.

@SolemnJoker

SolemnJoker/6_privileges.sql

Last active November 17, 2020 02:46
Show Gist options
  • Save SolemnJoker/04bfa95db5a454aa4b6d2144efb6d6e6 to your computer and use it in GitHub Desktop.
Save SolemnJoker/04bfa95db5a454aa4b6d2144efb6d6e6 to your computer and use it in GitHub Desktop.
Download ZIP
[mysql privileges] #mysql
Raw
6_privileges.sql
use mysql;
select host, user from user;
grant all on uic.* to root@'%' identified by '123456' with grant option;
grant all on falcon_portal.* to root@'%' identified by '123456' with grant option;
grant all on dashboard.* to root@'%' identified by '123456' with grant option;
grant all on graph.* to root@'%' identified by '123456' with grant option;
grant all on alarms.* to root@'%' identified by '123456' with grant option;
flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment