安装

  1. 安装 MySQL： brew install mysql

  2. 启动 MySQL: mysql.server start

  3. 检查 MySQL 服务状态： systemctl status mysql.service

  4. 安全设置： mysql_secure_installation, 执行后提示安全策略：

    1
2
3
4
5

    There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file

    根据提示选择密码等级， 设置 Root 密码

创建用户

  1. 创建用户： create user 'herbert_u'@'%' identified by 'herbert_123';

  2. 授权用户：

    1
2

    grant all privileges on retail_db.* to 'herbert_u'@'%';
flush privileges;