一条龙(1)

资源收集与整理

 

引图： ZLT-MP 微服平台

 

 

 

1. nginx 
   

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

    

2. flutter
   

   https://flutter.dev/

    

3. SpringCloud　　
   

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

    

4. DevOps
   

   https://dev.azure.com/

    

5. Microservices
   

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

    

6. Platform
   
   
   
7. Apps
   
   
8. Pipeline
   

   https://dev.azure.com/

    

9. HOME Page
   

   http://abalei.cn/

    

10. 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'@'%';

     

    
    
    
11. 安装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

     

12. 安装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\nacos\bin\ startup.cmd -m standalone
    // 更多信息 - 使用信息
    https://nacos.io/en-us/docs/quick-start.html
    
    
    
    

     登录： http://console.nacos.io/nacos/index.html#/
     账号：nacos/nacos