mac brew install mysql@5.7

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

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容