Example: Creating a MySQL Database Schema
The following instructions provide a sample that illustrates how to create a simple, open-source database server on your local machine (localhost) for use by the RapidMiner Server. This example creates a MySQL database, but any common database platform is allowed.
The example uses the following credentials:
Using the command line
If you do not have a GUI SQL editor available, for example when installing RapidMiner Server on a Linux machine, use the following instructions.
If you do not already have the software, download
MySQL
and install the product.
Change the
max_allowed_packet
variable to at least
256M
(better
512M
) to allow storing larger models in the repository.
To set this value permanently it needs to be stored in the MySQL configuration file
my.ini
. In Windows systems this is usually located in
C:\Program Files\MySQL\MySQL Server X.Y* or
C:\ProgramData\MySQL\MySQL Server X.Y* whereas in Unix like systems this is usually in
/etc/
.
See the official MySQL documentation
here
for details.
From the command line, create the database:
create database rapidminer_server;
Execute the following query to create a new user and grant privileges to the database rapidminer_server on your local machine:
grant all privileges on rapidminer_server.* to rmUser@localhost identified by 'pswd';
With privileges granted, you have finished creating the RapidMiner Server database. Record the username, password, and schema name and return to
the installation instructions
to complete the RapidMiner Server installation.
Using a GUI
Use these instructions to create a database using MySQL Workbench.
If you do not already have the software, download
MySQL
and install the product.
Open the MySQL Workbench as an administrator (Right-click,
Run as Admin
).
Right-click on the list of existing
Schemas
and select
Create Schema...
to create the database schema.
Enter a name for the schema and for collation choose 'utf - utf8_bin'. Then click
Apply
.
In the
Apply SQL Script to Database
window, click
Apply
to run the SQL command that creates the schema.
Click
Finish
. You can see the new schema, which has no tables, listed in the left pane.
From the
Management
menu, select
Users and Privileges
and click
Add Account
. Complete the screen with the credentials listed above.
Navigate to the tab
Schema Privileges
and click on
Add Entry...
. Select the newly created database schema. Click
Select "All"
to grant all privileges on this schema for this new user. Click
Apply
.
From the
Management
menu, select
Options File
and click the
Networking
tab. Find the
max_allowed_packet
entry (should be at the top) and change it to at least
256M
. Click
Apply...
and in the new dialog that appears again
Apply
. See the official MySQL documentation
here
for details.
If you get the error
Could not save configuration file
, you did not run the MySQL Workbench as an administrator. Restart it as an administrator and try again.
Finally, to apply this change you need to restart the database. From the
Instance
menu, select
Startup/Shutdown
and click
Stop Server
, followed by
Start Server
.
You now have finished preparing the RapidMiner Server database.
