JRE 1.6.*

The installation of the Java Runtime environment 1.6.* is trivial. Just run the SETUP.EXE program and follow the instructions.


Installing the Database Server Software

If you already have a database server supporting InnoDB tables installed on your network, you can skip this step.


Starting from XStudio v1.2, MySQL 5.0.3 to MySQL 5.1 is required. MySQL 5.5 is not (yet) supported.
In the following, we will install MySQL version 4.1.14 but the process is similar for any version of MySql.


MySql

To start the installation, run the downloaded setup program and follow the instructions provided with the software.








Ensure to check the “Configure the MySQL Server now” option and choose the “standard configuration”.






Modify the security settings to set the root password. Here we set the password “rootpwd”.







The database server is now installed.



MySQL Administrator 1.1.9 (Opt.)

MySQL Administrator is a great tool that eases a lot the setup of databases on the server. Let’s install it. To start the installation, run the SETUP.EXE program and follow the instructions provided with the software.









To connect to the MySQL administration console as root, we first need to create a “connection”. To do this click on the ... button.




In the Options, press the Add new connection button.




Use the root username and password we already set during the installation (root/rootpwd) and apply.




We can now login to the administration console.






Creating the Database

Then, we need to create a database instance. Any valid name is possible. We will use “xstudio_db” as an example.

To create the database, just start again MySQL Administrator, select the “Catalogs” item on the left pane and right-click on the schema panel to select “create a new schema”.




“xstudio_db” will be the name of the schema (a.k.a. the database)




Note that the database is still empty and does not include any table at this point.


Creating a user account

We have now to create a specific user account to access this database. To do this, select the “User Administration” category on the left pane.




Right-click on the users panel and select “Add new user”.




Enter a name and a password (i.e. “xstudio” and “xstudiopwd”) and grant some privileges on the previously created database (“xstudio_db”) to this user.





Now you have a database server up and running, including an empty database “xstudio_db” accessible by the user “xstudio” (using the password “xstudiopwd”). The next step is to install XStudio on your client computers. All the clients will connect to this unique database.