I'm sure I'm late to the party, but I recently started delving into MySQL variables. It may or may note help with the problem I'm currently dealing with, that of excessively lengthy queries.
As a Mac user, my primary client for mysql database management (when I'm not using command-line tools) has been Sequel Pro (formerly Cocoa MySQL). Now that Sequel Pro has been abandoned, I figured I might as well try out PHPMyAdmin, especially considering that's what most web hosting portals use.
This guide assumes you already have a functional apache2/mysql server running.
Installation on my Ubuntu web server via the command line was trivial. First, ensure that all repositories and packages are up-to-date:
I've been a licensed amateur radio operator since 2015, and Mac user since 1997. The combination of these two meant that when I was looking for a logging application for my ham radio contacts, my options were limited, which is fine since MacLoggerDX is such a great application.
I recently found myself remotely installing/upgrading MySQL on a remote MacOS machine without GUI access. It's an old but solid PowerMac G5 running 10.5 Leopard. I couldn't remember how to do this, but a quick search provided the following solution.
The first step was mounting the disk image (dmg):
$ sudo hdiutil attach
The volume will be mounted at /Volumes/<dmg>
Next, install the pkg file:
$ sudo installer -pkg /Volumes/<dmg>/<pkg> -target /
Lastly, cleanup:
So for reasons too extensive to get into in this post, I decided to make the jump on my MacBook Pro from OS X 10.8 (Mountain Lion) to the latest OS X which at the time was 10.11 El Capitan. Prior to making this leap, I checked the compatibility of all my mission critical applications. Naturally, however, the upgrade came with many challenges when it came to setting up the local web application development framework. Apache was fairly straightforward, as was PHP 5.6. MySQL was another story.