yum安装nginx+mysql+php 命令准备 创建目录 mkdir 目录名 chmod 777 目录名 变更权限 加入开机启动项服务 chkconfig --add php-fpm chkconfig nginx on 查找文件位置 经常用于查找yum安装后各种配置文件及启动程序所在位置 find|grep php-fpm 服务启动 servic
yum安装nginx+mysql+php命令准备
创建目录
mkdir 目录名
chmod 777 目录名 变更权限
加入开机启动项服务
chkconfig --add php-fpm
chkconfig nginx on
查找文件位置 经常用于查找yum安装后各种配置文件及启动程序所在位置
find|grep php-fpm
服务启动
service nginx
start|stop|restart|condrestart|try-restart|force-reload|upgrade|reload|status|help|configtest
service nginx start
service php-fpm start
查看进程
ps -ef | grep java
查看进程
kill -9 进程id
1.安装
添加nginx源http://nginx.org/packages/centos/6/noarch/RPMS/nginx-release-centos-6-0.el6.ngx.noarch.rpm
wget http://nginx.org/packages/centos/6/noarch/RPMS/nginx-release-centos-6-0.el6.ngx.noarch.rpm
rpm -ivh nginx-release-centos-6-0.el6.ngx.noarch.rpmrpm -qa | grep nginx 检查nginx 是否加入源路径
安装 php mysql nginx
yum install mysql mysql-server php php-mysql php-fpm nginx
php组件库 选择安装 如果找不到源地址,请查找小技巧里面的更新第三方源库
yum install php-cli php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mssql php-snmp php-soap php-tidy php-common php-devel
2.配置
2.1nginx 配置
配置文件位置 如果找不到相关配件,查找文件位置 命令/etc/nginx/nginx.conf
/etc/nginx/conf.d/*.conf
多个站点放在conf.d目录,在nginx.conf用include语法包含
include /etc/nginx/conf.d/*.conf;
默认default.conf修改
server { listen 80; server_name localhost;<span>#自定义域名配置</span> #charset koi8-r; #access_log /var/log/nginx/log/host.access.log main; location / { root /home/www;<span>#自定义目录设置</span> index index.html index.htm<span> index.php</span>; } #error_page 404 /404.html; # redirect server error pages to the static page /50x.html #<span>错误页处理</span> error_page 500 502 503 504 /50x.html; location = /50x.html { root /home/www; } # 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 /home/www; #fastcgi_pass 127.0.0.1:9000; <span>fastcgi_pass unix:/tmp/php-cgi.sock;#这种方式听说性能提升比较多</span> fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME /home/www$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; #} }
类似
其他*.conf 可自定义添加
server { listen 80; server_name wx.vtz.cc; index index.html index.htm index.php; root /home/wwwroot/weixin; location ~ .*\.(php|php5)?$ { try_files $uri =404; fastcgi_pass unix:/tmp/php-cgi.sock; fastcgi_index index.php; include fcgi.conf; } location /status { stub_status on; access_log off; } location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$ { expires 30d; } location ~ .*\.(js|css)?$ { expires 12h; } access_log /home/wwwlogs/weixin_access.log access; }
2.2 php-fpm.conf配置
include=/etc/php-fpm.d/*.conf //因为包含其他文件,/etc/php-fpm.d查找到www.conf 修改[www]
#设置监听 修改项
#listen = 127.0.0.1:9000 listen = /tmp/php-cgi.sock
3.添加服务自启动
nginx 服务chkconfig --add nginx chkconfig nginx on service nginx start
php-fpm
chkconfig --add php-fpm chkconfig php-fpm on service php-fpm start
mysql
chkconfig --add mysqld chkconfig mysqld on service mysqld start
默认root 密码空
小技能:
1.php开启错误提示
<span><strong>vim</strong></span> <span>/</span>etc<span>/</span>php5<span>/</span>fpm<span>/</span>php.ini |
打开错误提示
display_errors = On |
因为用到的四fpm与nginx配合,所以还需要修改php-fpm.conf文件
<span><strong>vim</strong></span> <span>/</span>etc<span>/</span>php5<span>/</span>fpm<span>/</span>php-fpm.conf |
再最后添加 有可能在此配置文件里面 www.conf
php_flag<span><strong>[</strong></span>display_errors<span><strong>]</strong></span> = on |
让后从新读取nginx配置
<span><strong>sudo</strong></span> service nginx reload |
2.其他安装参考
-
配置CentOS 6.0 第三方yum源(CentOS默认的标准源里没有nginx软件包)
1
yum
install
wget
2
wget http://www.atomicorp.com/installers/atomic
3
sh ./atomic
4
yum update
-
安装开发包和库文件
1
yum -y
install
ntp
make
openssl openssl-devel pcre pcre-devel libpng
2
libpng-devel libjpeg-6b libjpeg-devel-6b freetype freetype-devel gd gd-devel zlib zlib-devel
3
gcc gcc-c++ libXpm libXpm-devel ncurses ncurses-devel libmcrypt libmcrypt-devel libxml2
4
libxml2-devel imake autoconf automake
screen
sysstat compat-libstdc++-33 curl curl-devel
-
卸载已安装的apache、mysql、php
1
yum remove httpd
2
yum remove mysql
3
yum remove php
-
安装nginx
1
yum
install
nginx
2
service nginx start
3
chkconfig --levels 235 nginx on
-
安装mysql
1
yum
install
mysql mysql-server mysql-devel
2
service mysqld start
3
chkconfig --levels 235 mysqld on
4
mysqladmin -u root password
"密码"
<span></span>service mysqld restart
-
安装php
1
yum
install
php lighttpd-fastcgi php-cli php-mysql php-gd php-imap php-ldap
2
php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mssql php-snmp php-soap
3
php-tidy php-common php-devel php-fpm
4
5
service php-fpm start
6
7
chkconfig --levels 235 php-fpm on
-
配置nginx支持php
1
mv
/etc/nginx/nginx.conf /etc/nginx/nginx.confbak
2
cp
/etc/nginx/nginx.conf.default /etc/nginx/nginx.conf
3
vi
/etc/nginx/nginx.conf
1
location ~ \.php$ {
2
root /usr/share/nginx/html;
3
fastcgi_pass 127.0.0.1:9000;
4
fastcgi_index index.php;
5
fastcgi_param SCRIPT_FILENAME /usr/share/nginx/html$fastcgi_script_name;
6
include fastcgi_params;
7
}
-
重启nginx php-fpm
view source print?1
service nginx restart
2
service php-fpm restart
3.服务器状况php函数组件探针
下载地址4.mysql 新建用户外网访问
insert into mysql.user(Host,User,Password) values("%","admin",password("1234")); update mysql.user set password=password('新密码') where User="phplamp" and Host="localhost"; grant all privileges on *.* to 'yourname'@'%' identified by 'youpasswd'; //密码为必填项 flush privileges;
5.linux svn搭建 版本库
1、 # yum install subversion2、新建一个目录用于存储SVN所有文件
# mkdir /home/svn
3、在上面创建的文件夹中为项目 project_1 创建一个版本仓库
# svnadmin create /home/svn/project_1
执行完这一步,/home/svn 中将存在project_1文件夹,这个项目的配置都在 /home/svn/project_1/conf 中
4、为项目配置权限
(1)svnserve.conf 是主配置文件
# vi /home/svn/project_1/conf/svnserve.conf
anon-access=read #匿名可读
auth-access=write #验证用户可读写
password-db=passwd #指向验证用户名密码的数据文件 passwd ,请看下文配置
auth-db=authz #指向验证用户的权限配置文件 authz ,请看下文配置
注意:每一行前方不能有空格,否则会出现 Option expected 错误!
(2)passwd 用户名密码配置文件
# vi /home/svn/project_1/conf/passwd
[users]
manager1=123456 #每一行都要是“用户名=密码”的格式
manager2=123123
manager3=888888
(3)authz 用户权限配置文件
# vi /home/svn/project_1/conf/authz
[groups]
managers=manager1,manager2 #定义群组 managers 包含 manager1 和 manager2 两个用户
[/]
@managers=rw #定义群组 managers 有读写权限
manager3=r #定义 manager3 有读权限
*= #以上没有定义的用户都没有任何权限
4,启动和停止SVN服务
启动SVN服务:
[root@svn ~]# svnserve -d -r /data/svndata/
-d表示后台运行
-r 指定根目录是 /data/svndata/
停止SVN服务:
ps -aux |grep svn

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 English version
Recommended: Win version, supports code prompts!

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Dreamweaver Mac version
Visual web development tools

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools
