phpMyAdmin

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:

SQLite to MySQL

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.

MacOS Terminal DMG/PKG Installation

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:

MySQL 5.7 on Mac OS X 10.11 El Capitan

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.

Subscribe to MySQL