MySQL - Installation & Configuration
MySQL Installation
MySQL is a external database software that allows you to sync blacklists between multiple servers. To use MySQL with JBlacklist you will need a MySQL server. A MySQL server should be provided with most Garry's Mod server hosts when hiring a Garry's Mod server. Otherwise a MySQL server can be hired separately or hosted by your own.
Installing MySQLoo
For MySQL to work, you need to install a C++ module called MySQLoo into your Garry's Mod server. Please follow the steps below.
Automatic MySQLoo installation: Most Garry's Mod server host's allow you to install MySQLoo from your server control panel. Please refer to your hoster's knowledgebase or open a support ticket with your host for instructions on how to install MySQLoo.
Manual MySQLoo installation: Please refer to the following page when installing MySQLoo.
Configuring MySQL
- Stop your server.
- Navigate to addons > jblacklist > lua > jblacklist.
- Open the file called sv_mysql.lua and enter the MySQL connection details at the top.
- Make sure you change jBlacklist.UseSQL to true.
- Start your server and check the server console if any errors occurred.