• Download from MySQL official website. Some bugs has been reported by people that use Homebrew to install MySQL.

• Open and install it. There is only one file to install now, not three!

• Edit ~/.zshrc and add the following lines:

alias mysql="/usr/local/mysql/bin/mysql"
alias mysqladmin="/usr/local/mysql/bin/mysqladmin"

• Run mysqladmin -u root password "yourpassword" in iTerm2.

• Go to MySQL in System Preference and turn it on.

• Download, install and open Sequel Pro. In Host, fill in 127.0.0.1, username root and then password, tap Connect. By the way, the default port is 3306.

• File > Import your .sql file.

This post will be constantly updated. More or less a cleanup and a showoff.

Contents

• Setup
• Apps
  • Bought
  • Free
    • Companion Apps
  • Game Related
  • Other
• Bridging Win and Mac
• Games
  • Games Wishlist
• Win positioning

Setup

Hardware: Alienware X51 R2

• CPU: i7 4770
• RAM: 16GB
• Storage: 2TB HD
• GPU: GTX 760 Ti with 2GB GDDR5
• Additionally, Xbox 360 Controller for PC

Read more

Contents

• Basic Structure
• Preamble
  • \usepackage
    • Font Rendering
    • Environments or Objects
      • Maths
      • Floats
      • Tables
      • Drawing Graphics
    • Miscellaneous
  • Other Package Specifications
  • New Command Declarations
  • Title Page
• Document
  • Math Symbols
  • More on Math Typesetting
  • PGF/TikZ
  • Others
  • Environments
• Resources

Read more

Contents

• Notes
• Steps
  • Install and Update System
  • Fuck Animation
  • System Preferences
    • Line 1
    • Line 2
    • Line 4
  • Finder
  • Browser
  • Apps From MAS
    • Install MAS Apps
      • I
      • II
    • Essential MAS Apps
    • Non-Essential MAS Apps
  • Apps From Official Websites
    • Install Other Apps
      • I
      • II
    • License the Apps
    • Other Essential Apps
    • Other Non-Essential Apps
• OS X Keyboard Shortcuts
  • Stock Keyboard Shortcuts
    • Global
    • Within Apps
  • Custom Keyboard Shortcuts
• Appendix 1 Fuck Animation Commands
• Appendix 2 Custom Search URLs
• Appendix 3 Additional MAS Apps

Read more

Contents

• Example
  • Get words
  • Append to a file
  • Sort alphabetically
• Systematisation of good
• Taxonomy

Example

I did a KM cleanup yesterday (not finish yet) and found I have stopped using many unnecessary Mac apps for some time. It’s a good thing.

To expand the use of KM, I will have to dive into shell. Next I take an example about adding new words to Mac’s spelling records.

Read more

Here what I want to do is to move the oldest file from folder A to folder B at a specified time every day.

Read more

Contents

• It’s Simple
• Declare Codes to an App
• How to Set a File Input?
• How to Save Outputs in an External File?
• Group Codes Using ()
• Get Filename
• Get Rid of Extension
• How to Check Data Type
• Pass A List to Python
  • Pass a Workable File Path to a Python Script in AS

Gist

Read more

Retina MacBook Pro was a headache when I stocked screenshots, and Ember seems not able to capture non-retina screenshots. Visual bookmarking also has been a unsolved issue, given Zootool and 爱库 (aiku) were dead, Kippt may not work for some websites and Webbla doesn’t support retina (by the way, its version 2 will be available in this summer). More or less, this workaround has solved the above problems, for me.

Gist

Read more

Read more

Contents

• Download PDF
• Sort the folder
• Index pages
• Export notes to Evernote

Read more