MacOS MySQL安装

1、安装包下载地址MySQL Community Server开源版本适用于个人和小型企业。MySQL Enterprise Edition商业版本提供额外的功能和技术支持。MySQL Cluster分布式数据库系统适用于高可用性和高并发场景。版本8.4.3 LTS2、解压并安装脚本命令# 将安装包拷贝至/usr/local目录sudocp/Users/wang/Downloads/mysql-8.4.3-macos14-x86_64.tar.gz /usr/local/# 创建软链接# 启动mysql服务的时候启动脚本默认路径都是/usr/local/mysql 因此需要创建一个软连接sudoln-s/usr/local/mysql-8.4.3-macos14-x86_64 mysql# 配置环境变量 执行安装脚本需要先配置环境变量sudovim/.zshrcexportPATH/usr/local/mysql/bin:$PATHsource/.zshrc# 执行mysql安装脚本cd/usr/local/mysql/binsudomysqld--initialize--usermysql#注意此步执行之后会产生一个临时的root账户密码打印在日志中需要保存下来# 启动mysql服务# 因为安装的mac版本不支持systemctl工具因此使用mysql预制的启动脚本 脚本在support-files中sudocp/usr/local/mysql/support-files/mysql.server /usr/local/mysql/bin/sudomysql.server start# 安全配置mysql# 会提示设置root密码159874.Lmw 此时需要先输入生成的临时root密码sudomysql_secure_installation执行完mysql安装脚本含临时root密码的打印日志2024-12-18T14:23:08.626936Z0[System][MY-015017][Server]MySQL Server Initialization - start.2024-12-18T14:23:08.631787Z0[System][MY-013169][Server]/usr/local/mysql-8.4.3-macos14-x86_64/bin/mysqld(mysqld8.4.3)initializing of serverinprogress as process24892024-12-18T14:23:08.639054Z0[Warning][MY-010159][Server]Settinglower_case_table_names2becausefilesystemfor/usr/local/mysql-8.4.3-macos14-x86_64/data/ iscaseinsensitive2024-12-18T14:23:08.654968Z1[System][MY-013576][InnoDB]InnoDB initialization has started.2024-12-18T14:23:08.827932Z1[System][MY-013577][InnoDB]InnoDB initialization has ended.2024-12-18T14:23:10.189963Z6[Note][MY-010454][Server]A temporary password is generatedforrootlocalhost: iwrOl,9!oq2024-12-18T14:23:11.065246Z0[System][MY-013172][Server]Received SHUTDOWN from uservia user signal. Shutting down mysqld(Version:8.4.3).2024-12-18T14:23:12.034083Z0[System][MY-015018][Server]MySQL Server Initialization - end.mysql服务启动成功日志wang192 bin %sudomysql.server start Starting MySQL .Logging to/usr/local/mysql/data/192.168.0.103.err..SUCCESS!