1.新建监控 Prometheus用户
CREATE USER 'exporter'@'%' IDENTIFIED BY '123456' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%';
flush privileges; /*刷新权限*/
2.新建mqtt用户
CREATE USER 'mqtt'@'%' IDENTIFIED BY '123456';
grant all privileges on mqtt.* to 'mqtt'@'%';
flush privileges; /*刷新权限*/
3.新建nacos集群用户
CREATE USER 'nacos'@'%' IDENTIFIED BY '123456';
grant all privileges on nacos_devtest.* to 'nacos'@'%';
flush privileges; /*刷新权限*/
4.修改root用户可以远程登陆
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges; /*刷新权限*/
