Mac – 熱血剪貼部

[Mac] Sequel Pro & MySQL 連接錯誤問題

By -剪刀
Posted on 西元2021年06月20日週日六月 20
Posted in Mac

1. 使用預設使用者 Root 、空密碼連結時的錯誤

解法：重新設定密碼為 mysql_native_password 格式

2. 使用最新的 Sequel Pro 1.1.2 搭配ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash

解法：下載 test build 版的 Sequel Pro

[Mac] Download Streaming Media from Azure Media Service

By -剪刀
Posted on 西元2021年05月15日週六五月 15
Posted in Mac, Web

1. Install ffmpeg

brew install ffmpeg

2. Find your azure media link

Open browser developer window and refresh your page. (F12 for Chrome & Sidekick users shortcut)
Search "manifest" and copy the request url.

3. Download by ffmpeg

ffmpeg -protocol_whitelist file,http,https,tcp,tls,crypto -i your_url} -c copy {output.mp4}

[Mac] EaseUS MobiMover Apple裝置互傳 + Youtube影片下載

By -剪刀
Posted on 西元2020年06月15日週一六月 16
Posted in Mac, 數位

如果你想要在不同 Apple 裝置間互傳或是資料轉移可以使用官方的 iTunes 搭配 iCloud 但是通常只能整台轉移，或是不好一覽到底哪些該傳 Ease MobiMover 這款軟體可以讓在不同裝置傳輸之前輕鬆勾選想要的項目進行傳輸，還有熱門影片平台下載功能！

Overview

下載 EaseUS MobiMover

手機傳送到 Mac

Mac 傳送到手機

內容管理

影片下載

[Mac] 打造美觀又潮的終端機：iTerm + Oh My Zsh + Agnoster + Powerline

By -剪刀
Posted on 西元2018年04月21日週六八月 10
Posted in Mac

只要是在 Mac 環境下工作的工程師一定會使用到 Terminal 但內建的實在太醜、完全沒有 highlight 加上沒分頁，用起來實在很不方便 ~~看起來不夠宅不夠專業~~ 所以趕快來把你的 Terminal 用潮一點吧！

Overview

1. Install Homebrew /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" 2. Install iTerm brew cask install iTerm2 brew install caskroom/cask/iterm2 brew install caskroom/versions/iterm2-legacy brew install caskroom/versions/iterm2-nightly 3. Install Oh My Zsh sh -c "$(curl -fsSL https://raw.github.com/robbyrussell/oh-my-zsh/master/tools/install.sh)" 4.Set zsh theme to agnoster edit ~/.zshrc file and set ZSH_THEME="agnoster" 5. Install Powerline Fonts git clone https://github.com/powerline/fonts.git cd fonts ./install.sh cd .. rm -rf fonts 6.Remove device name & user name edit ~/.zshrc file and add export DEFAULT_USER=whoami

[Unity] Decompile Dll：ILSpy for Mac

By -剪刀
Posted on 西元2018年04月13日週五四月 13
Posted in Unity

Overview

1. 下載 ILSpy for Mac 2. 打開終端機切換到下載目錄下 3. 鍵入 mono ILSpyMac.exe -n 自訂名稱 Dll資料夾路徑

[Mac] Movavi Screen Recorder 螢幕錄影教學

By -剪刀
Posted on 西元2018年02月24日週六六月 10
Posted in Mac

Movavi Screen Recorder 是一個很不錯的錄影軟體它的滑鼠與鍵盤效果、錄影排程、以及 Youtube 分享功能都是一般錄影軟體沒有的很適合想要錄製教學影片、遊戲影片、或是 Youtuber 來使用另外錄影完成後的輸出速度與檔案大小也都蠻理想的目前已成為我要製作教學影片的首選！

[Mac] 找回沒儲存到的 QuickTime Player 錄影檔

By -剪刀
Posted on 西元2017年09月20日週三九月 20
Posted in Mac

有時候 QuickTime 會未預期的 Crash 編輯到一半的檔案不見了怎麼辦？別擔心，打開 Finder 在上方工具列選擇前往 => 前往檔案夾然後貼上以下路徑就可以找到 QuickTime 自動儲存的錄影檔了 ~/Library/Containers/com.apple.QuickTimePlayerX/Data/Library/Autosave Information/

[Mac] 如何使用 Movavi Video Converter 來壓縮影片？

By -剪刀
Posted on 西元2017年05月20日週六六月 15
Posted in Mac

如果你想要快速轉檔或是壓縮影片且要支援各種不同格式、或要放到不同平台裝置上同時又要能夠對影片進行一些簡單的編輯 Movavi Video Converter 是個很不錯的選擇！

Overview

1. 下載 Movavi Video Converter 2. 加入來源影片或媒體 3. 編輯亮度對比、色調飽和度 4. 加入浮水印 5. 旋轉和翻轉 6. 修剪影片 7. 輸出設定 8. 完成輸出！

[Mac] 修改環境變數下的路徑

By -剪刀
Posted on 西元2016年04月27日週三
Posted in Mac
1 Comment

列出環境變數

printenv

列出環境變數下的 Path

echo $PATH

打開 bash profile

vi ~/.bash_profile

新增路徑到 PATH

export PATH=$PATH:路徑名稱

存擋

:wq

執行 bash profile

source ~/.bash_profile

[Mac] PPSSPP：PSP模擬器下載

By -剪刀
Posted on 西元2016年03月21日週一
Posted in Mac

Overview

1. 下載PPSSPP 2. 打開終端機，安裝 Brew 3. 透過Brew安裝SDL2 4. 打開下載好的PPSSPP 5. 瀏覽至遊戲目錄(.rom 或 .iso) ，開始玩吧！

collapsCat options: Array ( [title] => Categories [showPostCount] => 1 [inExclude] => exclude [inExcludeCats] => [showPosts] => 0 [showPages] => 0 [linkToCat] => 1 [olderThan] => 0 [excludeAll] => 0 [catSortOrder] => ASC [catSort] => catOrder [postSortOrder] => ASC [postSort] => postOrder [expand] => 0 [defaultExpand] => [debug] => 1 [postTitleLength] => 0 [catfeed] => none [taxonomy] => category [post_type] => post [postDateAppend] => after [postDateFormat] => m/d [showPostDate] => 1 [useCookies] => 1 [postsBeforeCats] => 1 [expandCatPost] => 1 [showEmptyCat] => 1 [showTopLevel] => 1 [useAjax] => 0 [customExpand] => [customCollapse] => [style] => kubrick [accordion] => 1 [title_link] => [addMisc] => 1 [addMiscTitle] => [q2w3_fixed_widget] => [conditions] => Array ( [action] => hide [match_all] => 1 [rules] => Array ( [0] => Array ( [major] => page [minor] => post_type-post [has_children] => ) ) ) [number] => 2 [includeCatArray] => Array ( ) [expandSym] => ► [collapseSym] => ▼ ) postsToExclude: Array ( ) CATEGORY QUERY RESULTS Array ( [0] => WP_Term Object ( [term_id] => 81 [name] => Mac [slug] => mac [term_group] => 0 [term_taxonomy_id] => 48 [taxonomy] => category [description] => [parent] => 47 [count] => 14 [filter] => raw [term_order] => 0 ) [1] => WP_Term Object ( [term_id] => 88 [name] => Android [slug] => android [term_group] => 0 [term_taxonomy_id] => 69 [taxonomy] => category [description] => [parent] => 73 [count] => 1 [filter] => raw [term_order] => 0 ) [2] => WP_Term Object ( [term_id] => 90 [name] => Facebook [slug] => facebook [term_group] => 0 [term_taxonomy_id] => 73 [taxonomy] => category [description] => [parent] => 47 [count] => 2 [filter] => raw [term_order] => 0 ) [3] => WP_Term Object ( [term_id] => 79 [name] => Ruby on Rails [slug] => ruby-on-rails [term_group] => 0 [term_taxonomy_id] => 98 [taxonomy] => category [description] => [parent] => 6 [count] => 5 [filter] => raw [term_order] => 0 ) [4] => WP_Term Object ( [term_id] => 80 [name] => Sublime [slug] => sublime [term_group] => 0 [term_taxonomy_id] => 100 [taxonomy] => category [description] => [parent] => 6 [count] => 0 [filter] => raw [term_order] => 0 ) [5] => WP_Term Object ( [term_id] => 104 [name] => Shell [slug] => shell [term_group] => 0 [term_taxonomy_id] => 104 [taxonomy] => category [description] => [parent] => 6 [count] => 1 [filter] => raw [term_order] => 0 ) [6] => WP_Term Object ( [term_id] => 107 [name] => Python [slug] => python [term_group] => 0 [term_taxonomy_id] => 107 [taxonomy] => category [description] => [parent] => 6 [count] => 1 [filter] => raw [term_order] => 0 ) [7] => WP_Term Object ( [term_id] => 5 [name] => 遊記 [slug] => traveling [term_group] => 0 [term_taxonomy_id] => 5 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 1 ) [8] => WP_Term Object ( [term_id] => 16 [name] => ActionScript 3.0 [slug] => as3 [term_group] => 0 [term_taxonomy_id] => 16 [taxonomy] => category [description] => [parent] => 6 [count] => 2 [filter] => raw [term_order] => 1 ) [9] => WP_Term Object ( [term_id] => 34 [name] => App [slug] => app [term_group] => 0 [term_taxonomy_id] => 34 [taxonomy] => category [description] => [parent] => 36 [count] => 30 [filter] => raw [term_order] => 1 ) [10] => WP_Term Object ( [term_id] => 30 [name] => 法國 [slug] => france [term_group] => 0 [term_taxonomy_id] => 30 [taxonomy] => category [description] => [parent] => 5 [count] => 35 [filter] => raw [term_order] => 1 ) [11] => WP_Term Object ( [term_id] => 51 [name] => Blog [slug] => blog [term_group] => 0 [term_taxonomy_id] => 52 [taxonomy] => category [description] => [parent] => 50 [count] => 1 [filter] => raw [term_order] => 1 ) [12] => WP_Term Object ( [term_id] => 57 [name] => Chrome [slug] => chrome [term_group] => 0 [term_taxonomy_id] => 63 [taxonomy] => category [description] => [parent] => 47 [count] => 2 [filter] => raw [term_order] => 1 ) [13] => WP_Term Object ( [term_id] => 75 [name] => 縮時 [slug] => %e7%b8%ae%e6%99%82 [term_group] => 0 [term_taxonomy_id] => 93 [taxonomy] => category [description] => [parent] => 41 [count] => 1 [filter] => raw [term_order] => 1 ) [14] => WP_Term Object ( [term_id] => 76 [name] => 羅東 [slug] => lotung [term_group] => 0 [term_taxonomy_id] => 95 [taxonomy] => category [description] => [parent] => 3 [count] => 5 [filter] => raw [term_order] => 1 ) [15] => WP_Term Object ( [term_id] => 3 [name] => 食記 [slug] => food [term_group] => 0 [term_taxonomy_id] => 3 [taxonomy] => category [description] => [parent] => 0 [count] => 1 [filter] => raw [term_order] => 2 ) [16] => WP_Term Object ( [term_id] => 23 [name] => 宜蘭 [slug] => taiwan-ilan [term_group] => 0 [term_taxonomy_id] => 23 [taxonomy] => category [description] => [parent] => 3 [count] => 6 [filter] => raw [term_order] => 2 ) [17] => WP_Term Object ( [term_id] => 25 [name] => 書記 [slug] => book [term_group] => 0 [term_taxonomy_id] => 25 [taxonomy] => category [description] => [parent] => 50 [count] => 0 [filter] => raw [term_order] => 2 ) [18] => WP_Term Object ( [term_id] => 38 [name] => 香港 [slug] => hongkong [term_group] => 0 [term_taxonomy_id] => 38 [taxonomy] => category [description] => [parent] => 5 [count] => 10 [filter] => raw [term_order] => 2 ) [19] => WP_Term Object ( [term_id] => 42 [name] => 後製 [slug] => post-production [term_group] => 0 [term_taxonomy_id] => 42 [taxonomy] => category [description] => [parent] => 41 [count] => 2 [filter] => raw [term_order] => 2 ) [20] => WP_Term Object ( [term_id] => 68 [name] => LeetCode [slug] => leetcode [term_group] => 0 [term_taxonomy_id] => 81 [taxonomy] => category [description] => [parent] => 6 [count] => 0 [filter] => raw [term_order] => 2 ) [21] => WP_Term Object ( [term_id] => 70 [name] => Resource [slug] => resource [term_group] => 0 [term_taxonomy_id] => 85 [taxonomy] => category [description] => [parent] => 73 [count] => 1 [filter] => raw [term_order] => 2 ) [22] => WP_Term Object ( [term_id] => 20 [name] => 宜蘭 [slug] => ilan [term_group] => 0 [term_taxonomy_id] => 20 [taxonomy] => category [description] => [parent] => 5 [count] => 6 [filter] => raw [term_order] => 3 ) [23] => WP_Term Object ( [term_id] => 15 [name] => 熱血 [slug] => hotblood [term_group] => 0 [term_taxonomy_id] => 15 [taxonomy] => category [description] => [parent] => 50 [count] => 1 [filter] => raw [term_order] => 3 ) [24] => WP_Term Object ( [term_id] => 36 [name] => 遊戲 [slug] => games [term_group] => 0 [term_taxonomy_id] => 36 [taxonomy] => category [description] => [parent] => 0 [count] => 12 [filter] => raw [term_order] => 3 ) [25] => WP_Term Object ( [term_id] => 54 [name] => Google Play [slug] => google-play [term_group] => 0 [term_taxonomy_id] => 58 [taxonomy] => category [description] => [parent] => 73 [count] => 1 [filter] => raw [term_order] => 3 ) [26] => WP_Term Object ( [term_id] => 66 [name] => C# [slug] => c [term_group] => 0 [term_taxonomy_id] => 78 [taxonomy] => category [description] => [parent] => 6 [count] => 2 [filter] => raw [term_order] => 3 ) [27] => WP_Term Object ( [term_id] => 77 [name] => 蘇澳 [slug] => suao [term_group] => 0 [term_taxonomy_id] => 96 [taxonomy] => category [description] => [parent] => 3 [count] => 0 [filter] => raw [term_order] => 3 ) [28] => WP_Term Object ( [term_id] => 19 [name] => Flash [slug] => flash [term_group] => 0 [term_taxonomy_id] => 19 [taxonomy] => category [description] => [parent] => 6 [count] => 5 [filter] => raw [term_order] => 4 ) [29] => WP_Term Object ( [term_id] => 39 [name] => 台中 [slug] => taichung [term_group] => 0 [term_taxonomy_id] => 39 [taxonomy] => category [description] => [parent] => 5 [count] => 6 [filter] => raw [term_order] => 4 ) [30] => WP_Term Object ( [term_id] => 59 [name] => 婚事 [slug] => %e5%a9%9a%e4%ba%8b [term_group] => 0 [term_taxonomy_id] => 66 [taxonomy] => category [description] => [parent] => 50 [count] => 5 [filter] => raw [term_order] => 4 ) [31] => WP_Term Object ( [term_id] => 64 [name] => Web [slug] => web [term_group] => 0 [term_taxonomy_id] => 74 [taxonomy] => category [description] => [parent] => 47 [count] => 7 [filter] => raw [term_order] => 4 ) [32] => WP_Term Object ( [term_id] => 71 [name] => iOS [slug] => ios [term_group] => 0 [term_taxonomy_id] => 86 [taxonomy] => category [description] => [parent] => 73 [count] => 2 [filter] => raw [term_order] => 4 ) [33] => WP_Term Object ( [term_id] => 73 [name] => App開發 [slug] => app-develop [term_group] => 0 [term_taxonomy_id] => 90 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 4 ) [34] => WP_Term Object ( [term_id] => 74 [name] => 桃園 [slug] => taoyuan [term_group] => 0 [term_taxonomy_id] => 92 [taxonomy] => category [description] => [parent] => 3 [count] => 1 [filter] => raw [term_order] => 4 ) [35] => WP_Term Object ( [term_id] => 6 [name] => 程式設計 [slug] => programming [term_group] => 0 [term_taxonomy_id] => 6 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 5 ) [36] => WP_Term Object ( [term_id] => 7 [name] => Flash Develop [slug] => flash-develop [term_group] => 0 [term_taxonomy_id] => 7 [taxonomy] => category [description] => [parent] => 6 [count] => 3 [filter] => raw [term_order] => 5 ) [37] => WP_Term Object ( [term_id] => 24 [name] => 中壢 [slug] => jongli [term_group] => 0 [term_taxonomy_id] => 24 [taxonomy] => category [description] => [parent] => 3 [count] => 2 [filter] => raw [term_order] => 5 ) [38] => WP_Term Object ( [term_id] => 46 [name] => 苗栗 [slug] => miaoli [term_group] => 0 [term_taxonomy_id] => 46 [taxonomy] => category [description] => [parent] => 5 [count] => 2 [filter] => raw [term_order] => 5 ) [39] => WP_Term Object ( [term_id] => 48 [name] => Windows [slug] => windows [term_group] => 0 [term_taxonomy_id] => 49 [taxonomy] => category [description] => [parent] => 47 [count] => 2 [filter] => raw [term_order] => 5 ) [40] => WP_Term Object ( [term_id] => 67 [name] => iTunes Connect [slug] => itunes-connect [term_group] => 0 [term_taxonomy_id] => 88 [taxonomy] => category [description] => [parent] => 73 [count] => 6 [filter] => raw [term_order] => 5 ) [41] => WP_Term Object ( [term_id] => 47 [name] => 數位 [slug] => digital [term_group] => 0 [term_taxonomy_id] => 47 [taxonomy] => category [description] => [parent] => 0 [count] => 1 [filter] => raw [term_order] => 6 ) [42] => WP_Term Object ( [term_id] => 52 [name] => Unity [slug] => unity [term_group] => 0 [term_taxonomy_id] => 54 [taxonomy] => category [description] => [parent] => 73 [count] => 55 [filter] => raw [term_order] => 6 ) [43] => WP_Term Object ( [term_id] => 69 [name] => Git [slug] => git [term_group] => 0 [term_taxonomy_id] => 84 [taxonomy] => category [description] => [parent] => 6 [count] => 5 [filter] => raw [term_order] => 6 ) [44] => WP_Term Object ( [term_id] => 78 [name] => 台中 [slug] => taichung-food [term_group] => 0 [term_taxonomy_id] => 97 [taxonomy] => category [description] => [parent] => 3 [count] => 1 [filter] => raw [term_order] => 6 ) [45] => WP_Term Object ( [term_id] => 41 [name] => 攝影 [slug] => photograph [term_group] => 0 [term_taxonomy_id] => 41 [taxonomy] => category [description] => [parent] => 0 [count] => 11 [filter] => raw [term_order] => 7 ) [46] => WP_Term Object ( [term_id] => 53 [name] => Visual Studio [slug] => visual-studio [term_group] => 0 [term_taxonomy_id] => 56 [taxonomy] => category [description] => [parent] => 6 [count] => 1 [filter] => raw [term_order] => 7 ) [47] => WP_Term Object ( [term_id] => 65 [name] => XCode [slug] => xcode [term_group] => 0 [term_taxonomy_id] => 76 [taxonomy] => category [description] => [parent] => 73 [count] => 6 [filter] => raw [term_order] => 7 ) [48] => WP_Term Object ( [term_id] => 49 [name] => Wordpress [slug] => wordpress [term_group] => 0 [term_taxonomy_id] => 50 [taxonomy] => category [description] => [parent] => 6 [count] => 4 [filter] => raw [term_order] => 8 ) [49] => WP_Term Object ( [term_id] => 50 [name] => 人生 [slug] => life [term_group] => 0 [term_taxonomy_id] => 51 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 8 ) [50] => WP_Term Object ( [term_id] => 1 [name] => 未分類 [slug] => %e6%9c%aa%e5%88%86%e9%a1%9e [term_group] => 0 [term_taxonomy_id] => 1 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 9 ) ) POST QUERY: POST QUERY RESULTS
►遊記 (59)
- 法國 (35)
- 香港 (10)
- 宜蘭 (6)
- 台中 (6)
- 苗栗 (2)
►食記 (16)
- 羅東 (5)
- 宜蘭 (6)
- 蘇澳 (0)
- 桃園 (1)
- 中壢 (2)
- 台中 (1)
►遊戲 (42)
- App (30)
►App開發 (72)
- Android (1)
- Resource (1)
- Google Play (1)
- iOS (2)
- iTunes Connect (6)
- Unity (55)
- XCode (6)
►程式設計 (29)
- Ruby on Rails (5)
- Sublime (0)
- Shell (1)
- Python (1)
- ActionScript 3.0 (2)
- LeetCode (0)
- C# (2)
- Flash (5)
- Flash Develop (3)
- Git (5)
- Visual Studio (1)
- Wordpress (4)
►數位 (28)
- Mac (14)
- Facebook (2)
- Chrome (2)
- Web (7)
- Windows (2)
►攝影 (14)
- 縮時 (1)
- 後製 (2)
►人生 (7)
- Blog (1)
- 書記 (0)
- 熱血 (1)
- 婚事 (5)
►未分類 (0)

1. 使用預設使用者 Root 、空密碼連結時的錯誤

2. 使用最新的 Sequel Pro 1.1.2 搭配 ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash

2. Find your azure media link

3. Download by ffmpeg

Overview

Overview

Overview

Overview

列出環境變數

列出環境變數下的 Path

打開 bash profile

新增路徑到 PATH

存擋

執行 bash profile

Overview

2. 使用最新的 Sequel Pro 1.1.2 搭配ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash