mac 上安装 mysql

1.点击dmg文件安装,一路点next即可,中间需要什么权限都给,记得保存过程中生成的临时密码:我的如下

2016-05-20T12:33:12.204930Z 1 [Note] A temporary password is generated for root@localhost: _#aPNpyT8H.)


If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.


2.配置Macmysql环境变量:

 1⃣️.打开终端,输入: cd ~

会进入~文件夹

 2⃣️然后输入:touch .bash_profile

回车执行后,

 3⃣️.再输入:open -e .bash_profile

会在TextEdit中打开这个文件(如果以前没有配置过环境变量,那么这应该是一个空白文档)。如果有内容,请在结束符前输入,如果没有内容,请直接输入如下语句:

export PATH=${PATH}:/usr/local/mysql/bin

然后,保存,退出


3.打开终端:依次如下

输入:mysql -u root -p

输入零时密码:_#aPNpyT8H.)

 显示:

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

Your MySQL connection id is 9

Server version: 5.7.12


Copyright (c) 2000, 2016, 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.



4.输入:show databases;

提示:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.


5.修改密码:

set PASSWORD =PASSWORD('123456');

显示:Query OK, 0 rows affected, 1 warning (0.01 sec)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值