mac通过brew方式安装mysql5.7

try_bool

已于 2024-01-12 22:25:51 修改

阅读量2.6k

点赞数

分类专栏： PHP开发相关的环境与工具文章标签： mysql 数据库

于 2022-05-30 15:19:05 首次发布

本文链接：https://blog.youkuaiyun.com/cai6595470/article/details/125046582

版权

PHP开发相关的环境与工具专栏收录该内容

10 篇文章

订阅专栏

1、查询mysql包

brew search mysql

2、安装msyql5.7(上一步确认是否有这个包名称)

brew install mysql@5.7

等一段时间后，安装成功后显示

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 -uroot

mysql@5.7 is keg-only, which means it was not symlinked into /usr/local,
because this is an alternate version of another formula.

If you need to have mysql@5.7 first in your PATH, run:
  echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> /Users/boolean/.bash_profile

For compilers to find mysql@5.7 you may need to set:
  export LDFLAGS="-L/usr/local/opt/mysql@5.7/lib"
  export CPPFLAGS="-I/usr/local/opt/mysql@5.7/include"

For pkg-config to find mysql@5.7 you may need to set:
  export PKG_CONFIG_PATH="/usr/local/opt/mysql@5.7/lib/pkgconfig"


To restart mysql@5.7 after an upgrade:
  brew services restart mysql@5.7
Or, if you don't want/need a background service you can just run:
  /usr/local/opt/mysql@5.7/bin/mysqld_safe --datadir=/usr/local/var/mysql
==> Summary
🍺  /usr/local/Cellar/mysql@5.7/5.7.37: 320 files, 234.2MB
==> Running `brew cleanup mysql@5.7`...
Disable this behaviour by setting HOMEBREW_NO_INSTALL_CLEANUP.
Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).

3、启动mysql

/usr/local/opt/mysql@5.7/bin/mysql.server start

4、登录mysql

通过命令行登录mysql

 /usr/local/opt/mysql@5.7/bin/mysql -uroot -p

通过navacat软件登录mysql