Mac安装mysql数据库【亲测有用】

1. 下载mysql for mac: https://dev.mysql.com/downloads/mysql/

2. 双击mysql-5.7.17-macos10.12-x86_64.dmg进行解压, 双击mysql-5.7.17-macos10.12-x86_64.pkg进行安装

3. Continue -> Continue, Agree -> Install -> 输入管理员密码

4. 记录下来弹窗中的密码

5. 进入系统偏好设置, 找到mysql, 启动服务

6. 将mysql的命令添加到系统中

(1).进入/usr/local/mysql/bin,查看此目录下是否有mysql
(2).执行vim ~/.bash_profile
    在该文件中添加mysql/bin的目录
    PATH=$PATH:/usr/local/mysql/bin
添加完成后，按esc，然后输入wq保存。
(3).最后在命令行输入source ~/.bash_profile

7. 通过mysql -uroot -p登录mysql, 输入之前保存的密码

8. 重置mysql初始密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');

9.打开终端，查看MySQL是否存

执行语句为： ps aux | grep mysql

10.执行命令切换到这个目录底下，然后使用ls命令查看，命令如下：

执行语句为：cd /usr/local/mysql

执行语句为：ls

LICENSE data keyring share

README docs lib support-files

bin include man

11.切换到bin目录下，使用ls命令查看

执行语句为：cd bin/

执行语句为：ls

ibd2sdi mysqladmin

innochecksum mysqlbinlog

lz4_decompress mysqlcheck

my_print_defaults mysqld

myisam_ftdump mysqld_multi

myisamchk mysqld_safe

myisamlog mysqldump

myisampack mysqldumpslow

mysql mysqlimport

mysql_config mysqlpump

mysql_config_editor mysqlshow

mysql_secure_installation mysqlslap

mysql_ssl_rsa_setup perror

mysql_tzinfo_to_sql zlib_decompress

mysql_upgrade

12.登录MySQL，输入指令后根据提示输入初始密码

执行语句为：./mysql -u root -p

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 10

Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, 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> show databases;

+--------------------+

| Database                    |

+--------------------+

| information_schema   |

| mysql                          |

| performance_schema |

| sys                              |

+--------------------+

4 rows in set (0.01 sec)

mysql> 

参考资料：

1.Mac上安装mysql数据库

2.MAC上安装MySQL，测试是否安装好了，在命令窗中作建表、查询等基本操作