在Mac OS环境下安装MySQL服务
作者：尹正杰
版权声明：原创作品，谢绝转载！否则将追究法律责任。
我之前介绍过window环境下安装mysql服务，以及在Linux环境下安装mysql服务，今天我要给大家介绍的是在Mac环境下安装mysql服务。其实安装mysql服务我们也可以像Linux那样，使用brew命令进行安装，但我们此处使用的是绿色方式安装。
一.下载mysql服务
1>.登录mysql的下载列表
2>.下载DMG版本的mysql安装包
3>.跳过登录直接下载mysql服务即可
二.安装mysql服务
1>.双击运行下载好的安装包，点击继续
2>.阅读软件许可协议后，点击继续
3>.点击安装
4>.记住安装的数据库的初始密码(如下图所示，我这里的初始化密码是：M7Rju)ofMFMb)
5>.安装成功
三.启动mysql服务
1>.进入mysql的系统偏好设置
2>.点击mysql服务
3>.启动mysql服务
4>. 服务启动成功
四.修改mysql的默认密码
1>.登录mysql服务器
2>.更改mysql的默认密码
set password for 'root'@'localhost' = PASSWORD('yinzhengjie');
3>.使用修改后的密码登录服务器
五>.授权mysql远程主机登录
1>.授权只运行的主机
[尹正杰到此一游:~ yinzhengjie$ mysql -u root -pyinzhengjie
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connectionid is 35Server version:5.7.24MySQL Community Server (GPL)
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 clearthe current input statement.
[mysql>[mysql>[mysql>[mysql>[mysql> grant all privileges on *.* to 'root'@'172.30.1.%' identified by 'yinzhengjie';
Query OK,0 rows affected, 1 warning (0.00sec)
[mysql>FLUSH PRIVILEGES;
Query OK,0 rows affected (0.01sec)
[mysql>quit
Bye
[尹正杰到此一游:~ yinzhengjie$
2>.查看宿主机的IP地址
3>.使用Guest虚拟机登录宿主机
六.安装MySQL8.0.x的区别
1>.MySQL加密方式的选择(之前的安装步骤和上面MySQL5.7的安装方式基本雷同，我这里就省略了～)
2>.自定义root的密码：
3>.安装成功后，点击完成
4>.在MacOS到系统偏好设置进入到MySQL到管理界面
5>.查看MySQL的默认配置
6>.登陆MySQL服务器
7>.将MySQL的安装路径手动添加到环境变量中
bogon:~ yinzhengjie$ vi ~/.bash_profile
bogon:~yinzhengjie$
bogon:~ yinzhengjie$ source ~/.bash_profile
bogon:~yinzhengjie$
bogon:~ yinzhengjie$ cat ~/.bash_profile |grep PATH
# Setting PATHfor Python 3.6PATH="/Library/Frameworks/Python.framework/Versions/3.6/bin:${PATH}:/usr/local/mysql/bin"
export PATH
bogon:~yinzhengjie$
bogon:~ yinzhengjie$ mysql -uroot -pyinzhengjie
mysql:[Warning] Using a password onthe command line interface can be insecure.
Welcometo the MySQL monitor. Commands end with ; or\g.
Your MySQL connection idis 12Server version:8.0.14 MySQL Community Server -GPL
Copyright (c)2000, 2019, Oracle and/or its affiliates. Allrights reserved.
Oracleis a registered trademark of Oracle Corporation and/orits
affiliates. Other names may be trademarksoftheir respective
owners.
Type'help;' or '\h' for help. Type '\c' to clear the currentinput statement.
mysql>show databases;+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00sec)
mysql>
8>.创建MySQL到登陆用户
mysql> CREATE USER 'yinzhengjie'@'172.30.1.10%' IDENTIFIED BY 'yinzhengjie';
Query OK,0 rows affected (0.01sec)
mysql>mysql> GRANT ALL PRIVILEGES ON *.* TO 'yinzhengjie'@'172.30.1.10%' WITH GRANT OPTION;
Query OK,0 rows affected (0.00sec)
mysql>
[root@node110 ~]# hostname
node110.yinzhengjie.org.cn[root@node110 ~]#[root@node110 ~]# hostname -i172.30.1.110
[root@node110 ~]#[root@node110 ~]# mysql -h 172.30.1.2 -uyinzhengjie -pyinzhengjie
mysql:[Warning] Using a password onthe command line interface can be insecure.
ERROR1130 (HY000): Host '172.30.1.110' is not allowed to connect tothis MySQL server[root@node110 ~]#[root@node110 ~]#
使用 “node110.yinzhengjie.org.cn” 节点登陆
[root@node105 ~]# hostname
node105.yinzhengjie.org.cn[root@node105 ~]#[root@node105 ~]# hostname -i172.30.1.105
[root@node105 ~]#[root@node105 ~]# mysql -h 172.30.1.2 -uyinzhengjie -pyinzhengjie
mysql:[Warning] Using a password onthe command line interface can be insecure.
Welcometo the MySQL monitor. Commands end with ; or\g.
Your MySQL connection idis 14Server version:8.0.14 MySQL Community Server -GPL
Copyright (c)2000, 2019, Oracle and/or its affiliates. Allrights reserved.
Oracleis a registered trademark of Oracle Corporation and/orits
affiliates. Other names may be trademarksoftheir respective
owners.
Type'help;' or '\h' for help. Type '\c' to clear the currentinput statement.
mysql>show databases;+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00sec)
mysql>quit
Bye[root@node105 ~]#
使用 “node105.yinzhengjie.org.cn” 节点登陆