安装Install Kanboard Visual Todo and Tasks Management on Debian/Ubuntu Linux

What is Kanboard?

Kanboard is project management software that focuses on the Kanban methodology. -https://github.com/kanboard/kanboard

Installation

1. Log into the Linux based device
2. Run the following commands in the terminal
   # update software repositories
   sudo apt update
   # install available software updates
   sudo apt upgrade -y
   # install some dependencies
   sudo apt install apt-transport-https ca-certificates curl -y
   # install Apache HTTPD and MySQL
   sudo apt install apache2 mariadb-server mariadb-client -y
   # install PHP components
   sudo apt install libapache2-mod-php php-cli php-mbstring php-opcache php-json php-ldap php-gd php-xml php-mysql* php-curl php-zip -y
   # configure the MySQL database
   sudo su
   mysql_secure_installation
3. Press Enter to login as root
4. Type Y and press Enter to set a root password, type the password twice to confirm
5. Type Y and press Enter to remove anonymous users
6. Type Y and press Enter to disallow root login remotely
7. Type Y and press Enter to remove the test database
8. Type Y and press Enter to reload privilege tables
9. Run the following command to login into MySQL:
   mysql -u root -p
10. Authenticate with the root password set earlier
11. Run the following commands to create the Kanboard database and database user
    CREATE DATABASE kanboard DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    GRANT ALL ON kanboard.* TO 'kanboard_rw'@'localhost' IDENTIFIED BY 'K@nb0r4!';
    FLUSH PRIVILEGES;
    EXIT;
    exit
12. Continue with the following commands to download and extract Kanboard in the Apache webroot
    # download kanboard
    wget -O kanboard.tar.gz https://github.com/kanboard/kanboard/archive/v1.2.20.tar.gz
    # extract kanboard.tar.gz
    sudo tar xzvf kanboard.tar.gz -C /var/www/html/
    # rename the extracted folder to kanboard
    sudo mv /var/www/html/kanboard* /var/www/html/kanboard
    # set permissions on the kanboard directory
    sudo chown -R www-data:www-data /var/www/html/kanboard
    # make a copy of config template
    sudo cp /var/www/html/kanboard/config.default.php /var/www/html/kanboard/config.php
    # edit config.php
    sudo nano /var/www/html/kanboard/config.php
13. Press CTRL + W and search for DB_DRIVER
14. Set the DB_DRIVER value to mysql
15. Set the DB_USERNAME value to kanboard_rw
16. Set the DB_PASSWORD value to K@nb0r4!
17. Press CTRL+O, Enter, CTRL+X to write the changes
18. Continue with the following command
    # setup the database schema, authenticate with the root password set earlier
    sudo mysql -u root -p kanboard < /var/www/html/kanboard/app/Schema/Sql/mysql.sql
19. Open a web browser and navigate to http://DNSorIP/kanboard
20. Login with the username admin and password admin
21. Click the options carrot in the top right corner > My profile
22. Click Edit profile from the left navigation
23. Change the username and set a name and email as needed > Click Save
24. Click Change password from the left navigation
25. Enter admin as the Current password and enter and confirm a new secure password > Click Save
26. Click the options carrot in the top right corner > Logout
27. Log back in with the updated credentials
28. Welcome to Kanboard

More Info: https://kanboard.org