安装Install n8n - Open Source Workflow Automation - on Windows

What is n8n?

n8n is an extendable workflow automation tool. With a fair-code distribution model, n8n will always have visible source code, be available to self-host, and allow you to add your own custom functions, logic and apps. n8n's node-based approach makes it highly versatile, enabling you to connect anything to everything. -https://github.com/n8n-io/n8n

Installing n8n

1. Log into the Windows device
2. Download NodeJS Download
3. Install NodeJS > During the install, make sure to check the Tools for Native Modules option
4. At the Native Modules prompt, press any key to begin the installation process
   NOTE: This process takes quite a while to install, be patient. Proceed once the PowerShell window closes
5. Open File Explorer and navigate to C:\Windows\System32\LogFiles\WMI
6. Right click on RtBackup > Properties > Security tab > Click Advanced
7. Click the Change option next to the Owner field > Type administrators > Click OK
8. Check the Replace all child objects box > Click OK
9. Click Yes to confirm
10. Click OK on all open dialog windows
11. Launch PowerShell as an administrator
12. Run the following commands in the PowerShell window
    # install n8n
    npm install n8n --location=global
    # test run n8n
    npx n8n
13. If n8n errors out with a permissions issue, back in File Explorer, navigate to C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Windows\INetCache
14. Right click on Content.IE5 > Properties > Security tab > Click Edit...
15. Select the Everyone entry > Click Remove
16. Click OK on all open dialog windows
17. Click on the Start Button > Type task > Launch Task Scheduler
18. Right click the Task Scheduler Library folder in the left pane > Create Basic Task...
19. Set the name to n8n and optionally set a Description > Click Next
20. For the Trigger, select When the computer starts > Click Next
21. For the Action, select Start a program > Click Next
22. Complete the form fields as follows:

    Program/script: "%ProgramFiles%\nodejs\npx.cmd"
    Add arguments: n8n

23. Click Next
24. Check the Open the Properties dialog checkbox > Click Finish
25. In the Properties dialog, select Run whether user is logged on or not
26. Check the Run with highest privileges box > Click OK to create the scheduled task
27. Right click the n8n task > Run
28. Open a web browser and navigate to http://DNSorIP:5678
29. Complete the form with an email, first name, last name and password > Click next
30. Complete the questionnaire > Click continue
31. Click Get started
32. Welcome to n8n

By default, the n8n database and configuration file live in the user's profile .n8n folder (ie C:\Users\i12bretro\.n8n). To utilize a database other than SQLite, setup the database and authentication, then create a .bat file like the example below and call the .bat file as the action of the scheduled task.

SET DB_TYPE=mysqldb
SET DB_MYSQLDB_DATABASE=n8n
SET DB_MYSQLDB_HOST=localhost
SET DB_MYSQLDB_USER=n8n_rw
SET DB_MYSQLDB_PASSWORD=n8n_N8N!
SET GENERIC_TIMEZONE=America/New_York
"%programfiles%\nodejs\npx.cmd" n8n

Source: https://docs.n8n.io/hosting/installation/npm/