在Mac OS环境下安装MySQL服务

                  在Mac OS环境下安装MySQL服务

                                         作者:尹正杰

版权声明:原创作品,谢绝转载!否则将追究法律责任。

  我之前介绍过window环境下安装mysql服务,以及在Linux环境下安装mysql服务,今天我要给大家介绍的是在Mac环境下安装mysql服务。其实安装mysql服务我们也可以像Linux那样,使用brew命令进行安装,但我们此处使用的是绿色方式安装。

 

 

一.下载mysql服务

1>.登录mysql的下载列表

  下载地址:https://dev.mysql.com/downloads/mysql/。如下图所示,点击标红的标签。

在Mac OS环境下安装MySQL服务

 2>.下载DMG版本的mysql安装包

在Mac OS环境下安装MySQL服务

3>.跳过登录直接下载mysql服务即可

在Mac OS环境下安装MySQL服务

二.安装mysql服务

1>.双击运行下载好的安装包,点击继续

在Mac OS环境下安装MySQL服务

2>.阅读软件许可协议后,点击继续

在Mac OS环境下安装MySQL服务

3>.点击安装

在Mac OS环境下安装MySQL服务

4>.记住安装的数据库的初始密码(如下图所示,我这里的初始化密码是:M7Rju)ofMFMb)

在Mac OS环境下安装MySQL服务

5>.安装成功

在Mac OS环境下安装MySQL服务

三.启动mysql服务

1>.进入mysql的系统偏好设置

在Mac OS环境下安装MySQL服务

2>.点击mysql服务

在Mac OS环境下安装MySQL服务

3>.启动mysql服务

在Mac OS环境下安装MySQL服务

4>. 服务启动成功

在Mac OS环境下安装MySQL服务

 

四.修改mysql的默认密码

1>.登录mysql服务器

在Mac OS环境下安装MySQL服务

2>.更改mysql的默认密码

set password for 'root'@'localhost' = PASSWORD('yinzhengjie');

在Mac OS环境下安装MySQL服务

3>.使用修改后的密码登录服务器

在Mac OS环境下安装MySQL服务

五>.授权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 connection id is
Server version: 5.7. MySQL Community Server (GPL) Copyright (c) , , 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>
[mysql>
[mysql>
[mysql>
[mysql> grant all privileges on *.* to 'root'@'172.30.1.%' identified by 'yinzhengjie';
Query OK, rows affected, warning (0.00 sec) [mysql> FLUSH PRIVILEGES;
Query OK, rows affected (0.01 sec) [mysql> quit
Bye
[尹正杰到此一游:~ yinzhengjie$

在Mac OS环境下安装MySQL服务

2>.查看宿主机的IP地址

在Mac OS环境下安装MySQL服务

3>.使用Guest虚拟机登录宿主机

在Mac OS环境下安装MySQL服务

六.安装MySQL8.0.x的区别

1>.MySQL加密方式的选择(之前的安装步骤和上面MySQL5.7的安装方式基本雷同,我这里就省略了~)

在Mac OS环境下安装MySQL服务

2>.自定义root的密码:

在Mac OS环境下安装MySQL服务

3>.安装成功后,点击完成

在Mac OS环境下安装MySQL服务

4>.在MacOS到系统偏好设置进入到MySQL到管理界面

在Mac OS环境下安装MySQL服务

5>.查看MySQL的默认配置

在Mac OS环境下安装MySQL服务

6>.登陆MySQL服务器

在Mac OS环境下安装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 PATH for Python 3.6
PATH="/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 on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.14 MySQL Community Server - GPL Copyright (c) 2000, 2019, 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec) mysql>

8>.创建MySQL到登陆用户

mysql> CREATE USER 'yinzhengjie'@'172.30.1.10%' IDENTIFIED BY 'yinzhengjie';
Query OK, 0 rows affected (0.01 sec) mysql>
mysql> GRANT ALL PRIVILEGES ON *.* TO 'yinzhengjie'@'172.30.1.10%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec) mysql>
[root@node110 ~]# hostname
node110.yinzhengjie.org.cn
[root@node110 ~]#
[root@node110 ~]# hostname -i
172.30.1.110
[root@node110 ~]#
[root@node110 ~]# mysql -h 172.30.1.2 -uyinzhengjie -pyinzhengjie
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1130 (HY000): Host '172.30.1.110' is not allowed to connect to this MySQL server
[root@node110 ~]#
[root@node110 ~]#

使用 “node110.yinzhengjie.org.cn” 节点登陆

[root@node105 ~]# hostname
node105.yinzhengjie.org.cn
[root@node105 ~]#
[root@node105 ~]# hostname -i
172.30.1.105
[root@node105 ~]#
[root@node105 ~]# mysql -h 172.30.1.2 -uyinzhengjie -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 connection id is 14
Server version: 8.0.14 MySQL Community Server - GPL Copyright (c) 2000, 2019, 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec) mysql> quit
Bye
[root@node105 ~]#

使用 “node105.yinzhengjie.org.cn” 节点登陆

上一篇:gcc请不要优化


下一篇:最简单的CRC32源码-逐BYTE法