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

By 剪刀六月 20 Mac No Comments

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

Authentication plugin caching_sha2_password cannot be loaded: 
dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

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

ALTER USER 'root'@'localhost'; IDENTIFIED WITH mysql_native_password BY '';

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

Sequel Pro encountered an unexpected error.

解法：下載 test build 版的 Sequel Pro

Download Streaming Media from Azure Media Service

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

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

Movavi Screen Recorder 螢幕錄影教學

Tagged on: Mac, MySQL

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)

熱血剪貼部

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

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

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

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

解法：下載 test build 版的 Sequel Pro

Related Post:

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

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

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

解法：下載 test build 版的 Sequel Pro

Related Post:

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

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