If you want to use MySQL as a repository you should first install MySQL.
Make the following changes to the mySQL configuration file (my.ini on Microsoft Windows, and my.cnf on Linux or Unix systems) :
key_buffer_size=128M
max_allowed_packet=64M
You might even put larger amount of memory if you want to be able to store larger documents. In this example here maximal document you are able to store is 64M but to store such a large document you must have at least 128M or even 256M. In general, use a key_buffer_size which is about 25% of your total system memory.
To perform XPath and XQuery statements using Saxon you will need approx. 4 time size of the document being queried. For example to query a 256M document using the implemented Saxon query service you will need about 1GB free memory.
This version of Myx does not use streaming XPath service because I try only XSQ and at the moment that seems not very stable.
Enter the mysql admin console :
mysql --user=root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.0.21-debug
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Now enter the following commands :
mysql> create database myx_data;
Query OK, 1 row affected (0.02 sec)
mysql> grant all on myx_data.* to 'myx_admin'@'%' identified by 'admin_pass';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on myx_data.* to 'myx_admin'@'localhost' identified by 'admin_pass';
Query OK, 0 rows affected (0.00 sec)
mysql> quit;