装置Homebrew

https://brew.sh/

brew -v# 查看 homebrew 是否可用brew doctor

装置mysql 5.7

# 搜寻 mysql 版本brew search mysql# 装置 5.7brew install mysql@5.7# 配置环境变量，如下图红框1echo 'export PATH="/opt/homebrew/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc# 使配置失效source ~/.zshrc# 启动 mysql 服务mysql.server start

mysql 设置明码

mysql装置完是没有配置明码的，MySQL 被配置为默认只容许来自 localhost 的连贯

# 输出装置后，提醒的批改明码的命令mysql_secure_installation# 无奈设置简略明码，减少了明码强度验证插件validate_password ... Failed! Error: Your password does not satisfy the current policy requirements# 查看 验证明码策略mysql> select @@validate_password_policy;+----------------------------+| @@validate_password_policy |+----------------------------+| LOW                        |+----------------------------+# 查看 msyql明码相干的几个全局参数mysql> SHOW VARIABLES LIKE 'validate_password%';+--------------------------------------+-------+| Variable_name                        | Value |+--------------------------------------+-------+| validate_password_check_user_name    | OFF   || validate_password_dictionary_file    |       || validate_password_length             | 8     || validate_password_mixed_case_count   | 1     || validate_password_number_count       | 1     || validate_password_policy             | LOW   || validate_password_special_char_count | 1     |+--------------------------------------+-------+# 批改mysql参数配置mysql> set global validate_password_mixed_case_count=0;mysql> set global validate_password_number_count=0;mysql> set global validate_password_special_char_count=0;mysql> set global validate_password_length=3;# 查看 是否批改胜利mysql> SHOW VARIABLES LIKE 'validate_password%';# 批改明码mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');