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

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

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

如果你需要这些资料，可以戳这里获取

Copyright © 2000, 2020, 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.

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/local/Cellar/nginx/1.17.10

启动 默认端口8080

nginx

重启

nginx -s reload

停止

nginx -s stop

检验

在浏览器中输入 127.0.0.1:8080  
 ![在这里插入图片描述](https://img-blog.csdnimg.cn/20200527153214864.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2MjYxMTMw,size_16,color_FFFFFF,t_70)  
 或者终端里输入

curl 127.0.0.1:8080

Welcome to nginx!

If you see this page, the nginx web server is successfully installed and working. Further configuration is required.

For online documentation and support please refer to nginx.org.
Commercial support is available at nginx.com.

Thank you for using nginx.

设置Nginx开机自启动

1

mkdir -p ~/Library/LaunchAgents

2

cp /usr/local/Cellar/nginx/1.17.10/homebrew.mxcl.nginx.plist ~/Library/LaunchAgents/

3

launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.nginx.plist

4

sudo chown root:wheel /usr/local/Cellar/nginx/1.17.10/bin/nginx

5

sudo chmod u+s /usr/local/Cellar/nginx/1.17.10/bin/nginx

###### 五. 配置文件


通过brew安装, 配置文件位置为: /usr/local/etc

cd /usr/local/etc

查看

ls

ODBCDataSources httpd nginx openssl redis-sentinel.conf
bash_completion.d locales.conf odbc.ini openssl@1.1 redis-sentinel.conf.default
freetds.conf my.cnf odbcinst.ini php redis.conf
gitconfig my.cnf.default openldap pool.conf redis.conf.default

数据库配置文件

my.cnf

nginx配置文件

ngin/

php配置文件

php/

1. 查看php-fpm端口

进入

cd /usr/local/etc/php/7.4/php-fpm.d

查看

vim vim www.conf

绑定端口

…
listen = 127.0.0.1:9000
…

2. Nginx配置文件

编辑

vim /usr/local/etc/nginx/nginx.conf

日志打开

…
http {
…
log_format main '$remote_addr - $remote\_user[$time_local] “KaTeX parse error: Double superscript at position 34: … '̲status $body\_bytes\_sent"$http_referer” ’
‘“$http\_user\_agent""$http_x_forwarded_for”’;
…
access_log logs/access.log main;
…
}

在文件http包体末尾添加

include wang/*;

新建wang文件夹, 用来管理项目配置

新建

mkdir wang

进入

cd wang

新建当前项目配置文件

vim wang.com.conf

编辑

server {
listen 8081;
server_name wang.com;

    #charset koi8-r;

    access_log  logs/wang.com.access.log  main;
	error_log logs/wang.com.error.log;
    location / {
        root   /Users/laowang/PhpstormProjects/tp6/public;
        index  index.html index.htm index.php;
    }

    #error\_page 404 /404.html;

    # redirect server error pages to the static page /50x.html
    #
    error_page   500 502 503 504  /50x.html;
    location = /50x.html {
        root   html;
    }

    # proxy the PHP scripts to Apache listening on 127.0.0.1:80
    #
    #location ~ \.php$ {
    # proxy\_pass http://127.0.0.1;
    #}

    # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
    #
    location ~ \.php$ {
        root           /Users/laowang/PhpstormProjects/tp6/public;
        fastcgi_pass   127.0.0.1:9000;
        fastcgi_index  index.php;
        fastcgi_param  SCRIPT_FILENAME  $document\_root$fastcgi\_script\_name;
        include        fastcgi_params;
    }

    # deny access to .htaccess files, if Apache's document root
    # concurs with nginx's one
    #
    #location ~ /\.ht {
    # deny all;
    #}
}

使用域名访问时, 要将该域名绑定到本机

sudo vim /etc/hosts
…
127.0.0.1 wang.com
…

修改配置后重新加载Nginx

sudo nginx -s reload

至此, Nginx可以通过该域名访问静态资源, 但是还不能访问php文件, 因为未开启php-fpm


开启php-fpm服务

进入

cd /usr/local/Cellar/php/7.4.6/sbin

开启

nohup ./php-fpm > a.log &

此时可以访问php文件


Nginx不支持PathInfo模式


不支持 http://wang.com:8081/index.php/demo/index  
 支持 http://wang.com:8081/index.php?s=demo/index

修改配置文件, 使其支持pathinfo模式

vim /usr/local/etc/nginx/wang/wang.com.conf

…
location / {
root /Users/laowang/PhpstormProjects/tp6/public;
index index.html index.htm index.php;
if (!-e $request_filename) {

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

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

如果你需要这些资料，可以戳这里获取

;
if (!-e $request_filename) {

[外链图片转存中…(img-FAOLzTqc-1715705372448)]
[外链图片转存中…(img-qNUg9a28-1715705372448)]
[外链图片转存中…(img-faahu1wT-1715705372449)]

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

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

如果你需要这些资料，可以戳这里获取