Mac系统上安装Mysql环境

最新推荐文章于 2023-09-20 00:10:54 发布
最新推荐文章于 2023-09-20 00:10:54 发布
阅读量242 收藏
点赞数
分类专栏： mac 文章标签： mysql macos 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u012236028/article/details/129180105
版权

Mac系统下mysql卸载

假如自己电脑中已经安装mysql想完全卸载mysql时请看：
在这里插入图片描述
mysql完全删除

以下是mysql的默认安装的安装路径

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
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.*

还需要细致检查一下一下路径中是否存在mysql的相关内容

检查/usr/local/Cellar目录是否有mysql文件，有的话删除。
检查/usr/local/var 里的mysql文件，有的话删除。
检查/tmp 里的mysql.sock、mysql.sock.lock、 my.cnf文件，有的话删除。
err文件以及pid文件都是在/usr/local/var/mysql中，有的话删除。
brew安装的安装包存储在/usr/local/Library/Cache/Homebrew，有的话删除。
执行brew cleanup。

删除mysql相关信息
在这里插入图片描述
更新brew
在这里插入图片描述
准备安装mysql
执行下载命令

brew install mysql@8.0

安装结果

chenfubao@chenfubaodeMacBook-Pro opt % brew install mysql@8.0   
mysql 8.0.27_1 is already installed but outdated (so it will be upgraded).
==> Fetching dependencies for mysql: icu4c, ca-certificates, openssl@1.1, libcbor, libfido2, lz4, protobuf, zlib, xz and zstd
==> Fetching icu4c
==> Downloading https://ghcr.io/v2/homebrew/core/icu4c/manifests/72.1
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/icu4c/blobs/sha256:899d9a8e7ab10896afad66a3d3c9053a5a10ae290b23197b1210
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:899d9a8e7ab10896afad66a3d3c9053a5a1
######################################################################## 100.0%
==> Fetching ca-certificates
==> Downloading https://ghcr.io/v2/homebrew/core/ca-certificates/manifests/2023-01-10
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/ca-certificates/blobs/sha256:11fe9d0a98a2ac454fa1db95762a697c3340f46560
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:11fe9d0a98a2ac454fa1db95762a697c334
######################################################################## 100.0%
==> Fetching openssl@1.1
==> Downloading https://ghcr.io/v2/homebrew/core/openssl/1.1/manifests/1.1.1t
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/openssl/1.1/blobs/sha256:c357ccf7ece01905099a0cde58a2bbfb14141edb3aafed
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:c357ccf7ece01905099a0cde58a2bbfb141
######################################################################## 100.0%
==> Fetching libcbor
==> Downloading https://ghcr.io/v2/homebrew/core/libcbor/manifests/0.10.2
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/libcbor/blobs/sha256:b748fb213e434fe650e0964d72f84275a5aac3620b336778db
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:b748fb213e434fe650e0964d72f84275a5a
######################################################################## 100.0%
==> Fetching libfido2
==> Downloading https://ghcr.io/v2/homebrew/core/libfido2/manifests/1.13.0
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/libfido2/blobs/sha256:6bd137a882ad45647044ba1cc6f4c9ac582a2d0383e7ed7d0
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:6bd137a882ad45647044ba1cc6f4c9ac582
######################################################################## 100.0%
==> Fetching lz4
==> Downloading https://ghcr.io/v2/homebrew/core/lz4/manifests/1.9.4
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/lz4/blobs/sha256:aafb93487e108d302d060265898e4eaa82f5c806ff36dec50871db
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:aafb93487e108d302d060265898e4eaa82f
######################################################################## 100.0%
==> Fetching protobuf
==> Downloading https://ghcr.io/v2/homebrew/core/protobuf/manifests/21.12-1
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/protobuf/blobs/sha256:d64e264d07b331a8043c35d608de0871e9df4f9a9b208d5d8
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:d64e264d07b331a8043c35d608de0871e9d
######################################################################## 100.0%
==> Fetching zlib
==> Downloading https://ghcr.io/v2/homebrew/core/zlib/manifests/1.2.13
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/zlib/blobs/sha256:495733577a835472554be619e26ad09fa62684d1d1eba3efae5a8
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:495733577a835472554be619e26ad09fa62
######################################################################## 100.0%
==> Fetching xz
==> Downloading https://ghcr.io/v2/homebrew/core/xz/manifests/5.4.1
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/xz/blobs/sha256:55e32fb63afac31a9d21bef5e8e310f2ca0629f055d1a72cb5f14d7
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:55e32fb63afac31a9d21bef5e8e310f2ca0
######################################################################## 100.0%
==> Fetching zstd
==> Downloading https://ghcr.io/v2/homebrew/core/zstd/manifests/1.5.4
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/zstd/blobs/sha256:0e425c420f3a24a3b5e1cd932e01855b1945465467c0cf0a5f25e
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:0e425c420f3a24a3b5e1cd932e01855b194
######################################################################## 100.0%
==> Fetching mysql
==> Downloading https://ghcr.io/v2/homebrew/core/mysql/manifests/8.0.32
######################################################################## 100.0%
==> Downloading https://ghcr.io/v2/homebrew/core/mysql/blobs/sha256:8678cc4dc2a4881e0b3fbba64ffece73f153254966ed7ae8816e
==> Downloading from https://pkg-containers.githubusercontent.com/ghcr1/blobs/sha256:8678cc4dc2a4881e0b3fbba64ffece73f15
######################################################################## 100.0%
==> Upgrading mysql@8.0
  -> 8.0.32 

==> Installing dependencies for mysql: icu4c, ca-certificates, openssl@1.1, libcbor, libfido2, lz4, protobuf, zlib, xz and zstd
==> Installing mysql dependency: icu4c
==> Pouring icu4c--72.1.big_sur.bottle.tar.gz
🍺  /usr/local/Cellar/icu4c/72.1: 263 files, 78MB
==> Installing mysql dependency: ca-certificates
==> Pouring ca-certificates--2023-01-10.all.bottle.tar.gz
==> Downloading https://formulae.brew.sh/api/cask.json
######################################################################## 100.0%
==> Regenerating CA certificate bundle from keychain, this may take a while...
🍺  /usr/local/Cellar/ca-certificates/2023-01-10: 3 files, 216.9KB
==> Installing mysql dependency: openssl@1.1
==> Pouring openssl@1.1--1.1.1t.big_sur.bottle.tar.gz
==> Downloading https://formulae.brew.sh/api/formula.json
######################################################################## 100.0%
🍺  /usr/local/Cellar/openssl@1.1/1.1.1t: 8,101 files, 18.5MB
==> Installing mysql dependency: libcbor
==> Pouring libcbor--0.10.2.big_sur.bottle.tar.gz
🍺  /usr/local/Cellar/libcbor/0.10.2: 31 files, 175.4KB
==> Installing mysql dependency: libfido2
==> Pouring libfido2--1.13.0.big_sur.bottle.tar.gz
🍺  /usr/local/Cellar/libfido2/1.13.0: 547 files, 1.2MB
==> Installing mysql dependency: lz4
==> Pouring lz4--1.9.4.big_sur.bottle.tar.gz
🍺  /usr/local/Cellar/lz4/1.9.4: 22 files, 718.8KB
==> Installing mysql dependency: protobuf
==> Pouring protobuf--21.12.big_sur.bottle.1.tar.gz
🍺  /usr/local/Cellar/protobuf/21.12: 285 files, 10.2MB
==> Installing mysql dependency: zlib
==> Pouring zlib--1.2.13.big_sur.bottle.tar.gz
🍺  /usr/local/Cellar/zlib/1.2.13: 13 files, 425KB
==> Installing mysql dependency: xz
==> Pouring xz--5.4.1.big_sur.bottle.tar.gz
🍺  /usr/local/Cellar/xz/5.4.1: 95 files, 1.6MB
==> Installing mysql dependency: zstd
==> Pouring zstd--1.5.4.big_sur.bottle.tar.gz
🍺  /usr/local/Cellar/zstd/1.5.4: 31 files, 2.5MB
==> Installing mysql
==> Pouring mysql--8.0.32.big_sur.bottle.tar.gz
==> /usr/local/Cellar/mysql/8.0.32/bin/mysqld --initialize-insecure --user=chenfubao --basedir=/usr/local/Cellar/mysql/8
Last 15 lines from /Users/chenfubao/Library/Logs/Homebrew/mysql/post_install.01.mysqld:
2023-02-23 15:38:28 +0800

/usr/local/Cellar/mysql/8.0.32/bin/mysqld
--initialize-insecure
--user=chenfubao
--basedir=/usr/local/Cellar/mysql/8.0.32
--datadir=/usr/local/var/mysql
--tmpdir=/tmp

2023-02-23T07:38:33.899197Z 0 [System] [MY-013169] [Server] /usr/local/Cellar/mysql/8.0.32/bin/mysqld (mysqld 8.0.32) initializing of server in progress as process 17528
2023-02-23T07:38:33.900625Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-02-23T07:38:33.901388Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2023-02-23T07:38:33.901397Z 0 [ERROR] [MY-013236] [Server] The designated data directory /usr/local/var/mysql/ is unusable. You can remove all files that the server added to it.
2023-02-23T07:38:33.901485Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-02-23T07:38:33.901688Z 0 [System] [MY-010910] [Server] /usr/local/Cellar/mysql/8.0.32/bin/mysqld: Shutdown complete (mysqld 8.0.32)  Homebrew.
Warning: The post-install step did not complete successfully
You can try again using:
  brew postinstall mysql
==> Caveats
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -u root

To start mysql now and restart at login:
  brew services start mysql
==> Summary
🍺  /usr/local/Cellar/mysql/8.0.32: 317 files, 298.8MB
==> Running `brew cleanup mysql`...
Disable this behaviour by setting HOMEBREW_NO_INSTALL_CLEANUP.
Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).
Removing: /usr/local/Cellar/mysql/8.0.27_1... (304 files, 294MB)
==> Caveats
==> mysql
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -u root

To start mysql now and restart at login:
  brew services start mysql

启动mysql – 如果报错

chenfubao@chenfubaodeMacBook-Pro /etc % sudo mysql.server start
Starting MySQL
.Logging to '/var/log/mysql/error.log'.
 ERROR! The server quit without updating PID file (/usr/local/var/mysql/chenfubaodeMacBook-Pro.local.pid).
chenfubao@chenfubaodeMacBook-Pro /etc % cd /var/log/mysql/

mysql 启动报错解决

cd /usr/local/var
sudo rm -rf mysql
mysqld --initialize-insecure

再次启动mysql – 启动成功

chenfubao@chenfubaodeMacBook-Pro mysql % sudo mysql.server start
Starting MySQL
 SUCCESS!
我爱罗lmt
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
MAC 系统安装java并配置环境变量
01-04
MAC 配置 java 环境变量 1.列出所有Java版本信息 /usr/libexec/java_home -V 2.修改.bash_profile文件 cd ~ touch .bash_profile vi .bash_profile 3.配置JDK环境变量内容，并输入wq保存 export JAVA_HOME=/...
mac报错Symbol not found以及icu4c报错
weixin_43091337的博客
08-11 651
我是先 rm -rf /usr/local/Cellar/icu4c。再 brew uninstall icu4c，报错 icu4c。环境：mac php7.3。再安装 icu4c，报错。
1. MacOs Dart环境安装
大脑和心脏都要跳动的97
02-23 1706
前置材料： 需要安装dart的Mac设备 一颗会用搜索引擎的聪明大脑。
【MAC】brew privoxy安装和配置
小慌慌的博客
06-13 1788
【MAC】brew privoxy安装和配置 curl: (22) The requested URL returned error: 502 Bad Gateway curl: (7) Failed to connect to raw.githubusercontent.com port 443: Operation timed out
Mac 上如何安装Mysql？ 如何配置 Mysql？以及如何开启并使用MySQL
最新发布
hirezy
09-20 2万+
有许多开发的小伙伴，使用的是mac，那么在mac上如何安装，配置Mysql，以及使用Mysql了，今天来一个系统的教程。
Mac如何配置MySQL环境
Derrrrrd的博客
06-30 1341
Mac如何配置MySQL环境
Mac下安装mysql5.7 完整步骤（图文详解）
12-16
最近使用Mac系统，准备搭建一套本地web服务器环境。因为Mac系统自带PHP和apach，但是没有自带mysql，所以要手动去安装mysql，本次安装mysql最新版5.7.17。 1.官网下载 MySQL v5.7官方正式版下载地址：//...
Mac 下 MySQL5.7.22的安装过程
12-16
1.使用安装包安装mysql（网上下载实在是太慢了，需要...将mysql加入系统环境变量  进入/usr/local/mysql/bin,查看此目录下是否有mysql 执行vim ~/.bash_profile  在该文件中添加mysql/bin的目录，见pic7：  PA
mysql5.7.20 安装配置方法图文教程(mac)
12-16
mysql5.7.20 安装配置方法图文教程，为大家分享 1.官网：https://dev.mysql.com/downloads/mysql/下载 强烈建议选择dmg文件下载，下载tar版本解压之后需要将文件夹移至默认安装位置/usr/local，还需要各种配置实在...
Mac OS下配置PHP＋MySql环境
10-24
本文详细介绍了在mac OS系统下安装配置PHP+MySql环境的详细步鄹，十分的全面，这里推荐给有相同需求的小伙伴们。
Mac搭建MySQL环境
Chengf_的博客
05-16 425
1.下载 用dmg的方式安装。Download MySQL Community Server 或者常规方式，打开官网 : http://www.mysql.com/downloads/ 进入, 点击下方的DOWNLOADS : MySQL Community Server 往下拉，看到download，点击下载 接着, 会跳转到如下页面, 你只需要选择不登录,直接下载即可 2...
Mac系统homebrew安装MySQL等环境
u013488276的博客
05-28 6340
MacOS 安装 Homebrew，Mac系统利用homebrew安装MySQL、MariaDB、Redis、RabbitMQ、Node.js等环境；
Mac下通过brew安装mysql出错记录
m0_71750103的博客
06-11 889
mac 安装 mysql
home brew 安装mysql_无法使用brew安装mysql来安装MYSQL
weixin_33374585的博客
01-19 319
我在使用自制软件安装MYSQL时遇到问题我的系统信息如下。新鲜安装MAC OSX 10.7.4RUBY 1.9.3-p125XCODE 4.3.3当我发出命令> brew install mysql时我收到以下错误DBSVR1:~ icareadmin$ brew install mysql==> Installing mysql dependency: cmake==> Dow...
Mac环境配置MySQL（详细）
热门推荐
互联网小队
03-21 4万+
非常详细
mac下开发环境的常见问题解决方法
固本培元的专栏
02-08 1万+
brew的库版本冲突： I have a few kegs of the same package in /usr/local/Cellar/libfoo like /usr/local/Cellar/libfoo/1.0.1, /usr/local/Cellar/libfoo/HEAD and /usr/local/Cellar/libfoo/mycopy How can I b
mysql 安装_mysql 安装
weixin_39880895的博客
11-24 118
第一种 下载安装包https://dev.mysql.com/downloads/mysql/跳过登录会提示是否鉴权实际安装第二种 执行安装命令brewinstallmysql提示权限错误Lastlogin:SatAug1517:18:06onttys000~%brewinstallmysqlUpdatingHomebrew...==>Auto-upd...
mac设置brew安装的服务开机自启动(以mysql为例)
tinysakura的博客
10-01 7207
mac brew 安装的mysql开机自启动 1、用brew安装的可以通过以下语句查看安装目录： brew –prefix mysql 2、从你MySQL的安装目录下找到homebrew.mxcl.mysql.plist这个文件，然后复制到～/Library/LaunchAgents目录下，然后在终端执行以下语句即可： launchctl load -w ~/Library/LaunchAgen...
Mac下使用homebrew安装配置mysql
cheng649090216的博客
02-03 3万+
步骤： 一、安装homebrew 二、安装mysql 三、配置自启动 四、修改mysql密码 五、创建my.cnf配置文件 一、安装homebrew homebrew是macOS缺失的软件包管理器，譬如可以下载mysql、maven等等。 安装方法： /usr/bin/ruby -e "$(curl -fsSL https://raw.githubuserconten
mac系统如何判断是否安装了mysql环境
06-09
您可以通过以下命令来检查是否已经安装了MySQL环境： ``` mysql --version ``` 如果您已经安装了MySQL，将会显示MySQL的版本信息。如果显示“command not found”（命令未找到）的错误提示，那么说明您还没有安装MySQL环境。 您也可以通过以下命令来检查MySQL的安装路径： ``` which mysql ``` 如果MySQL已经安装，则会显示MySQL可执行文件的安装路径，否则将会显示“mysql not found”（未找到mysql）的错误提示。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值