【MySQL】mac安装mysql教程

冷不防 2021-09-24 12:38 539阅读 0赞

**mac的mysql地址：**  
地址：[http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.10-osx10.10-x86\_64.dmg][http_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-5.7.10-osx10.10-x86_64.dmg]

**双击安装**  
![在这里插入图片描述][20200712014426517.png]

安装过程中需要注意的是，**MySQL已经默认用户root的密码已经不再是root，而是动态生成的一个临时密码**（如：root@localhost: yltGn\*gPH9t,）。

在安装过程中会出现一个弹窗告诉你动态密码，千万要记住这个或者拷贝下这个密码，这关系着你能不能进入数据库。

**配置环境变量**  
`vi ~/.bash_profile`

JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk1.8.0_251.jdk/Contents/Home
    PATH=$JAVA_HOME/bin:$PATH:.
    CLASSPATH=$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar:.
    export JAVA_HOME
    export PATH
    export CLASSPATH
    
    alias mysql=/usr/local/mysql/bin/mysql
    alias mysqladmin=/usr/local/mysql/bin/mysq

**刷新环境变量**  
`source ~/.bash_profile`  
**启动mysql**  
打开“系统偏好设置”，  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70]  
启动  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 1]  
启动后的界面如下：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 2]  
打开终端输入如下命令：  
`mysql -u root -p`  
输入安装时记下的密码

root登录后，修改密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root123');
    flush privileges; #立即刷新生效

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 3][]  
退出重启MySQL服务

新建用户&赋权限，新建数据库

1、创建hive数据库，字符集是utf8

CREATE DATABASE hive DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

2、创建用户 fuyun

CREATE USER 'fuyun'@'localhost' IDENTIFIED BY 'fuyun123'; #本地登录 CREATE USER 'fuyun'@'%' IDENTIFIED BY 'fuyun123'; #远程登录

3、给用户fuyun赋权限

GRANT ALL PRIVILEGES ON hive.* to 'fuyun'@'localhost' IDENTIFIED BY 'fuyun123'; #赋全部权限 GRANT select,create ON hive.* to 'fuyun'@'localhost' IDENTIFIED BY 'fuyun123'; #赋部分权限
    
    flush privileges; #立即刷新

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 4]

[http_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-5.7.10-osx10.10-x86_64.dmg]: http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.10-osx10.10-x86_64.dmg
[20200712014426517.png]: /images/20210923/dd017675697f47ce97c915503884a224.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70]: /images/20210923/5023ac979df44dcbba93d1e70683eb5f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 1]: /images/20210923/6c4ea1765c644c51bbc7c7ee90d71392.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 2]: /images/20210923/222ff5db5d4e46f7b6f8b148e8bbdd98.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 3]: /images/20210923/e3ab86a3a25043ebb3fe4327a50c34ca.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x6NjM2Mw_size_16_color_FFFFFF_t_70 4]: /images/20210923/5c70fa179b954a3489095f1c3a65a1f8.png