2024年Go最全MAC系统安装配置LNMP+TP6_mac tp项目部署(3)，Golang 400道面试题通关宝典助你进大厂

本文链接：https://blog.csdn.net/2401_84910919/article/details/138877239

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上Go语言开发知识点，真正体系化！

由于文件比较多，这里只是将部分目录截图出来，全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新

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>


用Navicat链接MySQL时, 出现 Authentication plugin ‘caching\_sha2\_password’ cannot be loaded  
 出现这个原因是mysql8 之前的版本中加密规则是mysql\_native\_password, 而在mysql8之后,加密规则是caching\_sha2\_password  
 解决问题方法是把mysql用户登录密码加密规则还原成mysql\_native\_password.


1. 登陆MySQL
2. 修改账户密码加密规则并更新用户密码

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘your password’ PASSWORD EXPIRE NEVER;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘your password’;


3. 刷新权限并重置密码

FLUSH PRIVILEGES;


Navicat远程登录报错Host is not allowed to connect to this MySQL server


1. 登录MySQL mysql -u root -p密码
2. 执行use mysql
3. 执行update user set host = ‘%’ where user = ‘root’;这一句执行完可能会报错，不用管它
4. 执行FLUSH PRIVILEGES


设置mysql开机自启动


1. 编辑一个mysql启动文件

sudo vim /Library/LaunchDaemons/com.mysql.mysql.plist


2. 输入启动文件内容

<?xml version="1.0" encoding="UTF-8"?> KeepAlive Label com.mysql.mysqld ProgramArguments /usr/local/Cellar/mysql/8.0.19/bin/mysqld_safe --user=root


上面xml中的 /usr/local/Cellar/mysql/8.0.19/bin/mysqld\_safe 为我的mysql所在目录


3. 加载这个启动文件

sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist


4. 查看启动情况

ps -aef | grep mysql


###### 四. 安装Nginx

brew install nginx


通过brew安装后位置: /usr/local/Cellar

进入

cd /usr/loca