MySQL Workbench: Manage MySQL on Windows Servers the Windows way

The MySQL team has been continuously improving its products on the Windows platform. Along this line, we’ve responded to a request from our users of Workbench on Windows – to provide remote access to Windows Servers using Windows management methods – as an alternative  to SSH.

Managing a MySQL server obviously requires access to the target machine, which usually requires elevated rights for certain tasks like restarting the server or manipulating the configuration file on Windows (where this file is in a protected path). For local connections this is mostly not a big deal. However for remote boxes security measures prevent easy manipulation of such essential things like server processes. In this blog post we discuss native Windows management and how it can be used in MySQL Workbench.

Continue reading “MySQL Workbench: Manage MySQL on Windows Servers the Windows way”

MySQL Workbench 5.2.31 GA Available

We’re proud to announce the next release of MySQL Workbench, version 5.2.31. This is a maintenance release focusing on general product improvement and usability.

We managed to close 97 bugs for this release.

MySQL Workbench:  Remote Administration on Windows – Support for Windows “Remote” Management within the New Server Instance Wizard and Manage Server Instance Form. This works for servers on the same domain (or trusted) – ie typical Windows LAN environments.  We expect Windows users to prefer this “native” way to do remote admin on Windows.  SSH remote admin has been available for some time on Windows, Mac OS, and Linux.

MySQL Workbench:  Utilities Plugin – Starts a shell that contains a set of python scripts that perform basic tasks such as copying, exporting, and importing databases, finding database objects or processes, cloning servers and cloning users.

MySQL Workbench: Scripting shell – Provides python plugin scripters with break points, start, step, pause, and added debug information.

As always, we want to thank everyone for the great feedback we have received. This helps us to continuously improve the functionality and stability of MySQL Workbench – we appreciate all your ideas for improving MySQL Workbench.  Please keep sending us your ideas!
MySQL Workbench 5.2 GA

  • Data Modeling
  • Query (replaces the old MySQL Query Browser)
  • Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

To get started quickly, please take a look at this short tutorial.

MySQL Workbench 5.2 RC Tutorial

http://wb.mysql.com/?p=406

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness.
This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench on irc.freenode.net.

– The MySQL Workbench Team

MySQL Workbench 5.2.30 GA Available

We’re proud to announce the next release of MySQL Workbench, version 5.2.30. This is a maintenance release focusing on general product improvement and usability. In addition to that, we have added a small set of Text-Formatting-Plugins to the SQL Editor to help format/structure your SQL Queries.

As always, we want to thank everyone for the great feedback we have received. This helps us to continuously improve the functionality and stability of MySQL Workbench – we appreciate all your ideas for improving MySQL Workbench.  Please keep sending us your ideas!

About the Query-Formatter

In the Edit->Format menu of Workbench’s SQL Editor you will see a set of functions that assist in reformatting your SQL Queries, for example “Beautify Query”, “UPCASE Keywords”, etc.

MySQL Workbench 5.2 GA

  • Data Modeling
  • Query (replaces the old MySQL Query Browser)
  • Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

To get started quickly, please take a look at this short tutorial.

MySQL Workbench 5.2 RC Tutorial

http://wb.mysql.com/?p=406

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness.
This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench on irc.freenode.net.

– The MySQL Workbench Team

MySQL Workbench 5.2.29 GA Available

We’re proud to announce the next release of MySQL Workbench, version 5.2.29. This maintenance release focuses on general product improvement and usability.

As always, we want to thank everyone for the great feedback we have received. This helps us to continuously improve and extend the functionality and stability of MySQL Workbench – please keep up on approaching us with any ideas to develop our product even further.

New Workbench 5.2.29 Preference/Feature

Say you have been working on a model for hours in Workbench, and you haven’t saved in the last 90 minutes, suddenly the power goes out (or some other force majeure). Now with 5.2.29, if Workbench unexpectedly quits during modeling, the model you were working on will be restored to the last auto-saved version the next time you open that model.
As always, please remember to save and version your models regularly.
Also – you can change the value of Auto-Save Model Interval from its 5 minutes – go to Edit->Preferences and change within the General tab.

MySQL Workbench 5.2 GA

  • Data Modeling
  • Query (replaces the old MySQL Query Browser)
  • Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

To get started quickly, please take a look at this short tutorial.

MySQL Workbench 5.2 RC Tutorial

http://wb.mysql.com/?p=406

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness.
This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench on irc.freenode.net.

– The MySQL Workbench Team

MySQL Workbench 5.2.28 GA Available

We’re proud to announce the next release of MySQL Workbench, version 5.2.28. This maintenance release features improvements to the Workbench scripting Shell as well as various fixes.

Enhancements to the Workbench 5.2.28 Scripting Shell makes development and usage of Workbench Scripts and Plug-ins easier by

  • Providing a new workbench shell scripting file browser
  • Allowing users to more easily create/edit/save/execute Workbench python and lua scripts
  • Including Handy Workbench “Scripting” snippets that can easily be executed or copied.
  • Adding a new script results output panel

For more on Workbench Scripting and Plug-in development see

http://wb.mysql.com/?page_id=664

As always, we want to thank everyone for the great feedback we have received. This helps us to continuously improve and extend the functionality and stability of MySQL Workbench – please keep up on approaching us with any ideas to develop our product even further.

MySQL Workbench 5.2 GA

  • Data Modeling
  • Query (replaces the old MySQL Query Browser)
  • Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

To get started quickly, please take a look at this short tutorial.

MySQL Workbench 5.2 RC Tutorial

http://wb.mysql.com/?p=406

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness.
This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench onirc.freenode.net.

– The MySQL Workbench Team

MySQL Workbench 5.2.27 GA Available

We’re proud to announce the next release of MySQL Workbench, version 5.2.27. This is the second maintenance release for 5.2 GA (Generally Available). This maintenance release does not introduce any new features, but focuses on general product improvement and usability.  We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications.

As always, we want to thank everyone for the great feedback we have received. This helps us to continuously improve and extend the functionality and stability of MySQL Workbench – please keep up on approaching us with any ideas to develop our product even further.

MySQL Workbench 5.2 GA

  • Data Modeling
  • Query (replaces the old MySQL Query Browser)
  • Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

To get started quickly, please take a look at this short tutorial.

MySQL Workbench 5.2 RC Tutorial

http://wb.mysql.com/?p=406

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness.
This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench on irc.freenode.net.

– The MySQL Workbench Team

MySQL Workbench 5.2.26 GA Available

We’re happy to announce the release of MySQL Workbench 5.2.26. This is the first maintenance release for 5.2 GA (Generally Available). We have fixed a number of bugs and made some improvements under the hood. We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications.

We want to thank everyone for the great feedback we have received. This helps us to continuously improve and extend the functionality and stability of MySQL Workbench – please keep up on approaching us with any ideas to develop our product even further.

MySQL Workbench 5.2 GA

  • Data Modeling
  • Query (replaces the old MySQL Query
  • Administration (replaces the old MySQL Administrator)

Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

http://dev.mysql.com/downloads/workbench/

To get started quickly, please take a look at this short tutorial.

MySQL Workbench 5.2 RC Tutorial

Workbench Documentation can be found here.

http://dev.mysql.com/doc/workbench/en/index.html

In addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance – especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness.
This release also includes improvements to the scripting capabilities of the SQL Editor. You can read more about it in

http://wb.mysql.com/workbench/doc/

For a detailed list of resolved issues, see the change log.

http://dev.mysql.com/doc/workbench/en/wb-change-history.html

If you need any additional info or help please get in touch with us.

Post in our forums, leave comments on our blog pages or if you want to talk to us directly you can visit us on our IRC channel #workbench on irc.freenode.net.

– The MySQL Workbench Team

MySQL Workbench 5.2 Quick-Start Tutorial

MySQL Workbench 5.2 introduces a lot of new functionality and therefore this short tutorial will help you to get started quickly.

The Home Screen

The most prominent new addition in respect to previous Workbench releases is the new Home Screen. It allows you to access the main features of Workbench in a nice and easy way and is divided into 4 parts.

The upper Workbench Central panel features a few Links and Action Buttons to quickly access common resources.

The lower Workspace panel shows the main feature sets, grouped horizontally.

  • SQL Development allows editing and execution of SQL queries and scripts, create or alter database objects and edit table data.
  • Data Modeling covers the EER Modeling functionality you might already be familiar with from previous MySQL Workbench releases.
  • Server Administration offers administrative tasks like starting/stopping the server, edit the database server configuration, create user accounts, do data dumps and much more.

To quickly get started, use the following steps.

Home Screen Tutorial
Home Screen Tutorial
  1. Create a new Connection – Before you can start any other tasks — using the SQL Editor, forward engineering your model, or managing your database server, you need to create a new Database Connection. You can do that by using the New Connection Wizard or – if you are an advanced user – by using the Manage Connections dialog.You will have to enter the usual connection parameters, like IP address and port the server is running on as well as your username and password.
  2. Open Editor – After you have created a new connection, it will be displayed in the list of available Database Connections. Simply double-click on the list entry to open a SQL Editor and start querying.
  3. Create a new model – If you want to start your work by designing a visual database design first, click the Create new EER Model action item. An empty model will be created for you, only featuring the my_db schema which you can easily rename to the desired name.
  4. Create a New Server Profile – In order to administer your database server you have to register it within MySQL Workbench first.  Use the New Server Profile Wizard or – if you are an advanced user – use the Manage Server Profiles dialog.
  5. Open Admin – Once the new Server Profile is registered and appears in the list box you can double-click it to open the Admin.

Let’s take a closer look at the SQL Editor.

SQL Editor

The SQL Editor features a straight forward interface that gets you going, immediately.

SQL Editor Tutorial
SQL Editor Tutorial
  1. To give you instant access to your database objects we have added the Live Schema Overview panel to the SQL Editor. To start editing the data of an existing table, insert new data rows or manipulate existing data, simply double-click on the table.
  2. You can also modify the table structure by right-clicking on the table and select Alter … . This also works for any other database object.
  3. Enter your SQL queries and scripts on the SQL Statement panel. You can execute a single or multiple statements at the same time by clicking the Execution Arrow toolbar icon or hitting Ctrl+Return on the keyboard.
  4. If you create new objects by using SQL statements make sure to click the Refresh toolbar icon to update the Live Schema Overview panel and the Schema Tree.

We assume you already know how to use the EER Modeling and therefore we proceed with the Admin.

Admin

The Admin also features a very clear design that makes it easy to access the desired features.

Admin Tutorial
Admin Tutorial
  1. After opening the Admin you can see the Server Status panel at the top. Use this panel to verify the current server status and to check the current Server Health graphs.
  2. Select the corresponding Configuration tab that fits your current task.
  3. After selecting the correct Configuration tab perform the necessary actions on the Configuration page.

After studying this tutorial you should have a basic idea how the use MySQL Workbench 5.2 most efficiently. Please write a comment if you have a tip for other users.

MySQL Workbench 5.1.18 Available

We are proud to announce the next service release of MySQL Workbench 5.1.18. We have fixed another set of bugs and made some improvements you people have been asking for. We have optimized the layout of the Columns-section in our table-editor considering the ideas and exeriences you posted in feature requests, bug-reports and on the forums. Now it should provide a smoother more comfortable workflow.
As already reported in previous blog-posts, this version is also compatible with Apples recently released version of OSX – 10.6 Snow Leopard.
Detailed information on the fixes can be found on our Releases Page.

The new files are available on our download page:

http://dev.mysql.com/downloads/workbench/5.1.html

If you encounter problems or have any questions, you can always contact us via IRC (Channel #workbench on irc.freenode.net), leave a comment here on the blog or post your questions and ideas to the MySQL Forums.

The Workbench Team

MySQL Workbench 5.1.17 Available

We’re proud to announce the first service release of our current GA product MySQL Workbench 5.1. This maintenance release encompasses a number of stability, performance and quality improvements.
We were able to fix 56 bugs – as always, details on latest changes can be found on our Releases Page.

Please head over to our download page and fetch this new update:

http://dev.mysql.com/downloads/workbench/5.1.html

In addition to the improvements on the application, we also updated our packaging procedure to provide a more up to date selection of packages for recent distributions. Along with the Windows and OSX (intel) binaries we now provide binaries for the following Linux distributions:

Ubuntu 8.04  (32/64bit)
Ubuntu 9.04  (32/64bit)
Fedora 11     (32/64bit)

If you encounter any problems, please report them to our bugtracker. Feel free to contact us any time on IRC (irc.freenode.net, #workbench) for any questions or infos.

– The Workbench Team