MySQL

By default, ProCosmetics uses SQLite. However, if you are running ProCosmetics on multiple servers and want to sync the data, you should use MySQL.

Setup

1. Ensure you have a MySQL database created and set up.
2. Locate the storage section in the config.yml and set type to MYSQL.
3. Configure the host, database, user and password values to allow ProCosmetics to connect to the database.
4. Optionally, change the port and table if required or wanted.
5. Save the file and restart the server. Data such as coins and equipped cosmetics should now be saved in the database.

Troubleshooting

Could not create connection to database server. Attempted reconnect 3 times. Giving up. OR Communications link failure

If you get this error, or another error that is similar (failed to connect), it is most likely that the host or port values are incorrect. Double-check these and try again.

Access denied for user 'x'@'x'

If you are getting this error, it is able to reach the server, but the details are incorrect. Make sure all of the information you input to connect to the database is correct.