小奇又来了
    # Username to connect to the MySQL database    mySQLUsername: authme
    # Password to connect to the MySQL database
    mySQLPassword: '1234'
    # Database Name, use with converters or as SQLITE database name
    mySQLDatabase: authme
    # Table of the database
    mySQLTablename: authme
    # Column of IDs to sort data
    mySQLColumnId: id
    # Column for storing or checking players nickname
    mySQLColumnName: username
    # Column for storing or checking players RealName
    mySQLRealName: realname
    # Column for storing players passwords
    mySQLColumnPassword: password
    # Column for storing players passwords salts
    mySQLColumnSalt: ''
    # Column for storing players emails
    mySQLColumnEmail: email
    # Column for storing if a player is logged in or not
    mySQLColumnLogged: isLogged
    # Column for storing if a player has a valid session or not
    mySQLColumnHasSession: hasSession
    # Column for storing a player's TOTP key (for two-factor authentication)
    mySQLtotpKey: totp
    # Column for storing the player's last IP
    mySQLColumnIp: ip
    # Column for storing players lastlogins
    mySQLColumnLastLogin: lastlogin
    # Column storing the registration date
    mySQLColumnRegisterDate: regdate
    # Column for storing the IP address at the time of registration
    mySQLColumnRegisterIp: regip
    # Column for storing player LastLocation - X
    mySQLlastlocX: x
    # Column for storing player LastLocation - Y
    mySQLlastlocY: y
    # Column for storing player LastLocation - Z
    mySQLlastlocZ: z
    # Column for storing player LastLocation - World Name
    mySQLlastlocWorld: world
    # Column for storing player LastLocation - Yaw
    mySQLlastlocYaw: yaw
    # Column for storing player LastLocation - Pitch
    mySQLlastlocPitch: pitch


这些都是需要自己手动创建的吗

夜雨晨风丶
本帖最后由 夜雨晨风丶 于 2023-3-5 19:45 编辑

如果你用的是小皮系统的话配置比较简单

  1. DataSource:
  2.     # What type of database do you want to use?
  3.     # Valid values: SQLITE, MYSQL, POSTGRESQL
  4.     backend: MYSQL #数据存储方式改成MYSQL
  5.     # Enable the database caching system, should be disabled on bungeecord environments
  6.     # or when a website integration is being used.
  7.     caching: true
  8.     # Database host address
  9.     mySQLHost: 127.0.0.1 #默认地址，一般不改
  10.     # Database port
  11.     mySQLPort: '3306'  #默认端口，一般不改
  12.     # Connect to MySQL database over SSL
  13.     mySQLUseSSL: false # 是否使用SSL，看情况，一般不用
  14.     # Username to connect to the MySQL database
  15.     mySQLUsername: root # 数据库用户名，默认是root
  16.     # Password to connect to the MySQL database
  17.     mySQLPassword: 'root' #数据库密码，默认也是root
  18.     # Driver Name of the MySQL database.
  19.     # Built-in drivers:
  20.     #     MySQL: 'fr.xephi.authme.libs.com.mysql.cj.jdbc.Driver'
  21.     #     MariaDB: 'fr.xephi.authme.libs.org.mariadb.jdbc.Driver'
  22.     mySQLDriverClassName: fr.xephi.authme.libs.com.mysql.cj.jdbc.Driver
  23.     # Database Name, use with converters or as SQLITE database name
  24.     mySQLDatabase: authme # 用于存储该数据的文件夹名
  25.     # Table of the database
  26.     mySQLTablename: authme # 表名
复制代码
louyukai
手动创建是啥意思？这是MySQL数据库设置，你只要把你搭建的MySQL的账号密码之类的填进去就行了，下面复杂的设置不用管
krewella
不需要手动创建，提供SQL地址模式配置为SQL后会自动创建数据库，如果是多个服务器同步简单的把配置文件复制几份即可，但出于安全考虑建议还是为每个服务器提供不同的账户和密码
小奇又来了
夜雨晨风丶 发表于 2023-3-5 19:38
如果你用的是小皮系统的话配置比较简单

小皮面板如何配置