1、刪除mysql的命令
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*
2、下載mysql
https://dev.mysql.com/downloads/mysql/5.7.html#downloads
選擇下載
3、安裝mysql
雙擊安裝
選擇繼續(xù)
選擇同意
選擇安裝
輸入密碼，選擇安裝
安裝安裝，彈出對(duì)話框，記住root密碼，選擇OK，安裝成功，選擇關(guān)閉
4、啟動(dòng)mysql
從launchpad中啟動(dòng)偏好設(shè)置
選擇點(diǎn)擊mysql
啟動(dòng)mysql
5、登入mysql
1）從launchpad中啟動(dòng)終端
執(zhí)行sudo su，輸入密碼
使用vi .bash_profile編輯環(huán)境環(huán)境變量
export MYSQL_HOME=/usr/local/mysql/
export PATH=$PATH:$MYSQL_HOME/bin
使用source .bash_profile命令立即生效環(huán)境變量
（2）使用命令登入密碼不對(duì)：
sh-3.2# mysql -uroot -p
Enter password:
ERROR 1045(28000): Access denied for user 'root'@'localhost'(using password: YES)
3）設(shè)置不需要密碼登入
sudo cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
發(fā)現(xiàn)并沒有/usr/local/mysql/support-files/my-small.cnf這個(gè)文件。
我們自己使用vi /ect/my.cnf創(chuàng)建文件 下面是創(chuàng)建的文件內(nèi)容。
#skip-grant-tables將注釋去掉。
[client]
port = 3306
default-character-set=utf8mb4
socket=/tmp/mysql.sock
[mysql]
port = 3306
default-character-set=utf8mb4
socket=/tmp/mysql.sock
[mysqld]
##########################
# summary
##########################
bind-address = 0.0.0.0
port = 3306
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
tmpdir = /tmp
pid-file=/tmp/mysqld.pid
#skip-grant-tables
#skip-networking
explicit_defaults_for_timestamp=1
lower_case_table_names=1
table_open_cache = 8000
##########################
# time out
##########################
connect_timeout = 20
wait_timeout = 86400
##########################
# connection
##########################
max_connections = 2000
max_user_connections = 1900
max_connect_errors = 100000
max_allowed_packet = 1G
##########################
# character set
##########################
character-set-server = utf8mb4
collation-server = utf8mb4_bin
##########################
# log bin
##########################
server-id = 1
log_bin = mysql-bin
# ROW、STATEMENT、MIXED
binlog_format = row
sync_binlog = 1
expire_logs_days = 7
binlog_cache_size = 128m
max_binlog_cache_size = 512m
max_binlog_size = 256M
master_info_repository=TABLE
relay_log_info_repository=TABLE
log_slave_updates=ON
binlog_checksum=none
binlog_ignore_db=mysql
binlog_ignore_db=information_schema
binlog_ignore_db=performation_schema
binlog_ignore_db=sys
##########################
# gtid
##########################
gtid_mode = on
enforce_gtid_consistency = on
##########################
# log relay
##########################
relay_log = mysql-relay-bin
relay_log_purge = on
relay_log_recovery = on
max_relay_log_size = 1G
##########################
# log error
##########################
log_error=/data/mysql/mysqld_error.log
##########################
# log slow
##########################
slow_query_log = on
slow_query_log_file = /data/mysql/mysqld_slow.log
long_query_time = 2
log_queries_not_using_indexes = on
##########################
# log general
##########################
general_log = on
general_log_file = /data/mysql/mysqld_gener.log
##########################
# thread pool
##########################
#thread_handling=pool-of-threads
#thread_handling=one-thread-per-connection
#thread_pool_oversubscribe=8
##########################
# innodb
##########################
innodb_file_per_table=1
innodb_log_file_size=1024M
innodb_log_buffer_size=64M
##########################
# password policy
# after init
##########################
#validate_password_length=4? ? ? ?
#validate_password_mixed_case_count=0
#validate_password_number_count=0
#validate_password_policy=0
#validate_password_special_char_count=0
重啟mysql
通過終端登入mysql
（4）使用sql來修改mysql root密碼
use mysql;
update user? set authentication_string =password("密碼")where user='root';
flush privileges;
quit;
（5）使用 mysql -uroot -p
