Mac | 熱血剪貼部

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

By 剪刀六月 20 Mac No Comments

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

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

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

解法：下載 test build 版的 Sequel Pro

熱血人次： 70

[Mac] Download Streaming Media from Azure Media Service

By 剪刀五月 15 Mac, Web No Comments

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}

熱血人次： 109

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

By 剪刀六月 15 Mac, 數位 No Comments

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

Overview

下載 EaseUS MobiMover

手機傳送到 Mac

Mac 傳送到手機

內容管理

影片下載

熱血人次： 713

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

By 剪刀四月 21 Mac No Comments

只要是在 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

熱血人次： 9486

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

By 剪刀二月 24 Mac No Comments

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

熱血人次： 1860

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

By 剪刀九月 20 Mac No Comments

有時候 QuickTime 會未預期的 Crash
編輯到一半的檔案不見了怎麼辦？

別擔心，打開 Finder
在上方工具列選擇前往 => 前往檔案夾
然後貼上以下路徑
就可以找到 QuickTime 自動儲存的錄影檔了

~/Library/Containers/com.apple.QuickTimePlayerX/Data/Library/Autosave Information/

熱血人次： 3688

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

By 剪刀五月 20 Mac No Comments

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

Overview

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

熱血人次： 2777

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

By 剪刀四月 27 Mac 1 Comment

列出環境變數

printenv

列出環境變數下的 Path

echo $PATH

打開 bash profile

vi ~/.bash_profile

新增路徑到 PATH

export PATH=$PATH:路徑名稱

存擋

:wq

執行 bash profile

source ~/.bash_profile

熱血人次： 27575

[Mac] PPSSPP：PSP模擬器下載

By 剪刀三月 21 Mac No Comments

Overview

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

熱血人次： 12308

[Mac] QuickTime 螢幕錄影 + 錄音 + 播音

By 剪刀十二月 17 Mac 1 Comment

Overview

1. 下載並安裝 SoundFlower
2. 製作多重輸出裝置
3. 確認錄音與播音同步

熱血人次： 55827

« Previous

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] => [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

列出環境變數

列出環境變數下的 Path

打開 bash profile

新增路徑到 PATH

存擋

執行 bash profile

Overview

Overview

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