(中文)
1. 使用預設使用者 Root 、空密碼連結時的錯誤
解法：重新設定密碼為 mysql_native_password 格式
2. 使用最新的 Sequel Pro 1.1.2 搭配 ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash
解法：下載 test build 版的 Sequel Pro
熱血人次： 43[Mac] Sequel Pro & MySQL 連接錯誤問題
[Mac] Download Streaming Media from Azure Media Service
(中文)
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}
[Unity] Manual set Android NDK path when UnityHub Add Modules failed
![[Unity] Manual set Android NDK path when UnityHub Add Modules failed](http://blog.ctrlxctrlv.net/wp-content/uploads/2015/09/Unity-700x290.jpg "[Unity] Manual set Android NDK path when UnityHub Add Modules failed")
(中文)
1. Hack the NDK version number
Open file source.properties with a txt file
Modify Pkg.Revision to your NDK target version number
Pkg.Revision = 19.0.5232133
2. Fix NDK Signing
Open terminal, go to NDK root and execute the scripts to reset extended attribute and fix the signing.
熱血人次： 437
Migrate Unity 2D Game to Cocos Creator
(中文)
Overview
本文主要分享從 Unity 2D 小遊戲轉移到 Cocos Creator 上的一些心得。
1. Why？
2. 會遇到什麼問題？
3. 轉移要花多少時間？
4. C# => TypeScript
5. Unity => Cocos
6. 小結
[Mac] EaseUS MobiMover Apple裝置互傳 + Youtube影片下載
![[Mac] EaseUS MobiMover Apple裝置互傳 + Youtube影片下載](http://blog.ctrlxctrlv.net/wp-content/uploads/2020/06/mac-ease-mobimover-700x290.png "[Mac] EaseUS MobiMover Apple裝置互傳 + Youtube影片下載")
(中文) 如果你想要在不同 Apple 裝置間互傳或是資料轉移
可以使用官方的 iTunes 搭配 iCloud
但是通常只能整台轉移，或是不好一覽到底哪些該傳
Ease MobiMover 這款軟體可以讓在不同裝置傳輸之前
輕鬆勾選想要的項目進行傳輸，還有熱門影片平台下載功能！
Overview
[Unity] Microphone or Camera not working on Mac UnityHub?
(中文)
Solution 1
Use Unity.app directly instead of UnityHub.
Solution 2
Insert access database by SQLite.
熱血人次： 717
[Unity] Jetbrains Rider 安裝與使用
![[Unity] Jetbrains Rider 安裝與使用](http://blog.ctrlxctrlv.net/wp-content/uploads/2019/10/unity-jetbrains-rider-640x290.png "[Unity] Jetbrains Rider 安裝與使用")
(中文)
Overview
1. Install Jetbrains Rider
2. Unity External Tools
3. Unity File Templates
4. Namespace
5. Find Usages
6. Code Vision
7. Typo Detection
8. Error Detection
9. Unity Serialized Field Naming
10. Terminal
11. Version Control
12. Code Style
13. Reformat Code on Save (Macros)
14. Renaming MonoBehaviour
[App] Line Chef – Gameplay & Playthrough Videos
![[App] Line Chef – Gameplay & Playthrough Videos](http://blog.ctrlxctrlv.net/wp-content/uploads/2019/08/app-line-chef-college-road-700x290.jpg "[App] Line Chef – Gameplay & Playthrough Videos")
Line Chef – Gameplay & Playthrough Videos
熱血人次： 2087
(中文) [Unity] Performance Test – String Concat
![(中文) [Unity] Performance Test – String Concat](http://blog.ctrlxctrlv.net/wp-content/uploads/2019/07/unity-performance-string-concat-700x290.png "(中文) [Unity] Performance Test – String Concat")
(中文) Recommended to use string.Concat() or directly use + operator for better performance.
Test times: 10,000,000
1. PlusOperator: 6825
2. Interpolation: 10037
3. StringFormat: 9940
4. StringConcat: 6822
5. StringJoin: 8255
6. StringBuilder: 7157
(中文) [Python] Install Python3、PiP、Jupyter
![(中文) [Python] Install Python3、PiP、Jupyter](http://blog.ctrlxctrlv.net/wp-content/uploads/2019/06/Python2.png "(中文) [Python] Install Python3、PiP、Jupyter")
(中文) Python3
brew install python3
python3 –version
PiP
curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
python3 get-pip.py
pip –version
Jupyter
pip3 install jupyter