![]() This makes it very easy for a user to review, re-run and modify previously executed SQL statement(s). Like the mysql command line client utility, MySQL Workbench has a full history panel, which provides complete session history. For all you PostgreSQL users out there, you know what I’m talking about, explain analyze! I digress… Fortunately you can also generate EXPLAIN plans on your queries however, the EXPLAIN output is still the same. The visual SQL Editor aids the user in building complex queries, editing and running queries, creating and editing data along with viewing and exporting the results. Who loves colored syntax? I do! Anyway, being able to visualize what you are doing in a convenient GUI is a great way to accomplish many tasks, both as a database administrator and database developer. There is a lot inside the MySQL Workbench so this makes it more of a set of GUI tools. Support for the standard addition is also offered on all levels of MySQL Support. If you do venture to the feature list page, you should notice that there are few differences between the MySQL Workbench Community Edition (Open Source (GPL License)) and the commercial software version, MySQL Workbench Standard Edition (commercial software). That said, I do recommend MySQL Workbench to my developers’ and sometimes even a savvy manager as long as they are off my production servers.Ī full feature list can be found here. Plus, in most environments you don’t want a flock of users looking at production servers anyway. Call me crazy but I think it’s just too easy to inadvertently damage production with how easy this tool is to work with. I should also note that when I do use MySQL Workbench it’s more for my QA, test and development MySQL instances. Although all of the tools listed above are good I have had a lot of success with MySQL Workbench, plus it’s free. Some great tools that I have used in the past are Toad, Navicat, phpmyadmin, and WebYog. I’ve always been pro command line for MySQL administration however, there have always been powerful GUI tools that can aid administration, development and other tasks. Record the username, password, and schema name and return to the installation instructions to complete the RapidMiner Server installation.MySQL Workbench has come a long way and keeps getting better! I honestly don’t think that millage may vary on this one as it is one of the best no-cost GUI tools created for MySQL. With privileges granted, you have finished creating the RapidMiner Server database. Grant all privileges on rapidminer_server.* to identified by 'pswd' See the official MySQL documentation here for details.įrom the command line, create the database:Įxecute the following query to create a new user and grant privileges to the database rapidminer_server: If you do not have a GUI SQL editor available, for example when installing RapidMiner Server on a Linux machine, use the following instructions.Ĭhange the max_allowed_packet variable to at least 256M to allow storing larger models in the repository. You now have finished preparing the RapidMiner Server database. From the Server menu, select Startup/Shutdown and click Stop Server, followed by Start Server. Restart it as an administrator and try again.įinally, to apply this change you need to restart the database. If you get the error Could not save configuration file, you did not run the MySQL Workbench as an administrator.See the official MySQL documentation here for details. and in the new dialog that appears again Apply. Find the max_allowed_packet entry (should be at the top) and change it to at least 256M. Complete the screen with the credentials listed above.įrom the Server menu, select Options File and click the Networking tab. You can see the new schema, which has no tables, listed in the left pane.įrom the Server menu, select Users and Privileges to add a user account. In the Apply SQL Script to Database window, click Apply to run the SQL command that creates the schema.Ĭlick Finish. ![]() Open the MySQL Workbench as an administrator (Right-click, Run as Admin).Ĭlick on File>Create Schema to create the database schema.Įnter a name for the schema and click Apply. If you do not already have the software, download MySQL and install the product. Use these instructions to create a database using MySQL Workbench. The example uses the following credentials: Fieldįollow the instructions to create a database using a GUI, such as MySQL Workbench, or using the CLI. This example creates a MySQL database, but any common database platform is allowed. The following instructions provide a sample that illustrates how to create a simple, open-source database server for use by the RapidMiner service. You are viewing the RapidMiner Server documentation for version 7.6 - Check here for latest version Example: Creating a MySQL Database Schema
0 Comments
Leave a Reply. |