MySQL 8 默認關閉了?mysql_native_password， 需要手動開啟。但是MacOS各種坑，氣死個人。
mysql8 內置了?mysql_native_password ，只是沒有開啟。 驗證方式是執行?show plugins; ，返回的結果中應該有?mysql_native_password ，并且是 disabled 狀態。
系統設置，往下拉，找到Mysql，正常情況下你應該是小綠點，active狀態。
進入“Configuration”標簽頁，默認 Configuration file 是沒有勾選的，是空的。請勾選，并配置為 /etc/my.cnf。 并點擊“Apply”，并確定。
當然，你可能聽說 Mysql 有很多配置文件， 也可以配置到~/.my.cnf。但這是錯誤的。理論上可以，但實際上不行，為啥我也不知道，我估計又是MacOS的詭異權限問題。
編輯?/etc/my.cnf 文件是需要root的，切換到root用戶的方式，是執行命令 “sudo su - root”.
網上一堆人說，要找 my-default.cnf 文件，它是默認模板文件，復制一下，改一下就行了。扯淡的是，MacOS下根本沒這個文件。這里我直接給出文件內容，你直接復制粘貼到?/etc/my.cnf 即可。
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
default-character-set=utf8
#password = your_password
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
# default_authentication_plugin=mysql_native_password
mysql_native_password=ON
character-set-server=utf8
init_connect='SET NAMES utf8'
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking # Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin # binary logging format - mixed recommended
binlog_format=mixed # required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1 # Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin # Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/data
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/data
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50 [mysqldump]
quick
max_allowed_packet = 16M [mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
default-character-set=utf8 [myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M [mysqlhotcopy]
interactive-timeout
然后root用戶下，執行 chmod 777 /etc/my.cnf
接下來有一些高端操作，不解釋，跟著做就好。
先找到mysql根目錄，你可以通過 執行 which mysql 命令獲取，也可以看這里 Error Log的目錄，例如對于?/usr/local/mysql/data/mysqld.local.err ，它的實際mysql根目錄是?/usr/local/mysql/bin。
在mysql根目錄下，執行：
# 均在 root 用戶下執行mv /usr/local/mysql/bin/mysqld /usr/local/mysql/bin/mysqld.bak# 這個文件空的就可以，vim 之后直接 :wq
vim /usr/local/mysql/bin/mylog.tmp.txtchmod 777 /usr/local/mysql/bin/mylog.tmp.txtvim /usr/local/mysql/bin/mysqld/usr/local/mysql/bin/mysqld 內容：
#!/bin/bashecho "Input arguments: $@"echo "Input arguments: $@" >> /usr/local/mysql/bin/mylog.tmp.txt/usr/local/mysql/bin/mysqld.bak "$@" --mysql-native-password=ON這樣就配置完了，需要重啟mysql服務（每次啟動都要輸管理員密碼，確實很麻煩）。經過上述的修改，啟動狀態就無法在這里看到了，會永遠都是紅點。那如何驗證是否啟動成功呢？可以執行：
ps -ef | grep mysql? ?看有沒有 mysqld.bak + 一大串參數 的進程，如果有就是成功了。沒有就是失敗了。
失敗日志可以執行??tail -f /usr/local/mysql/data/mysqld.local.err? 來查看
命令執行情況可以執行?tail mylog.tmp.txt? 查看，每次執行命令都會記錄下來。如果過幾秒就多一條命令，說明服務在不斷重啟。
正常情況下，應該不會報錯。你通過?ps -ef | grep mysql? 看到相關進程，就可以嘗試連接一下數據庫測試了，執行?show plugins; 應該能看到?mysql_native_password 是 active 狀態
那么如何重啟mysql服務呢？因為系統設置里一直都是紅點，根本沒有stop按鈕，所以你要通過?ps -ef | grep mysql? 查看進程號，直接kill掉。? ?然后再從系統設置里再啟動一次，完成重啟。
?
上面整個操作的原理，就是替換原本的?mysqld 文件，改成我們自己的shell文件，我們的shell文件再調用原本的mysqld文件，這樣我們就能在中間加參數，把?--mysql-native-password=ON 加上去。
