[InstallOnMac]MySQL Community Server 8.0.11 and mysql workbench 6.3

Jameskrauser Lee
2 min readJun 6, 2018

--

step1.
download and installing MySQL Community Server 8.0.11 CE
DownloadMySQL

mac / system preferences
click MySQL
Make sure MySQL is running

step2.
install MysqlWorkBench
Download_WorkBench

step3.
change mysql_native_password ,
if you don’t change mysql_native_password , workbench will show you error message
authentication plugin caching_sha2_password cannot be loaded

//login to mysql
mysql -u root -p
//change mysql_native_password
ALERT USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY "yourPassword";

step4.
open MySQL Workbench

fill in your password
click the MacMysql
Now login successful.

--

--

Jameskrauser Lee
Jameskrauser Lee

Written by Jameskrauser Lee

For the last few years. i was involved mostly in the development of Automatic Fare collection system for the Chennai Metro. Familiar with C++ and iOS.

No responses yet