一条龙(1)

资源收集与整理

服务构架

nginx

http://nginx.org/en/docs/beginners_guide.html

flutter
```
https://flutter.dev/
```

SpringCloud　　

https://gitee.com/homepay/microservices-platform

DevOps
```
https://dev.azure.com/
```

Microservices

https://www.kancloud.cn/zlt2000/microservices-platform/919418

Platform
Apps
Pipeline
```
https://dev.azure.com/
```
HOME Page
```
http://abalei.cn/
```

DB
创建库：

授权：

FLUSH PRIVILEGES;
SHOW COLUMNS FROM `mysql`.`user`;
SELECT `user`, `host`, authentication_string AS `password` FROM `mysql`.`user`;
CREATE USER 'zlt2020'@'%' IDENTIFIED BY 'zlt2020';
GRANT SELECT, LOCK TABLES, ALTER, CREATE, CREATE TABLESPACE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, EVENT, DROP, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, CREATE USER, REPLICATION SLAVE, REPLICATION CLIENT, RELOAD, FILE, CREATE ROUTINE, ALTER ROUTINE, SHOW VIEW, SHOW DATABASES  ON *.* TO 'zlt2020'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'zlt2020'@'%';
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='xxl-job';
SHOW TABLE STATUS FROM `xxl-job`;
SHOW FUNCTION STATUS WHERE `Db`='xxl-job';
SHOW PROCEDURE STATUS WHERE `Db`='xxl-job';
SHOW TRIGGERS FROM `xxl-job`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='xxl-job';
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='file_center';
SHOW TABLE STATUS FROM `file_center`;
SHOW FUNCTION STATUS WHERE `Db`='file_center';
SHOW PROCEDURE STATUS WHERE `Db`='file_center';
SHOW TRIGGERS FROM `file_center`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='file_center';
REVOKE SELECT, SHOW DATABASES, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TABLESPACE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP  ON *.* FROM 'zlt2020'@'%';
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `xxl-job`.* TO 'zlt2020'@'%' WITH GRANT OPTION;
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `file\_center`.* TO 'zlt2020'@'%' WITH GRANT OPTION;
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `logger-center`.* TO 'zlt2020'@'%' WITH GRANT OPTION;
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `oauth-center`.* TO 'zlt2020'@'%' WITH GRANT OPTION;
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `tx-manager`.* TO 'zlt2020'@'%' WITH GRANT OPTION;
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `tx\_logger`.* TO 'zlt2020'@'%' WITH GRANT OPTION;
GRANT EXECUTE, SELECT, SHOW VIEW, ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EVENT, INDEX, INSERT, REFERENCES, TRIGGER, UPDATE, LOCK TABLES  ON `user-center`.* TO 'zlt2020'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'zlt2020'@'%';

安装Redis

https://www.runoob.com/redis/redis-install.html

https://github.com/tporadowski/redis/releases/download/v5.0.9/Redis-x64-5.0.9.zip

安装Nacos

// 资源 - 安装
https://github.com/alibaba/nacos/releases
https://github.com/alibaba/nacos/releases/download/1.3.0/nacos-server-1.3.0.zip



// 启动
$ zlt-register
acosin startup.cmd -m standalone
// 更多信息 - 使用信息
https://nacos.io/en-us/docs/quick-start.html