If you need to store your data (such as user information or chat history) in MySQL and you have installed 123 Web Messenger Chat Software on your server, please follow the instructions below:

4.1 Create database.

Input the following instructions in the MS-DOS window in a Windows server or command prompt in a Linux server:

<mysql installation directory>/bin/mysql --user=[user] --password=[password] --execute="CREATE DATABASE 123webmessenger CHARACTER SET utf8 COLLATE utf8_bin;"

The [user] and [password] here are used for MySQL account.

4.2 Import 123 Web Messenger table.

Enter the following commands in command prompt: <mysql installation directory>/bin/mysql --user=[user] --password=[password] --default-character-set=utf8 123webmessenger < <123webmessenger installation directory>/server/etc/mysql.sql.

4.3 Modify wmserver.xml.

4.3.1 Open this file: <123webmessenger installation directory>/server/etc/wmserver.xml.

4.3.2 Find this node: <database-mode> Derby </database-mode>, and change " Derby " to MySQL.

4.3.3 Find this node: <database-server port="20208" ip="127.0.0.1" enable="On"></database-server>, and change enable="On" to enable="Off".

4.4 Configure Mysql.xml

Open this file: <123webmessenger installation directory>server/etc/Mysql.xml, and configure the relevant parameters according to the instructions, the section between <connection-pool>...</connection-pool> is database connection pool configuration and may be not need to be modified.

5. Start your 123WebMessenger server.