macOS Setup

Finder Preferences Finder -> Preferences General Show these items on the desktop – Click all Advanced Show file extensions. Show Folders on Top -> In windows when sorting by name

macOS Setup iTerm2 + Homebrew + ZSH

This guide is my setup on my macOS laptop with iTerm + Homebrew + ZSH. Step 1 – Install iTerm2 Pretty self explanatory! Go get iTerm2 at https://iterm2.com and install it! Step 2 – Install Homebrew Again, another easy step! Install Homebrew at https://brew.sh/ at the time of this posting the following command works. Also … Read more

Windows 10, ZSH, Putty, Powerline Fonts and Screen

I recently was setting up my Windows 10 desktop machine with Putty so I could access some servers. I use the ZSH shell with OMZ and the Powerline9k theme. I use the following article to set up Putty and grab the appropriate fonts for Windows 10 that were patched. http://mschulte.nl/posts/using-powerline-in-PuTTY.html There were some additional options … Read more

Creating Users and Databases in MySQL 8 and Percona 8

If you’ve started using MySQL 8, you’ll notice your usually commands for creating a user no longer function. That’s because it’s changed in MySQL 8, you need to now create a user, then grant privileges. Let’s create a user The critical part here is the “mysql_native_password” if you don’t have this portion, you’ll get errors … Read more

Searching WordPress MySQL Dump Files

From time to time, you’ll need to look at data within MySQL dump files, specifically I do it mostly with WordPress. There isn’t an easy way to search the dump unless you use grep. Here are some useful grep commands. Pull out a table. [enlighter linenumbers=”true”] grep ‘INSERT INTO `wp_bspr_users`’ dump.sql > /tmp/users.sql [/enlighter] Format … Read more

Experience with Thunderbolt 3 USBC Docking Stations for macOS

Current Setup I had a request from a client to purchase dual monitors for their Macbook Pro Late 2013 (or Macbook11,1). I also wanted to sort out my own setup Macbook Pro 2016 (Macbook13,2). Currently I’m using the following, an Apple USB-C Digital AV Multiport Adapter and a generic ArkTek branded adapter. Both come with … Read more