Creating MySQL Database – RapidMiner Documentation

You are viewing the RapidMiner Server documentation for adaptation 7.6 – check here for latest interpretation

Example: Creating a MySQL Database Schema

The stick to instructions provide a sample that illustrates how to create a bare, open-source database waiter for use by the RapidMiner servicing. This case creates a MySQL database, but any park database chopine is allowed .
The exercise uses the follow credentials :

Field Example Value
User rmUser
Password pswd
Database schema name rapidminer_server

Follow the instructions to create a database using a GUI, such as MySQL Workbench, or using the CLI.

Using a GUI

Use these instructions to create a database using MySQL Workbench .

  1. If you do not already have the software, download MySQL and install the product .
  2. Open the MySQL Workbench as an administrator ( Right-click, Run as Admin ) .
  3. Click on File>Create Schema to create the database schema .
  4. Enter a list for the outline and snap Apply .
  5. In the Apply SQL Script to Database windowpane, snap Apply to run the SQL command that creates the outline .
  6. Click Finish. You can see the new outline, which has no tables, listed in the left acid .
  7. From the Server menu, blue-ribbon Users and Privileges to add a exploiter explanation. Complete the filmdom with the credentials listed above.
  8. From the Server menu, choice Options File and click the Networking tab. Find the max_allowed_packet submission ( should be at the top ) and change it to at least 256M. Click Apply… and in the new dialogue that appears again Apply. See the official MySQL software 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.
  9. ultimately, to apply this change you need to restart the database. From the Server menu, choice Startup/Shutdown and click Stop Server, followed by Start Server .

You now have finished preparing the RapidMiner Server database .

Using the command line

If you do not have a GUI SQL editor program available, for example when installing RapidMiner Server on a Linux machine, use the pursuit instructions .

  1. If you do not already have the software, download MySQL and install the product .
  2. Change the max_allowed_packet varying to at least 256M to allow storing larger models in the repository. See the official MySQL documentation here for details .
  3. From the command occupation, create the database :
    create database rapidminer_server;

  4. Execute the stick to question to create a new user and grant privileges to the database rapidminer_server :
    grant all privileges on rapidminer_server.* to [email protected] identified by 'pswd';

With privileges granted, you have finished creating the RapidMiner Server database. Record the username, password, and schema name and fall to the initiation instructions to complete the RapidMiner Server initiation .

informant :
Category : How To

Related Posts

Leave a Reply

Your email address will not be published.