Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 74 Next 30 Older Entries

Displaying posts with tag: Mac (reset)

AU/X, NeXTSTEP, & OS X
+0 Vote Up -0Vote Down

One thing that gets tedious in the IT community and Oracle community is the penchant for Windows only solutions. While Microsoft does an excellent job in certain domains, I remain a loyal Apple customer. By the way, you can install Oracle Client software on Mac OS X and run SQL Developer against any Oracle Database server. You can even run MySQL Workbench and MySQL server natively on the Mac OS X platform, which creates a robust development platform and gives you more testing options with the MySQL monitor (the client software).

Notwithstanding, some Windows users appear to malign Apple and the Mac OS X on compatibility, but they don’t understand that it’s a derivative of the

  [Read more...]
New MySQL Workbench video
Employee_Team +3 Vote Up -0Vote Down

The MySQL Workbench team just uploaded a new video to the MySQL channel at Youtube. This video is meant for beginners and describes the process of creating and troubleshooting connections in MySQL Workbench.

Mac Mini to the rescue
+0 Vote Up -0Vote Down

In teaching, I had a problem because my students have different base operating systems, like Windows 7, Windows 8, Linux, and Mac OS X. I needed a teaching and lecture platform that would let me teach it all (not to mention support their environments). That meant it had to virtualize any of the following with a portable device:

  • Windows 7 or 8 hosting natively an Oracle Database 11g XE, 11g, or 12c and MySQL Database 5.6
  • Windows 7 or 8 hosting a Fedora or Oracle Unbreakable Linux VM (3 or 4 GB) with Oracle Database 11g XE, 11g, or 12c and MySQL Database 5.6
  • Mac OS X hosting a Fedora or Oracle Unbreakable Linux VM (3 or 4 GB) with Oracle Database 11g XE,
  [Read more...]
MySQL Workbench: Frequent Crashes in Mac OS X? This might be the fix
Employee_Team +1 Vote Up -0Vote Down

If you’re having frequent MySQL Workbench crashes in Mac OS X, check whether you don’t have some Subversion plugin installed, such as SCFinderPlugin or SCToolbarButton. Apparently they are outdated and do not work well in recent versions of OS X, causing certain other innocent applications to crash. Removing these plugins should fix the problem in affected apps, including Workbench.

See Bug #71119 or Bug #68080

To check whether this is your problem, look for a line similar to the following in the Mac OS X crashlogs generated for Workbench:

 0xbe29000 -  0xbe2dff7 +org.tigris.scfinderplugin (169) <BBADB6CA-61AE-24D5-4E0A-EBCCAD3F0D92> /Library/Contextual Menu
  [Read more...]
Installing a driver for Microsoft SQL Server and Sybase ASE in Linux and Mac
Employee_Team +3 Vote Up -0Vote Down

In a recent post we showed you how to migrate a SQL Server database to MySQL. There, we used the oficial Microsoft ODBC driver and that’s OK if you are running MySQL Workbench in Windows. But what if your desktop OS is some Linux variant or Mac OS X?

It turns out that Microsoft has recently released an ODBC driver for Linux. However, you can’t use this driver with MySQL Workbench for Linux. (Actually you can, but you would have to rebuild Workbench). The main reason is that this ODBC driver was linked against unixODBC (an ODBC driver manager), while Workbench uses another ODBC driver manager: iODBC and the two of them

  [Read more...]
Switching to PHP 5.4 on OS X
+0 Vote Up -0Vote Down

I like using OS X's built-in packages where possible, but unfortunately Apple is way behind with their PHP package, having it locked on 5.3.15. In the past I've seen people use tools like Mamp, or Xampp to provide this for them, but frankly I'm not a big fan of these tools.

Homebrew provides a solution. Homebrew is OS X missing package manager, and it's an absolute great tool to work with. Getting started with it is a bit harder, as there's a few bigger dependencies you need, such as an up-to-date XCode installation. Once you've installed homebrew, it's a matter of running the following commands:

  • brew tap homebrew/dupes
  • brew tap josegonzalez/homebrew-php
  • brew install
  •   [Read more...]
    Mountain Lion Pre-MySQL
    +2 Vote Up -0Vote Down

    While I try to contain everything about installing MySQL in a single post that I update from time-to-time, Mac OS X, Mountain Lion (10.8.x), requires some pre-steps. You must install XCode, and the Command Line Tools. This post provides the screen shots and step-by-step instructions.

    Before you can do any of these steps, you must connect to the Apple Store and download XCode. Dependent on your internet speed this may take some time. Generally, it’s an hour or less.

  • After installing XCode, click the Rocket Spaceship in the Mac Dock to launch a view of your Applications. Launch XCode by clicking on the hammer overlaying the blue background XCode icon shown below.
  •   [Read more...]
    MySQL Workbench 5.2.36 GA available
    Employee_Team +0 Vote Up -0Vote Down

    MySQL Workbench 5.2.36 has been released. This release is part of an ongoing effort committed to improving the day to day usability of the product based on accumulated experience from tools such as MySQL Query Browser and input from user feedback.

    This specific version was focused on improving usability of the Query Editor. Some of the changes introduced are:

    • New, redesigned Query Editor layout. Output messages are always visible while resultsets and the query editor can be resized according to the task at hand. Resultsets are now in the same tab as their generating query editor.
    • Several minor changes that make the difference for a frustration-free, comfortable use of the tool. Sidebar sizes, the last selected schema and other state information is now properly remembered between sessions. Keyboard navigation of resultsets has been fixed to properly handle Tab key navigation in all
      [Read more...]
    Installing MySQLdb on MacOS Lion
    +0 Vote Up -0Vote Down

    I ran into an issue installing the MySQLdb module.

    >>> import MySQLdb
    /Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg/_mysql.pyc, but /Users/jhaddad/Downloads/MySQL-python-1.2.3 is being added to sys.path
    Traceback (most recent call last):
    File ““, line 1, in
    File “MySQLdb/__init__.py”, line 19, in
    import _mysql
    File “build/bdist.macosx-10.7-intel/egg/_mysql.py”, line 7, in
    File “build/bdist.macosx-10.7-intel/egg/_mysql.py”, line 6, in __bootstrap__
    ImportError:







      [Read more...]
    MySQL Workbench 5.2.35 GA Available
    Employee_Team +2 Vote Up -0Vote Down

    The MySQL Developer Tools team is proud to announce the next release of it’s flagship product, MySQL Workbench, version 5.2.35. This is the next maintenance release containing 29 bug fixes as well as new feature additions. We also updated the supported platforms to include most recent editions of Fedora and Ubuntu Linux.

    MySQL Workbench 5.2.35 now supports the Native Windows Authentication Method – available in the commercial MySQL server product – and the creation of user accounts utilizing this new authentication method.

    For the PHP developers out there, Workbench now also comes with a new set of plugins to turn SQL Queries into PHP code to be put right into your scripts.

    A big “Thank You” again to everyone for the large amount of feedback and ideas we have received on how to further improve and extend MySQL Workbench. We are continuously working on improving the

      [Read more...]
    MySQL Workbench 5.2.34 GA Available
    Employee_Team +3 Vote Up -0Vote Down

    The MySQL Developer Tools team is pleased to announce the next release of it’s flagship product, MySQL Workbench, version 5.2.34. This is a maintenance release containing 100 bug fixes; ranging from stability improvements on all supported platforms – including some that prevented startup in certain environments – to minor but significant usability corrections.

    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

      [Read more...]
    A cool terminal tip for Mac users
    +3 Vote Up -0Vote Down
    If you use a Mac, and you are dealing with many similar tasks at once, like examining many database servers in different terminals, you may like this one.
    I have been using iTerm 2 for a while, and my handling of parallel tasks has improved a lot. (No, I am not talking about Parallel replication, although I have applied this trick while testing that technology as well.)
    iTerm2 has some cool features, and probably the most striking one is split panes. That alone would be a good reason for giving iTerm2 a try. But the one that I use the most, often in combination with Split Panes, is called Send Input to all tabs.
    Here is how it works.


      [Read more...]
    MySQL Workbench 5.2.33 GA Available
    Employee_Team +4 Vote Up -0Vote Down

    The MySQL developer tools team announces the next release of it’s flagship product, MySQL Workbench – version 5.2.33. This is a maintenance release only which corrects some problems we didn’t cover in last release. It contains fixes for 7 bugs or enhancement requests.

    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.

      [Read more...]
    MySQL Workbench 5.2.32 GA Available
    Employee_Team +1 Vote Up -0Vote Down

    We’re proud to announce the next release of MySQL Workbench, version 5.2.32. This is a maintenance release featuring
    a new and improved UI appearance and several corrections and other enhancements.

    The tabbed interface has been refreshed to obtain a clearer separation between different modules of Workbench, while improving responsiveness when switching between tabs. The Query Formatter has been rewritten and is now faster and more robust on its handling of queries. The layout of the Administration module has been changed to allow for easier future expansion and use less vertical screen space. Parts that had problems managing MySQL 5.5 servers have been fixed along other total of 53 bugs or enhancement requests have been addressed.

    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


      [Read more...]
    MySQL Workbench 5.2.31 GA Available
    Employee_Team +5 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Workbench 5.2.30 GA Available
    Employee_Team +1 Vote Up -0Vote Down

    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
      [Read more...]
    MySQL Workbench 5.2.29 GA Available
    Employee_Team +4 Vote Up -1Vote Down

    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

      [Read more...]
    MySQL Workbench 5.2.28 GA Available
    Employee_Team +3 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Workbench 5.2.27 GA Available
    Employee_Team +6 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Workbench 5.2.26 GA Available
    Employee_Team +4 Vote Up -0Vote Down

    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

      [Read more...]
    MySQL Workbench 5.2.22 RC 2 Available
    Employee_Team +1 Vote Up -0Vote Down

    Dear MySQL Users,

    We’re happy to announce the second Release Candidate (RC) of MySQL Workbench.
    Version 5.2.22 includes fixes for 76 bugs.

    In case you didn’t know – MySQL Workbench is a modular product and is fully pluggable and scriptable. If you want to write a plug-in for Workbench 5.2, then stay tuned as we will be updating the documentation in the next week with all the details and examples you need on how to write your own plug-ins.

    Plug-ins are great for extending or adding to workbench or for automating repetitive tasks. You can do things like adding to menus, exporting your Workbench models custom tailored for your coding environment, adding your own forms, and more. Python is our preferred scripting language but for simple scripts the Lua language can be used as well.

    The first plug-in we added is called MySQL Doc Library. It can be used to read the MySQL


      [Read more...]
    On Writing a Book, Pt. 4 – The Tools (II)
    +1 Vote Up -0Vote Down

    This is part four of an ongoing series about my experiences while writing the MySQL Admin Cookbook for Packt Publishing. All previous parts can be found under the mysql-admin-cookbook label.

    This part will be about more software used in the process of writing the book. The last episode covered writing tools, file/version management and backups. What's up now is graphics programs, virtualization and PDF handling.

    Outlining

    For outlining and

      [Read more...]
    MySQL Workbench 5.2.21 RC Available
    Employee_Team +1 Vote Up -0Vote Down

    Dear MySQL Users,

    We’re happy to announce the first Release Candidate (RC) of MySQL Workbench.
    Version 5.2.21 includes many improvements and fixes for 62 bugs.

    We have introduced a new ease of use feature on the Workbench Home screen – the Plug-in Starter area – top left hand side. The icons listed in that area are used to get quick access to the most popular plug-ins that have been written for MySQL Workbench, either by us or the community.

    If you are planning to write a plug-in for Workbench, now is the right time to get started! We will be updating the documentation in the next week or 2 with all the details on how to write your own plug-in.

    MySQL Workbench designed in a modular way and is fully scriptable. Whenever you have to perform repetitive tasks or e.g. need to export your Workbench models tailored for your coding environment, writing a plugin to perform this task


      [Read more...]
    MySQL Workbench 5.2.20 Beta 10 Available
    Employee_Team +0 Vote Up -0Vote Down

    Announcing a new beta 10 release of MySQL Workbench. Version 5.2.20 includes new fixes for 49 bugs (P1 – 1, P2 – 7 , P3 – 39, P4 – 2)

    A few new tips you might try. Some have been in the last 2 betas – but in case you haven’t noticed:

  • Once connected in SQL Editor – type control-T or command-T to add a new editor Tab
  • In the SQL Editor run a select. Highlight a cell (one with an image blob preferably) and right click (or command click) and select “Open Value in Viewer” or another option.
  • In a results set — select multiple rows — right click and “copy row content”
  • Click on snippets. Click on the selector and look at DDL and DML lists.
  • Add your own snippets selection drop down option by creating an empty file in the snippets folder and re-opening Workbench.
  • For example on Windows

      [Read more...]
    MySQL Workbench 5.2.19 Beta 9 Available
    Employee_Team +2 Vote Up -0Vote Down

    Just one week after the latest Beta we are now releasing the next followup build WB 5.2.19 that again fixes a number of issues found in the last Betas. Since beta 8 we were able to close another 32 bugs (P1 – 2, P2 – 4 , P3 – 26).

    A big “thank you” to all the people who have been testing MySQL Workbench 5.2 alphas and betas and taking the time to file bugs and provide valuable feedback.

    MySQL Workbench 5.2 Beta 5 provides:

  • Data Modeling
  • Query (upgrade from MySQL Query Browser)
  • Admin (upgrade from MySQL Administrator)
  • if you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench

    As always, you will find binaries for the various platforms on our download pages.

    Please get your copy from our Download

      [Read more...]
    MySQL Workbench 5.2.18 Beta 8 Available
    Employee_Team +2 Vote Up -0Vote Down

    We’re proud to announce Beta 8 of MySQL Workbench 5.2.
    Since beta 7 we have fixed additional bugs as well as put in some improvements requested by the community so we decided to pack up another release for you to check out. This Beta includes fixes for 35 bugs (P1 – 1, P2 – 10 , P3 – 24)

    Also we have added new HUD-style (FADE IN) UI elements to show wait-times while WB is setting up connections (currentlz windows only, will be added to linux/mac in next release).

    Additionally we have added Connection-/Instance-sorting, now you can go to the connection/instance manager and sort using up/down buttons.

    For more on these new features check out http://wb.mysql.com

    A big “thank you” to all the people who have been testing MySQL Workbench 5.2 alphas and betas and taking the time to file bugs and provide valuable feedback. We have fixed many bugs since last


      [Read more...]
    MySQL Workbench 5.2.17 Beta 7 Available
    Employee_Team +2 Vote Up -0Vote Down

    We are proud to announce Beta 7 (5.2.17).
    As you will see, for Beta 7 we focused on UI and usability.

    This Beta includes:

    • Fixes for 69 bugs.
      • P1 -4, P2 – 21 , P3 – 41 and P4 – 3.
    • New Windows UI components
    • New “look” for windows version
    • Modern style tab-controls
    • New UI, toolbars and sidebar-placements
    • Easier to use
    • Improved look and feel
    • Distinct User Snippets
    • Pre-Loaded DML and DDL Snippet Libraries
    • SQL Editor
      • All DDL Statements for changes are available.
      • Results menu bar
    • In Output
      • added Details Pane for Action and Message

    And there’s more, so check it out and see for yourself.

    For more on these new features check out http://wb.mysql.com

    We want to thank all the people who have been


      [Read more...]
    MySQL Workbench 5.2.16 Beta 6 Available
    Employee_Team +1 Vote Up -0Vote Down

    We have published a new beta release of Version 5.2.16 Workbench Beta 6 build includes fixes for 67 bugs.

    In Beta 6 we’ve also responded to great community ideas and feedback with various new convenience and security features:

  • Saving your profile/connection passwords in OSX keychain, gnome-keyring or – for windows – in a encrypted password-vault-file.
  • New rapid development features for generating complete SQL Select/DML statements or names for selected objects in Query Editor to either the query area or clipboard.
  • New in the Windows version (coming to Mac and Linux soon) the ability to set a preference for the placement of the sidebar in the Query Editor (left or right side.)
  • And last but not least, we put a good bit of focus on optimizing and stabilizing the administrator components.
  • We want to thank all the people who have been testing MySQL

      [Read more...]
    Installing Midnight Commander 4.7 on Mac OS X
    +1 Vote Up -2Vote Down

    Another short post just to remember the procedure for the next time I’ll be setting up a new mac. For those of my readers who do not know what Midnight Commander (aka mc) is, GNU Midnight Commander is a visual file manager, created under a heavy influence of Norton Commander file manager from dark DOS ages For more information, you can visit their web site. Now, get to the installation topic itself.

    To install mc on a Mac OS X machine, you need macports installed and then first thing you’ll need to do is to install some prerequisite libraries:

    1
    $ sudo port install libiconv slang2

    Next thing, download the sources


      [Read more...]
    Finishing touches
    +0 Vote Up -0Vote Down

    The book is in its final stages. Right now I am putting the finishing touches to the illustrations and going through the editors’ most recent comments and suggestions. Takes a lot more time than expected, though…

    Showing entries 1 to 30 of 74 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.