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; /*刷新权限*/