installing_mysql

Installing MySQL

MySQL is available for all platforms on http://dev.mysql.com/downloads/ . Installation instructions for the MySQL Community Server are available on that website. Follow the MySQL installation instructions for your Operating System.

<note tip>If you intend to use web services like XLRstats and Echelon we advise you to install a combination package like XAMPP (lite) (or LAMP, WAMP or similar). Those packages install Apache web server, MySQL server and PHP. Also the MySQL administration tool phpMyAdmin is installed.</note>

<note network>It is possible to install MySQL on a remote server. Advantages are that it will somewhat reduce the load on the game server itself. Optimal situation is that the MySQL server is close to the game server, good internet connectivity is very important for your data flow. Make sure that B3 is able to connect to MySQL on the remote server. The MySQL server must be set up to allow this. This is not standard policy for MySQL, so you will have to modify the MySQL config file: my.cnf to enable remote connection to the database.

Let's assume your MySQL server is at ip-address 123.123.123.123. Here's what to do. Locate my.cnf on your server and open it with an editor. Look for these lines (probably in the [mysqld] section) and modify them accordingly:

<note shell> bind-address = 123.123.123.123\

skip-networking

</note> Don't forget to restart the MySQL service/daemon!</note>

---

Back to the Installation steps