MySql

L2J uses ​MySQL as the database ( minimum required version is 4.1).

If you are using MySQL 5.x you have to turn off strict mode.

​http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

SET sql_mode = '';

The best way to manage MySQL is with Navicat. You can download ​Navicat for a 30 day free trial.

However many free MySQL frontends are available. If you are looking for a free tool take look here: ​Free Replacer For Navicat

Do not install MySQL program if you are using EasyPhP or other simmilar packs that have MySQL included.

If you need to see if you set a password for MySQL, look in my.ini in your Windows folder.

Here's a MySQL neat cheat sheet by ​http://ilovejackdaniels.com

[WikiStart]