mac brew install mysql@5.7

2019-04-28  本文已影响0人  八戒学ai

1.brew search mysql

2.brew install mysql@5.7

3.装好输入mysql -u root,提示mysql: command not found!

则查找mysql安装在哪:find / -name "mysql":

sypdeMacBook-Pro:~ syp$ find / -name "mysql"

find: /usr/sbin/authserver: Permission denied

/usr/local/var/mysql

/usr/local/var/mysql/mysql

/usr/local/Cellar/mysql@5.7/5.7.25/bin/mysql

/usr/local/Cellar/mysql@5.7/5.7.25/include/mysql

/usr/local/Cellar/mysql@5.7/5.7.25/include/mysql/mysql

/usr/local/Cellar/mysql@5.7/5.7.25/share/mysql

这个是mysql的所在位置:/usr/local/Cellar/mysql@5.7/5.7.25/bin/mysql

4.sudo vim /etc/profile ,在最后一行添加:

export PATH=$PATH:/usr/local/Cellar/mysql@5.7/5.7.25/bin

5.source /etc/profile   表示设置立即生效

6.mysql -uroot

7.use mysql;

8.update user set authentication_string=password('123456') where user='root';

9.flush privileges;

10.exit;

11.开机自启动:https://www.jianshu.com/p/6816cdb99ec9

上一篇 下一篇

猜你喜欢

热点阅读