How to setup Open Bravo with MySQL database, for multi cashier, single database

I recently decided to use open bravo on my minimarket.

BUt it uses file based database, since i want to implement it on multi cashiers as clients and one of the cashier as server, so i try to change the database configuration to use mysql database.

First you have to Open Openbravo POS

Then Enter using Administrator privilege (click the adminsitrator button).

Click configuration from menu

Click configure Database

Use Library > Browse MySql connector i.e.

\app-path\mysql-connector-java-5.0.8-bin.jar  (u can download this library from mysql site) i download it from http://dev.mysql.com/downloads/connector/j/

fill the Driver class with com.mysql.jdbc.Driver

Set the URL to : jdbc:mysql://localhost:3306/dbname

Set the user to : MySql User

Set the Password to : MySql Password (If empty leave blank)

Click Save button and restart Openbravo POS system.

Before restarting, create a database first with name = dbname using phpmyadmin (i am currently using XAMPP on WIndows 7, since my lx300 epson currently have no win 8 compatibility).

Automatically MySql database will be created.