Deploy Seafile Windows Server With MySQL

    • download the windows installer from
    • install it by double clicking the downloaded exe file
    • databases for ccnet/seafile/seahub
    • a new user to access these databases

    Open a termial (cmd, Win + R, cmd) and login to mysql with a privileged user:

    1. create database `seafile-db` character set = 'utf8';
    2. create database `seahub-db` character set = 'utf8';
    3. create user 'seafile'@'localhost' identified by 'your secure password';
    4. GRANT ALL PRIVILEGES ON `seafile-db`.* to `seafile`;
    5. GRANT ALL PRIVILEGES ON `seahub-db`.* to `seafile`;
    • Append the following lines to ccnet/ccnet.conf:
    • Edit the database section of seafile-data/seafile.conf:
    1. [database]
    2. type=mysql
    3. user=seafile
    4. password=your secure password
    5. db_name=seafile-db

    Create Database Tables for Seahub

    Now we create the database tables for seahub.

    Open a window command line prompt, and execute the following command:

    1. mysql -u seafile -p seahub-db < C:/SeafileProgram/seafile-server-3.1.3/seahub/sql/mysql.sql