OS + CentOS 8.2 / MySQL 8.0.31 + phpmyadmin5.12 + Nginx1.14.1
s
- php MeekroDB mysql
MeekroDB :: The Simple PHP MySQL Library
-
CentOS8 Nginx配置php-fpm
https://wiki.miyond.com/?p=316
nginx 中 fastcgi_pass配置为unix:/tmp/php-fpm.sock与127.0.0.1:9000区别
https://blog.csdn.net/resilient/article/details/109850729
nginx中的 fastcgi_pass为什么有时候是unix:/tmp/php-fpm.sock，有时候是127.0.0.1:9000 这牵扯到了nginx和php的通信模式，上面所列的就是这两种，一种是利用系统本身socket的，一种是利用tcp协议的 两种协议有区别， UNIX Domain Socket不经过网络，只是在系统内部进行通信，适用于php和nginx都装在同一台linux服务器上 tcp通信协议的也就是fastcgi_pass模式的既适用于php和nginx都装在同一台linux服务器上，同时又适用于不在同一台服务器上的，一般在同一个局域网中，也就是127.0.0.1的意义了 当然我们在真正的php搭建服务器环境的时候，具体用那种，就要看php-fpm.conf中使用的是哪种了 tcp方式: php-fpm.conf: listen = 127.0.0.1:9000 nginx.conf: fastcgi_pass 127.0.0.1:9000; UNIX Domain Socket方式: php-fpm.conf: listen = /tmp/php-fpm.sock nginx.conf: fastcgi_pass unix:/tmp/php-fpm.sock; 在我们真正实例中多数都是装在同一台服务器上，所以选择UNIX Domain Socket是比较合适的选择，因为这样可以避免数据传输经过tcp层造成导致TIME_WAIT连接过多的问题。 具体两个传输方式的流程如下 1.1 TCP Socket(本地回环127.0.0.1)方式的数据传输: Nginx <=> socket <=> TCP/IP <=> socket <=> PHP-FPM 1.2 TCP Socket(Nginx和PHP-FPM位于不同服务器)的数据传输: Nginx <=> socket <=> TCP/IP <=> 物理层 <=> 路由器 <=> 物理层 <=> TCP/IP <=> socket <=> PHP-FPM 2 UNIX Domain Socket方式的数据传输: Nginx <=> socket <=> PHP-FPM ————————————————
如何让tomcat支持PHP运行
http://blog.iis7.com/article/18350.html
centos8安装mysql与mysql的配置文件
https://www.cnblogs.com/jiyuchen1/p/16452651.html
CentOS7上优雅地重置MySQL8.0数据库密码
https://blog.csdn.net/xinpengfei521/article/details/80400142
方案一，centos8.5 yum install mysql-server.x86_64 ， 本地yum源方式安装mysql 8.0.26
[root@scts08t ~]# yum list mysql-server.x86_64 [root@scts08t ~]# yum list mysql-server Last metadata expiration check: 2:23:54 ago on Wed 23 Nov 2022 09:46:37 AM PST. Installed Packages mysql-server.x86_64 8.0.26-1.module_el8.4.0+915+de215114 @media-appstream [root@scts08t ~]# yum install mysql-server.x86_64 # 如果安装异常，则执行如下命令 [root@scts08t ~]# yum install -y mysql-server.x86_64 --allowerasing # --allowerasing：此选项允许包管理器擦除软件包以满足安装过程中的依赖关系。在存在冲突并且需要擦除某些软件包以继续安装的情况下，这是有用的。 [root@scts08t ~]# yum install mysql.x86_64 [root@scts08t ~]# vim /var/log/mysql/mysqld.log [root@scts08t ~]# vim /var/log/mysql/mysqld.log 2022-11-23T19:47:36.638628Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.26) initializing of server in progress as process 7230 2022-11-23T19:47:36.647063Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-11-23T19:47:36.949404Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-11-23T19:47:38.026356Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main 2022-11-23T19:47:38.026688Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main 2022-11-23T19:47:38.137786Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2022-11-23T19:47:41.063855Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.26) starting as process 7278 2022-11-23T19:47:41.075079Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2022-11-23T19:47:41.235618Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2022-11-23T19:47:41.612351Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main 2022-11-23T19:47:41.612628Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main 2022-11-23T19:47:41.614989Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2022-11-23T19:47:41.615361Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2022-11-23T19:47:41.651953Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock 2022-11-23T19:47:41.652089Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.26' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
空密码登录，更新root密码，更新可以外部连接，flush 权限。
[root@scts08t ~]# mysql -uroot -p -hlocalhost mysql> show databases; mysql> use mysql; mysql> alter user user() identified by "ar=vW0cgAyu_8888"; mysql> update mysql.user set host='%' where user='root'; mysql> flush privileges;
方案二，mysql-8.0.31-1.el8.x86_64.rpm-bundle.tar下载解压
https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.31-1.el8.x86_64.rpm-bundle.tar
mysql-community-client-8.0.31-1.el8.x86_64.rpm mysql-community-client-debuginfo-8.0.31-1.el8.x86_64.rpm mysql-community-client-plugins-8.0.31-1.el8.x86_64.rpm mysql-community-client-plugins-debuginfo-8.0.31-1.el8.x86_64.rpm mysql-community-common-8.0.31-1.el8.x86_64.rpm mysql-community-debuginfo-8.0.31-1.el8.x86_64.rpm mysql-community-debugsource-8.0.31-1.el8.x86_64.rpm mysql-community-devel-8.0.31-1.el8.x86_64.rpm mysql-community-icu-data-files-8.0.31-1.el8.x86_64.rpm mysql-community-libs-8.0.31-1.el8.x86_64.rpm mysql-community-libs-debuginfo-8.0.31-1.el8.x86_64.rpm mysql-community-server-8.0.31-1.el8.x86_64.rpm mysql-community-server-debug-8.0.31-1.el8.x86_64.rpm mysql-community-server-debug-debuginfo-8.0.31-1.el8.x86_64.rpm mysql-community-server-debuginfo-8.0.31-1.el8.x86_64.rpm mysql-community-test-8.0.31-1.el8.x86_64.rpm mysql-community-test-debuginfo-8.0.31-1.el8.x86_64.rpm
方法一, 修改mysql 8.0 root 密码
1、centos8.2环境下，按顺序如下安装mysql文件包
[root@centos82-scts08t opt]# more setup.sh
#/bin/bash rpm -ivh /opt/mysql-community-client-plugins-8.0.31-1.el8.x86_64.rpm rpm -ivh /opt/mysql-community-common-8.0.31-1.el8.x86_64.rpm rpm -ivh /opt/mysql-community-libs-8.0.31-1.el8.x86_64.rpm rpm -ivh /opt/mysql-community-client-8.0.31-1.el8.x86_64.rpm rpm -ivh /opt/mysql-community-icu-data-files-8.0.31-1.el8.x86_64.rpm rpm -ivh /opt/mysql-community-server-8.0.31-1.el8.x86_64.rpm tar -zxvf /opt/apache-tomcat-10.0.27.tar.gz -C /opt tar -zxvf /opt/nginx-1.23.2.tar.gz -C /opt unzip /opt/phpMyAdmin-5.2.0-all-languages.zip -d /opt systemctl stop firewalld.service systemctl disable firewalld.service
2、安装后检查mysql清单
[root@centos82-scts08t opt]# rpm -qa |grep mysql mysql-community-client-8.0.31-1.el8.x86_64 mysql-community-client-plugins-8.0.31-1.el8.x86_64 mysql-community-icu-data-files-8.0.31-1.el8.x86_64 mysql-community-common-8.0.31-1.el8.x86_64 mysql-community-server-8.0.31-1.el8.x86_64 mysql-community-libs-8.0.31-1.el8.x86_64
3、重启mysql server
[root@centos82-scts08t ~]# systemctl restart mysqld.service
4、查找密码，新版本密码方式改变了，shit mysql installation，fuck Larry Ellison
[root@centos82-scts08t ~]# grep password /var/log/mysqld.log
2022-11-01T11:46:27.017354Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ar=vW0cgAyu_
5、[root@centos82-scts08t ~]# mysql -uroot -p密码 -hlocalhost
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
意思首先得强制改密码，还得复杂，草泥马。
mysql> alter user user() identified by "caonima";
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> alter user user() identified by "ar=vW0cgAyu_8888";
6、设置允许远程连接MySQL 8，并立即生效
mysql> use mysql;
mysql> update mysql.user set host='%' where user='root';
mysql> flush privileges;
7、
方法二, 修改mysql 8.0 root 密码
1、centos8.2环境下，按顺序如下安装mysql文件包（同上）
2、 mysql 8.0.26 修改/etc/my.cnf文件，加入skip-grant-tables后重启mysql
[root@centos82-scts08t ~]# echo "skip-grant-tables" >> /etc/my.cnf
3、mysql重启
[root@centos82-scts08t ~]# systemctl restart mysqld.service
4、mysql无密码进入，直接回车
[root@centos82-scts08t ~]# mysql -uroot -p -h127.0.0.1
RROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:3306'
或
[root@centos82-scts08t ~]# mysql
5、mysql修改密码，https://download.csdn.net/download/weixin_38501206/12824626
mysql> select host,user,authentication_string,plugin from user; --查询root的authentication_string密码
mysql> update user set authentication_string='' where user='root'; --先强制置空这个B养的加密密码
mysql> select host,user,authentication_string,plugin from user;
6、然后注释/etc/my.cnf 中 skip-grant-tables行
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid #skip-grant-tables
7、再重启mysql进入修改成新root密码。
[root@centos85 ~]# systemctl restart mysqld.service
8、再无密码进入修改密码，至少8位数，又是他妈的烦神。
mysql> alter user user() identified by "caonima.com";
或
mysql> alter user 'root' identified by "caonima.com";
mysql> flush privileges;
9、创建远程用户，再授权
mysql> create user 'root'@'%' identified by '密码';
mysql> grant all privileges on *.* to 'root'@'%' with grant option;
mysql> flush privileges;
10、检查ok，远程连接验证ok。
mysql> select User,Host from user;
centos8.5 部署nginx 1.14.1 + php环境配置
1、安装nginx
[root@scts08t ~]# yum install -y nginx.x86_64
[root@scts08t ~]# nginx -v
nginx version: nginx/1.14.1
2、安装php相关环境
[root@scts08t ~]# yum install php php-fpm php-json php-mysqlnd php-mbstring.x86_64 -y
[root@scts08t ~]# php -v
PHP 7.2.24 (cli) (built: Oct 22 2019 08:28:36) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
[root@scts08t ~]# php-fpm -v
PHP 7.2.24 (fpm-fcgi) (built: Oct 22 2019 08:28:36)
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
[root@scts08t ~]# /usr/sbin/php-fpm -t #检测/etc/php-fpm.conf 配置文件
3、配置nginx
[root@scts08t ~]# vim /etc/nginx/nginx.conf #配置nginx + php结合
# For more information on configuration, see: # * Official English Documentation: http://nginx.org/en/docs/ user nginx; worker_processes auto; error_log /var/log/nginx/error.log; pid /run/nginx.pid; # Load dynamic modules. See /usr/share/doc/nginx/README.dynamic. include /usr/share/nginx/modules/*.conf; events { worker_connections 1024; } http { log_format main '$remote_addr - $remote_user [$time_local] "$request" ' '$status $body_bytes_sent "$http_referer" ' '"$http_user_agent" "$http_x_forwarded_for"'; access_log /var/log/nginx/access.log main; sendfile on; tcp_nopush on; tcp_nodelay on; keepalive_timeout 65; types_hash_max_size 2048; include /etc/nginx/mime.types; default_type application/octet-stream; include /etc/nginx/conf.d/php-fpm-upstream.conf; #自定义文件并新增内容，见下面文件，文件位必须放这里 #include /etc/nginx/conf.d/php-fpm.conf server { listen 80 default_server; listen [::]:80 default_server; server_name _; root /opt/phpmyadmin; # Load configuration files for the default server block. include /etc/nginx/default.d/php-location.conf; #自定义文件并新增内容，见下面文件，文件位必须放这里 location / { #index index.html index.php; } error_page 404 /404.html; location = /40x.html { } error_page 500 502 503 504 /50x.html; location = /50x.html { } } }
[root@scts08t ~]# vim /etc/nginx/conf.d/php-fpm-upstream.conf #配置PHP-FPM Server
或者
[root@scts08t ~]# vim /etc/nginx/conf.d/php-fpm.conf #配置PHP-FPM Server
# PHP-FPM FastCGI server # network or unix domain socket configuration upstream php-fpm { server unix:/run/php-fpm/www.sock; }
[root@scts08t ~]# vim /etc/nginx/default.d/php-location.conf #配置php环境解析
location ~ \.php$ { root /opt/phpmyadmin; include fastcgi_params; fastcgi_pass php-fpm; #关联/etc/nginx/conf.d/php-fpm-upstream.conf调度，或php-fpm.conf fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; #fastcgi_param SCRIPT_FILENAME /scripts$fastcgi_script_name; }
centos8.5 部署phpmyadmin 5.12
1、下载文件
[root@scts08t ~]# wget -c https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-languages.zip -P /opt
2、释放目录
[root@scts08t ~]# unzip -t /opt/phpMyAdmin-5.2.0-all-languages.zip
[root@scts08t ~]# unzip /opt/phpMyAdmin-5.2.0-all-languages.zip -d /opt/phpmyadmin
3、
查看nginx、php-fpm进程并查看log
[root@centos82-scts08t ~]# ps -ef |grep nginx; ps -ef |grep php;tail -f /var/log/nginx/*.log;tail -f /var/log/php-fpm/error.log
temp nginx.conf
end
centos82
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布：重大改进与新特性概览！
· 单线程的Redis速度为什么快？
· 展开说说关于C#中ORM框架的用法！
· Pantheons：用 TypeScript 打造主流大模型对话的一站式集成库