Macos下安装MySQL简明教程

灰太狼 2022-05-14 19:46 526阅读 0赞

## 环境介绍 ##

Macos Jave 10.14. MySQL 5.7

## 基于Brew安装 ##

> brew install mysql@5.7

运行结果如下：

Updating Homebrew...
    ==> Downloading https://homebrew.bintray.com/bottles/mysql@5.7-5.7.24.mojave.bottle.tar.gz
    ######################################################################## 100.0%
    ==> Pouring mysql@5.7-5.7.24.mojave.bottle.tar.gz
    ==> /usr/local/Cellar/mysql@5.7/5.7.24/bin/mysqld --initialize-insecure --user=chenjunfeng1 --basedir=/usr/local/Cellar/mysql@5.7/5.7.24 --datadir=/usr/local/var/mysql --tmpdir=/tmp
    ==> 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 -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"' >> ~/.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 have launchd start mysql@5.7 now and restart at login:
      brew services start mysql@5.7
    Or, if you don't want/need a background service you can just run:
      /usr/local/opt/mysql@5.7/bin/mysql.server start
    ==> Summary
    ?  /usr/local/Cellar/mysql@5.7/5.7.24: 317 files, 234.3MB

查看当前MySQL的安装情况

> brew info mysql@5.7

命令的输出结果如下：

mysql@5.7: stable 5.7.24 (bottled) [keg-only]
    Open source relational database management system
    https://dev.mysql.com/doc/refman/5.7/en/
    /usr/local/Cellar/mysql@5.7/5.7.24 (317 files, 234.3MB)
      Poured from bottle on 2018-10-29 at 09:50:32
    From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql@5.7.rb
    ==> Dependencies
    Build: cmake ✘
    Required: openssl ✔
    ==> Requirements
    Required: macOS >= 10.7 ✔
    ==> Options
    --with-embedded
    	Build the embedded server
    --with-local-infile
    	Build with local infile loading support
    --with-memcached
    	Build with InnoDB Memcached plugin
    ==> 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 -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"' >> ~/.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 have launchd start mysql@5.7 now and restart at login:
      brew services start mysql@5.7
    Or, if you don't want/need a background service you can just run:
      /usr/local/opt/mysql@5.7/bin/mysql.server start
    ==> Analytics
    install: 21,701 (30 days), 61,998 (90 days), 93,106 (365 days)
    install_on_request: 21,647 (30 days), 61,858 (90 days), 92,927 (365 days)
    build_error: 0 (30 days)

## MySQL安装Brew Services ##

安装brew services

> brew tap homebrew/services  
> 命令输出结果为：

Updating Homebrew...
    ==> Tapping homebrew/services
    Cloning into '/usr/local/Homebrew/Library/Taps/homebrew/homebrew-services'...
    remote: Enumerating objects: 14, done.
    remote: Counting objects: 100% (14/14), done.
    remote: Compressing objects: 100% (10/10), done.
    remote: Total 14 (delta 0), reused 9 (delta 0), pack-reused 0
    Unpacking objects: 100% (14/14), done.
    Tapped 1 command (44 files, 58.6KB).
    hostmachine:~ forkusername$ brew services start mysql@5.7
    ==> Successfully started `mysql@5.7` (label: homebrew.mxcl.mysql@5.7)

启动MySQL

> brew services start mysql@5.7  
> 启动过程信息如下：

==> Successfully started `mysql@5.7` (label: homebrew.mxcl.mysql@5.7)

查看启动的service list

> brew services list  
> 查看服务的列表结果输出:

Name      Status  User         Plist
    emacs     stopped              
    mysql@5.7 started chenjunfeng1 /Users/username/Library/LaunchAgents/homebrew.mxcl.mysql@5.7.plist

将当前的MySQL强制指向5.7

> brew link mysql@5.7 --force

信息输出如下：

Linking /usr/local/Cellar/mysql@5.7/5.7.24... 87 symlinks created
    
    If you need to have this software first in your PATH instead consider running:
      echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile

检查当前MySQL的版本

> mysql -V

版本信息输出如下：

mysql  Ver 14.14 Distrib 5.7.24, for osx10.14 (x86_64) using  EditLine wrapper

## 配置MySQL ##

设置root密码

> mysqladmin -u root password ‘password’

输出结果信息：

mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

登陆MySQL，创建表

> mysql -u root -p ‘password’  
> show databases;  
> create database ‘db\_name’;  
> use db\_name;

## 总结 ##

在Macos下，主要是使用brew来进行系统的配置和管理的。

## Reference ##

1.  [https://gist.github.com/operatino/392614486ce4421063b9dece4dfe6c21][https_gist.github.com_operatino_392614486ce4421063b9dece4dfe6c21]

[https_gist.github.com_operatino_392614486ce4421063b9dece4dfe6c21]: https://gist.github.com/operatino/392614486ce4421063b9dece4dfe6c21