Tagged: macOS Toggle Comment Threads | Keyboard Shortcuts

  • Jay Versluis 11:26 am on November 2, 2015 Permalink | Reply
    Tags: , macOS,   

    Categories: MySQL ( 19 )   

    How to install MySQL on Mac OS X El Capitan 

    MySQL 2015

    There are several ways to install MySQL on your Mac, for example:

    • compile from source
    • use the Homebrew package manager (http://brew.sh)
    • use a nifty script courtesy of Mac Mini Vault (http://git.io/eUx7rg)
    • or use the dedicated MySQL installer package (recommended)

    I recommend the dedicated installer because it’s the only package that will also add a convenient Preference Pane for starting and stopping the service.

    In this article I’ll focus on the latter, and I’ll also talk you through how to add MySQL to the PATH variable and how to secure MySQL to keep the evildoers away from your server.

    These instructions will work on Yosemite and El Capitan (I’ve tested it on both systems – in fact that’s part of why I’m writing this, so that I can remember for next time).


    Screen Shot 2015-11-02 at 10.40.12

    (More …)

    • Rob Wells 9:40 pm on April 19, 2017 Permalink | Reply

      This tutorial saved me a lot of time and did the trick. Many, many thanks

      • Jay Versluis 7:17 pm on April 22, 2017 Permalink | Reply

        Great to hear!

    • imorenodev 2:12 pm on July 21, 2017 Permalink | Reply

      Thanks for this!

  • Jay Versluis 6:07 pm on August 23, 2014 Permalink | Reply
    Tags: macOS,   

    Categories: How To ( 35 )   

    How to enable automatic user logins on Mac OS X Yosemite 

    Screen Shot 2014-08-23 at 17.49.01By default Yosemite doesn’t like users to auto-login when the system starts. Instead you have to select a user, type in the password, and then the system starts to boot. Not necessarily what we want.

    To disable this feature you usually head over to

    • System Preferences
    • Users and Groups
    • Login Options

    and pick your default user from that handy drop down menu. Notice however that this is greyed out on Yosemite:

    Screen Shot 2014-08-23 at 17.47.59

    So what gives?

    Turns out that this option is not available if you’ve agreed to encrypt your disk via FileVault. And it makes sense too: otherwise your hard disk data could be accessed upon boot without a password, rendering this feature useless.

    Hence, to bring back automatic logins, turn off FileVault under

    • System Preferences
    • Security and Privacy
    • FileVault

    Screen Shot 2014-08-23 at 17.56.24

    According to this system, I can do that in about 32 days…

    Notice that if you use your iCloud password as the login password, auto-logins are also disabled. In which case, change your login password to a “separate password”, switch off FileVault and voila – auto logins are back at your disposal.

    Screen Shot 2014-08-23 at 18.02.06

    • Itaque 3:15 pm on August 3, 2015 Permalink | Reply

      I tried doing this, made sure I am using a different password than iCloud and turned file vault off and unlocked my settings in groups and chose my account from the pull down menu but it still asks me for my password WHY!

    • Erich 1:14 am on October 4, 2015 Permalink | Reply

      my vault IS NOT ON but everything is encrypted anyway (for some reason) How do I shut off password login? And why do I have to remember MORE passwords to get rid of using one all the time, even though I:m sure I’ll be forced to use it later (again , for some reason) I don’t ever want to use a password again , and someone steals some of my files, then they probably need them more than I do, and think leaving them out to be stolen is my right anyway! I mean, they’re my files, right?. Please respond.

      • Jay Versluis 11:37 pm on October 6, 2015 Permalink | Reply

        Pass I’m afraid, Erich: if your FileVault is not on, and you’re not using an Apple ID to login, and the Automatic Login option is set to your current user, and you’re still being asked for a password, then I’m afraid I have no idea what’s up with your system. May I suggest a visit to the Genius Bar, or perhaps a call to Apple Support.

  • Jay Versluis 2:55 pm on July 31, 2014 Permalink | Reply
    Tags: macOS, Microsoft, Office,   

    Categories: Bookmarks ( 18 ), Screencast ( 87 )   

    How to update Microsoft Office for Mac 2011 – despite Microsoft Database Daemon and SyncServicesAgent errors 

    Every time I try to update Microsoft Office 2011 on my Mac I get this ridiculous window popping up. No matter how hard you try, those two services – Microsoft Database Daemon and SyncServicesAgent – keep relaunching themselves, forever preventing you to apply the update.

    Clearly Microsoft (or Apple) don’t want us to update Office for Mac:

    Screen Shot 2014-07-31 at 14.49.45Usually I give up and live without such updates. I only use M$ Office once in a blue moon and really don’t care. Today I got curious and researched this phenomenon – and thought I’d tell you about it.

    Several suggestions are available to combat this superb example of a terrible user experience:

    • rename those processes
    • log out, then log back in with the shift key held down
    • go offline just before this message comes up
    • kill the processes with the Activity Monitor Utility

    None of those suggestions worked for me, and besides: what a hack any of these solutions are to apply a simple security patch.

    What did work was a very clever suggestion by someone named vrleboss: Use a while loop on the command line and continually kill those processes until you’re done.

    Here’s how to do it: Open the Terminal utility on your Mac and paste the following code:

    while true; do kill $(ps -ef | grep -i SyncServices | grep -v grep | awk '{print $2} '); done

    You can do this without quitting anything else, even while the pesky “close applications” window is displayed. Make sure the whole command is on the same line. The is a BASH loop that will find both processes and kill them as soon as they start up again. Don’t worry about the continuous text output in the window.

    Back in the Microsoft Updater window, hit “Close Applications and Install”. Now it works!

    Once the update is applied, head back to the Terminal window and press CTRL+C – this will stop the killing loop. Close Terminal and Office for Mac is finally updated.

    Then repeat this process next week, when another 140MB of updates will have to be applied.

    Watch the Screencast

    Update May 2015

    Looks like Microsoft have finally found a way to make updates happen without the necessity for such backdoor hackery. Since version 14.5.0 I was able to update both my systems without the above code.

    I thought I’d take a screencast on this happy occasion (because I still can’t believe it myself):

    • Shelley Hill 12:39 pm on January 13, 2015 Permalink | Reply

      Thank you! The last time I did this, I spent over an hour on the phone with a Tech. This worked just like your video! Awesome!

      • Jay Versluis 1:21 pm on January 13, 2015 Permalink | Reply

        That’s great to hear, Shelley 🙂

    • The Manic Gardener 9:02 am on February 1, 2015 Permalink | Reply

      Hi, Jay. Thanks for the tips. I did everything, as instructed, and it didn’t quite work. It did eliminate “SyncServicesAgent” error, but the “Microsoft Database Daemon” remains. I’m on OS X Yosemite 10.10.2

      Any ideas?


      • Jay Versluis 4:56 pm on February 1, 2015 Permalink | Reply

        Hi Karen,

        I’ve just tried this on my Yosemite 10.10.2 system and the script kills both services as it should.

        You could try to kill the Database Daemon manually by opening Activity Monitor (under Applications – Utilities – Activity Monitor, search for “Microsoft”, this should display “Microsoft Database Daemon” in the list). Start the Terminal script, start the update, and then kill the service from the Activity Monitor (the X icon at the top left). Now select “Try Again” in the updater window. It’s like a game to outsmart Office: if you win, you get the update 😉

        Alternatively, reboot your system, start the Terminal script, and then try to update Office again.

        Good luck!

    • Anne 3:02 pm on February 12, 2015 Permalink | Reply

      Thank you. Thank you. Thank you. This has been driving me nuts for months.

    • Carpentier 8:26 am on February 15, 2015 Permalink | Reply

      For the last update (14.4.48), I tried to stop the Microsoft Database Daemon and SyncServicesAgent.
      For the Microsoft Database Daemon, I succeeded in stopping the process. For the SyncServicesAgent daemon, I cannot stop it (or put in “sleeping” state) with your command file.
      So I found another idea. I deleted the “SyncServicesAgent.app” file and tried again the update. It worked.
      A new file was created with the update. However, in case of…, the “deleted” file could also be replaced in its previous directory.
      My opinion : Installing Microsoft software (updates) is always a “nightmare”.


      • Jay Versluis 10:18 am on February 15, 2015 Permalink | Reply

        Great feedback Jean-François, thank you!

        I’ve upgraded one of my machines to Yosemite, and Office for Mac 2011 has now completely stopped working for me. When I open an app it now presents me with the registration dialogue, and when I type in my (legally purchased) product key, the system tells me it’s invalid. This is the last nail in the coffin for this crummy software.

    • LIAM BAURESS 5:19 pm on February 18, 2015 Permalink | Reply

      Works a treat.Thank you!

    • Johan 1:13 pm on February 25, 2015 Permalink | Reply

      Magic! Even on Yosemite 10.10.2. Thanks from Sweden 🙂

      • Jay Versluis 7:24 pm on February 25, 2015 Permalink | Reply

        Super, thanks for your feedback! Now we know it’s definitely working on Yosemite 10.10.2.

    • Simon Spenbcer 6:48 am on April 4, 2015 Permalink | Reply

      Very helpful thank you. I’ve noticed that these two things Sync Services and Database Daemon crash quite often – which I thinnk is slowing down the start up of my MAC. Any ideas how to permanently stop these things working? Thanks

      • Jay Versluis 9:46 am on April 4, 2015 Permalink | Reply

        I wouldn’t advise to switch those services off – Office needs them to live, and they’re there for a reason (not that I know what that reason is).

        A slow starting Mac usually has other reasons: try running Disk Utility and see if you have any corrupted files.

        I’ve explained how to do this here: https://wpguru.co.uk/2015/02/how-to-reduce-the-progress-bar-in-yosemite/

    • John Peil 5:23 pm on May 16, 2015 Permalink | Reply

      Jay you are AMAZING!!! I tried an innumerable number of options from both Apple and Microsoft. Nothing quite works. Like one of your other posters I can stop Microsoft Database Daemon via Activity Monitor, but SyncServicesAgent cannot be stopped and now it cannot be deleted either — “this file is in use blah blah blah” Your advice worked perfectly. I was so excited about finally have the POWER over that dang program that I used that line of code several times after the installation was completed just so I could watch it disappear from the Activity Monitor.
      Thank you again for your help, I’m giving this URL to every single one of my friends and family….and maybe even some strangers.

      • Jay Versluis 9:15 am on May 18, 2015 Permalink | Reply

        That’s great to hear, John! I was taken by surprise when Office update 14.5 came out a week ago: it just worked without complaints by these two pesky services.

        Is there hope yet for Microsoft? Could they really have fixed the problem after so many years?

        Time will tell 😉

        • Richard Weathers 10:53 pm on May 30, 2015 Permalink | Reply

          Apparently not; just hit the same wall on 14.5.1. Sigh.

          • Jay Versluis 11:47 am on May 31, 2015 Permalink

            Interesting. It would have been too good to be true if it had just started to work 🙂 What would we do without the weekly “critical fix routine”?

            I’ve just applied 14.5.1 myself, and the warning window came up as usual, stating I had to close Word and our two friendly system services. I simply closed Word, selected “Close applications and continue”, and the patch installed without a hitch, for the second time now. Let me try it on my other system, I’ll report back!

          • Jay Versluis 12:46 pm on May 31, 2015 Permalink

            Here’s how I did it – I thought I’d take a screencast to commemorate this lucky occasion (added underneath the previous video due to formatting problems).

    • Richard Weathers 10:51 pm on May 30, 2015 Permalink | Reply

      This. Is. AWESOME. Love the occasional MS jabs as well. 🙂

  • Jay Versluis 7:11 am on June 9, 2014 Permalink | Reply
    Tags: macOS, ,   

    Categories: Screencast ( 87 )   

    How to populate an NSTableView in Code 

    In this screencast I’ll show you how to power an NSTableView using code. I’m referencing this article for code snippets and details: http://pinkstone.co.uk/how-to-populate-an-nstableview-in-code/

    I’ve also made a “no-code” version on how to populate an NSTableView using an Array Controler and Cocoa Bindings here: http://pinkstone.co.uk/how-to-bind-an-nsarraycontroller-to-an-nstableview/


  • Jay Versluis 7:07 am on June 2, 2014 Permalink | Reply
    Tags: macOS, NSarrayController, ,   

    Categories: Screencast ( 87 )   

    How to bind an Array Controller to a Table View with Cocoa Bindings 

    In this screencast I will show you how to bind a Table View to an Array Controller in Cocoa, using Xcode 5.1 and OS X Mavericks. We’re using Core Data to save our entries and – check it out – we’re not writing a single line of code!

    Cocoa Bindings is one of the most exciting features in OS X development for me, and I hope that one day it’ll find its way into iOS too.

    The project is also available on GitHub: https://github.com/versluis/Bindings-Demo

    I’ve written more about how to do this here: http://pinkstone.co.uk/binding-an-nstableview-to-core-data-without-code/

  • Jay Versluis 7:55 am on May 19, 2014 Permalink | Reply
    Tags: , macOS,   

    Categories: Screencast ( 87 )   

    How to use Branches in Xcode 

    In this video I will show you how to use the Git Branch feature in Xcode 5.1.

    Branches are helpful if you’re developing your app. You can isolate a “working” version, create a new branch and fiddle with new features that may destabilise your project. You can then commit your changes – working or not – to a separate branch, and when all is stable again you can merge them back into the master project.

    I use this feature for plugin and theme development, in fact for any “group of files” that will change over time. If you’re not using Xcode, take a look at the GitHub Apps which are available for Mac and Windows. They make version control a breeze on your local system, integrate flawlessly with GitHub.com as well as SSH remotes on your own server.

  • Jay Versluis 7:52 am on May 12, 2014 Permalink | Reply
    Tags: , macOS,   

    Categories: Screencast ( 87 )   

    How to use Git Tags in Xcode 

    In this video I will show you how to make use of Tags in Git. This is not supported in Xcode or GitHub for Mac at the time of this recording (April 2014). I will also show you how to utilise the Tag/Release feature on GitHub.com.

    Tags are a useful feature if you want to mark versions of your software before you add new features. With Tags you can always go back to the code of a release.

    We’re using Xcode 5.1 and the Terminal utility for this.

    I use tags and branches for plugin and theme development too, in fact for any “group of files” that will change over time. If you’re not using Xcode, take a look at the GitHub Apps which are available for Mac and Windows. They make version control a breeze on your local system, integrate flawlessly with GitHub.com as well as SSH remotes on your own server.

  • Jay Versluis 11:57 am on March 3, 2014 Permalink | Reply
    Tags: , , macOS   

    Categories: Screencast ( 87 )   

    How to remove data from your iCloud Storage 

    Apple_Podcast_logoTrouble backing up your device to iCloud? Is your storage constantly at the limit and you don’t know what to do about it?

    Fret not! In this video I will show you some option you have to deal with that dreaded message “Not enough iCloud Storage”.

    Essentially there are four things you can do to prevent this problem:

    • buy more iCloud Storage
    • backup less data (for example, don’t backup pictures)
    • remove older iCloud backups (think of devices you no longer own)
    • use less iCloud Document Storage (remove data from iMovie Theater, Shared Photostreams)

    I will demonstrate all these options on my iPod Touch and show you how it works.



  • Jay Versluis 5:54 pm on February 21, 2014 Permalink | Reply
    Tags: macOS,   

    Categories: PHP ( 29 )   

    Getting Started with ZEND Server 6 on Mac OS X 


    I’ve just installed ZEND Server 6.3 on my MacBook running Mavericks 10.9.1. Needless to say I’m sill a little shaken up from the huge amount of brain pain this adventure has caused.

    Because once downloaded and installed on your system, you may ask yourself a vital question: Now What?

    Let’s find out. This article is Work in Progress – bear with me while I flesh it out.

    The Basics

    ZEND Server on Mac is located here:

    • /usr/local/zend/

    Your web files live here:

    • /usr/local/zend/apache2/htdocs

    To open this directory in Finder you can navigate there with a Terminal session and open it, like so:

    cd /usr/local/zend/apache2/htdocs
    open .

    Now you can create a shortcut on your sidebar for easy access.

    To access the ZEND Server Admin interface, navigate to the following URL in your browser:

    If you’re done with it, you can uninstall ZEND Server with the following command:

    sudo /usr/local/zend/bin/uninstall.sh

    (More …)

  • Jay Versluis 6:35 pm on February 15, 2014 Permalink | Reply
    Tags: macOS, ,   

    Categories: PHP ( 29 )   

    How to install ZEND Framework for use with MAMP 

    ZEND_logoIf you have MAMP installed and working on your Mac, it’s easy to get started with ZEND Framework development. I’ll show you how in this article.

    Download the framework from here:

    Choose the full version without ZEND Server (not necessary as we’re using MAMP). Unpack the download and put it somewhere safe. I’m adding mine to my Documents directory. I’ll also rename my folder to something like “ZendFramework” without the version number.

    To access it from anywhere on our machine we’ll create an alias named “zf”. zf is a shell script provided by the framework that we’ll need throughout our development journey with ZEND. Let’s to this in a Terminal session:

    alias zf="/Users/you/Documents/ZendFramework/bin/zf.sh'

    Replace the path with your own. Notice the call to /bin/zf.sh which is the “real” shell script. Our alias has just made this universal and accessible without having to mess with our shell path.

    Verify that it’s working with this:

    zf show version
    Zend Framework Version: 1.12.3

    Read the full article

Compose new post
Next post/Next comment
Previous post/Previous comment
Show/Hide comments
Go to top
Go to login
Show/Hide help
shift + esc