Skip to content

Using MySQL/Redis

DANGER

The project defaults to using Sqlite3 as the database and Memory as the cache. The program supports mysql and redis, but the author has not tested them. Please use them with caution.

If you choose to proceed, the author encourages you to provide feedback on your experience, and please make sure to backup your data beforehand.

Locate the project's configuration file.

Modify the key parts as follows:

ini
# ======================
# Basic configuration
# ======================
[base]
# Web run port. Default:3002
http_port=3002
# Database driver [mysql/sqlite(Default)]
database_drive=mysql
# Cache driver [redis/memory(Default)]
cache_drive=redis
# Queue driver [redis/memory(Default)]
queue_drive=redis
# File cache path (Please start with the current path './')
# Warning: The files that have been uploaded after the modification cannot be accessed
source_path=./uploads
# File cache path.
source_temp_path=./runtime/temp

# ======================
# Mysql database driver
# ======================
[mysql]
host=127.0.0.1
port=3306
username=root
password=root
db_name=sun_panel
wait_timeout=100

# ======================
# sqlite database driver
# ======================
[sqlite]
file_path=./database/database.db

# ======================
# redis database driver
# ======================
[redis]
address=127.0.0.1:6379
password=
prefix=sun_panel:
db=0

Released under the MIT License.