MySQL on MySQLWorkbench on OS X Yosemite

April 1, 2015

I upgraded my laptop to Yosemite (Mac OS X Version 10.10.2). It’s good. I like the simpler graphics. Far as I can tell so far, all my applications work properly but I had problems with MySQLWorkbench which was crashing when I attempted to start the local MySQL server. I didn’t know if the problem was MySQLWorkbench or with MySQL.

I used Google to find out if others reported the same problem with solutions and didn’t get very far. The solutions were for other problems.

Here’s what I did and I hope it helps others who see this.

1. From https://dev.mysql.com/downloads/workbench/ downloaded and installed version 6.3

2. From http://dev.mysql.com/downloads/downloaded and installed version 5.6.23

3. Launched MySQLWorkbench and was disappointed that it still crashed.

4. In the Terminal, started MySQL Server with the command: “sudo /usr/local/mysql/support-files/mysql.server start”

5. This start command worked and apparently had the affect of creating the files needed for MySQL to configure itself and and start properly.

6. Re-lauched MySQLWorkbench and connected to the Local server. It detected that MySQL was running. I tested further by starting and stoping the server via MySQLWorkBench.

All now seems to be ok for my needs.


Writing with Scrivener on Mac and iPad

September 3, 2012

I am using and impressed with Scrivener as a tool to help me with my writing. While I’ve been using Word since Word 3.0 in the days of DOS, Scrivener has pretty much replaced Word except for when I have to use it when collaborating with colleagues where they are using Word. At some point I’ll write more about makes Scrivener so useful to me. Recommended. Only US$45.

Something which has eluded me, until now–which also hindered my writing projects using Word–was how to make it easier to write on both the Mac and the iPad and let the machines handle the synchronisation. Further, I wanted to write in the iPad without losing any formatting in the text. Everything that I read was about using SimpleNote, Elements, or other text editors. I wanted RTF capability and I wanted it to work well with DropBox.

I’ve cracked it.

  • Dropbox is the tool to move the files. It’s an elegant and simple tool.
  • Set Scrivener to sync (Menu: File/Sync/With External Folder …) with a folder in the Dropbox folder tree. I use ~/Dropbox/Apps/Scrivener/Sync/ but you can also use a symbolic link pointing to some other location.
  • on the iPad, use the app “Notability” which has RTF capability. Unusually for iPad apps, it also can navigate the Dropbox folder structure on the iPad. Import the RTF files in the Scrivener folder file into Notability app and do you work with it. You can create new RTF files in Notability and export them back to the Scrivener sync folder in Dropbox.
  • In Scrivener, open the writing project and the first thing to do is sync with the Dropbox Folder (Menu: File/Sync/With External Folder Now)

Someday there will be an iPad version of Scrivener. With the above, I’m not sure I really need or want Scrivener on the iPad but if there I’m sure the syncing will be even more automated. But until that day comes I have what I need.


Small Discovery with Hazel … press “alt” key for sub-rules

September 3, 2012

I discovered Hazel from the “Mac Power User” podcast. Hazel has really helped my personal productivity by allowing me to automate a number of time-consuming things related to my consulting business management.

In setting up a new Hazel rule to experiment with a new idea I used Google search to see if I could get some ideas from others. In that search I ran across an article where in the “Condition” part of the Hazel rule a sub-rule “if” statement was used.

Hazelsubrule.

I wrote the author and got an almost immediate reply:

Hazel has a fairly hidden feature that allows you to do this. Instead of pressing the + button to add a new condition, holding down the Option key will turn that plus sign into ellipses, and clicking the ellipses will allow you to add sub-rules like I did; you can end up with as many nested conditions as you’d like.

As an added bonus, this trick generally applies to other apps with ‘rule editor’ interfaces like Hazel. Many applications that allow you to define conditions with this interface (it’s a standard Apple-provided interface kit) respond to this Option-click, which is cool.

“Fairly hidden” is an understatement. But it works. And it’s an important discovery for me as I am pretty sure the rules I’m going to be writing need that sort of capability.

Hazel is “cool”.