Deploy Seafile Windows Server With MySQL
- Download and Setup Seafile Windows Server
- Stop seafile windows server
- Right click the seafile server tray icon
- Choose “Quit and shutdown Seafile Server”
- 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:
create database `seafile-db` character set = 'utf8';
create database `seahub-db` character set = 'utf8';
create user 'seafile'@'localhost' identified by 'your secure password';
GRANT ALL PRIVILEGES ON `seafile-db`.* to `seafile`;
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:
[database]
type=mysql
user=seafile
password=your secure password
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:
mysql -u seafile -p seahub-db < C:/SeafileProgram/seafile-server-3.1.3/seahub/sql/mysql.sql