下载Mysql

  下载地址 <span class="md-link" spellcheck="false">[https://dev.mysql.com/downloads/mysql/](https://dev.mysql.com/downloads/mysql/)</span>

  选择tar压缩文件

配置环境

  解压文件放到你希望的目录中

  配置环境变量 例如： vi ~/.bash_profile export PATH=$PATH:/usr/local/mysql/bin 使其生效：source ~/.bash_profile

初始化mysql mysql 8.0

执行 scripts 目录下的 mysql_install_db 脚本完成一些默认的初始化(创建默认配置文件、授权表等) cd /usr/local/mysql sudo scripts/mysql_install_db

  <span class="md-image md-img-loaded" contenteditable="false" data-src="https://ws2.sinaimg.cn/large/006tNbRwly1fx9xmzyphej31m6074jti.jpg">![](https://ws2.sinaimg.cn/large/006tNbRwly1fx9xmzyphej31m6074jti.jpg)</span>

  <span class="">为了快速启动和停止mysql 我配置了别名</span>

  <span class="md-image md-img-loaded" contenteditable="false" data-src="https://ws4.sinaimg.cn/large/006tNbRwly1fx9xkpfh6oj30x603wwfa.jpg">![](https://ws4.sinaimg.cn/large/006tNbRwly1fx9xkpfh6oj30x603wwfa.jpg)</span>

  <span class="">检测mysql的status 执行mysqlstatus</span>

  <span class="">启动mysql 执行 </span>

出现这个错误

是权限的问题，把mysql的权限直接修改为777(由于本地安全性相对不用考虑，所有给出全部权限，服务器端请慎重)

sudo chmod -R 777 mysql/

修改root秘密

ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘root’;

执行flush privileges; 之后，客户端就支持远程连接mysql了

问题汇总

  <span class="md-image md-img-loaded" contenteditable="false" data-src="https://ws1.sinaimg.cn/large/006tNbRwly1fx9ypt6t5jj30ps0900zp.jpg">![](https://ws1.sinaimg.cn/large/006tNbRwly1fx9ypt6t5jj30ps0900zp.jpg)</span>

  <span class=" md-link">[参考](http://www.cnblogs.com/uoar/p/9328027.html)</span> <span class=" md-link">[参考2](https://blog.csdn.net/u010026255/article/details/80062153)</span> 修改 root 用户密码： <span class="">mysql>ALTER USER &#8216;root&#8217;@&#8217;%&#8217; IDENTIFIED WITH mysql_native_password BY &#8216;root&#8217;; </span>

  <span class="">配置指定用户权限</span><span class="md-link">[参考](https://www.cnblogs.com/testway/p/9289827.html)</span>

  <span class="">其他参考 </span><span class="md-link md-expand" spellcheck="false">[https://blog.csdn.net/g15738290530/article/details/80956389](https://blog.csdn.net/g15738290530/article/details/80956389)</span>