MySQL
Last updated
Was this helpful?
Last updated
Was this helpful?
When using the MySQL app driver, first you should configure your MySQL connection credentials as :
DB_MYSQL_HOST
127.0.0.1
Any string
The MySQL host.
DB_MYSQL_PORT
3306
Any integer
The MySQL port.
DB_MYSQL_USERNAME
root
Any string
The MySQL username.
DB_MYSQL_PASSWORD
password
Any string
The MySQL password.
DB_MYSQL_DATABASE
main
Any string
The MySQL database.
This database supports .
Once you have configured your MySQL database credentials, you should create a table with the following structure:
The following environment variables are used to define the behavior of the MySQL app driver:
APP_MANAGER_MYSQL_TABLE
apps
Any string
The table to pull the app data from.
APP_MANAGER_MYSQL_VERSION
8.0
Any string
The MySQL version (utilized by the underlying Knex database abstraction layer).
APP_MANAGER_MYSQL_USE_V2
false
true
, false
soketi 0.14+. If you're using MySQL 8.0+ and experience authentication issues, you may enable this option.
This feature is truly optional. To enforce app-level limits in MySQL, you should add the following fields to your table:
Existing apps running on <0.29.0
will still work even if you don't have these fields added after the migration to 0.29.0
. You should add these fields to keep your database up-to-date or to have the choice to, later on, imply limits to your apps.
Setting any of them to null
or ''
will ignore the setting, and use the limits associated .