在 Mac 上安装使用 MySQL 数据库,通过 MysqlWorkBench 操作

说明

在 Mac 上安装运行 Mysql 数据库,方便本地搭建开发环境,本地调试。

安装

注意默认的mysql的版本比较高是8.0,当前(2018-12-31 17:31:19)有一些数据库工具还不支持mysql8.0,可以安装mysql5.7:

brew install  [email protected]
brew services start [email protected]

安装mysql和相应的命令行、管理、设计工具。

安装mysql server:

$ brew install 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 -uroot

To have launchd start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  mysql.server start

默认没有root密码,启动后可以直接mysql -uroot登陆:

启动mysql server:

  brew services start mysql

安装mysql命令行工具:

brew install mysql-client 
echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.bash_profile
source  ~/.bash_profile

然后就可以直接登陆mac本地的mysql:

lijiaos-mbp:~ lijiao$ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.13 Homebrew

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

安装有图形界面的数据库管理工具:

brew cask install mysqlworkbench sequel-pro

mac上安装的mysql的配置文件

[email protected]为例,查看正在运行的服务:

lijiaos-mbp:~ lijiao$ brew services list
Name      Status  User   Plist
[email protected] started lijiao /Users/lijiao/Library/LaunchAgents/[email protected]

打开文件Plist一栏中的文件,就可以看到mysql的配置:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
  <key>KeepAlive</key>
  <true/>
  <key>Label</key>
  <string>[email protected]</string>
  <key>ProgramArguments</key>
  <array>
    <string>/usr/local/opt/[email protected]/bin/mysqld_safe</string>
    <string>--datadir=/usr/local/var/mysql</string>
  </array>
  <key>RunAtLoad</key>
  <true/>
  <key>WorkingDirectory</key>
  <string>/usr/local/var/mysql</string>
</dict>
</plist>

问题

如果安装的是mysql 8.0,在查看数据库的时候可能会遇到下面的错误:

ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

在shell上执行下面的命令可解决:

mysql_upgrade -u root 

参考

  1. mysql升级8.0后遇到的坑

作者微信

推荐阅读

Copyright @2011-2019 All rights reserved. 转载请添加原文连接,合作请加微信lijiaocn或者发送邮件: [email protected],备注网站合作

友情链接:  李佶澳的博客  小鸟笔记  软件手册  编程手册  运营手册  爱马影视  网络课程  奇技淫巧  课程文档  精选文章  发现知识星球  百度搜索 谷歌搜索