-- 创建数据库 devnacos
CREATE DATABASE devnacos DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-- 创建数据库访问用户nacos,%允许所有访问地址,密码为:test1234
create user 'nacos'@'%' identified by 'test1234';
--授予用户nacos通过外网IP对数据库“devnacos”的全部权限
grant all privileges on devnacos.* to 'nacos'@'%' with grant option;
--刷新权限
flush privileges;