In this tutorial, I will show you how to install LEMP( Linux/ Nginx/Mysql/Php) server
Please prepare your machine and follow the steps bellow.
Please download nginx fromhttp://slackbuilds.org/repository/14.1/network/nginx/.
Source Downloads:
nginx-1.6.0.tar.gz
Download SlackBuild
nginx.tar.gz
Extract:
nginx.tar.gz
put nginx-1.6.0.tar.gz in nginx folder.
cdnginx root@slack1:~/Install/nginx# chmod +x nginx.SlackBuildroot@slack1:~/Install/nginx# ./nginx.SlackBuildusr/man/man8/usr/man/man8/nginx.8.gzSlackware package /tmp/nginx-1.6.0-i486-1_SBo.tgz created.
Start Install Nginx
installpkg /tmp/nginx-1.6.0-i486-1_SBo.tgz Verifying package nginx-1.6.0-i486-1_SBo.tgz. Installing package nginx-1.6.0-i486-1_SBo.tgz: PACKAGE DESCRIPTION: # nginx (http/imap/pop3 proxy) # # Nginx [engine x] is a high-performance HTTP server and reverse proxy, # as well as an IMAP/POP3 proxy server. # # Nginx was written by Igor Sysoev. # # Homepage: http://nginx.net/ # Executing install script for nginx-1.6.0-i486-1_SBo.tgz. Package nginx-1.6.0-i486-1_SBo.tgz installed.
make nginx’s startup script executable, and start it.
chmod +x /etc/rc.d/rc.nginx/etc/rc.d/rc.nginx startStarting Nginx server daemon...
Mysql
The Slackware 14.1 is using Mariadb by default.
cd /usr/share/mysqlcp my-medium.cnfmy.cnfchmod +x /etc/rc.d/rc.mysqld mysql_install_dbchown -R mysql:mysql /var/lib/mysql/etc/rc.d/rc.mysqld startmysql_secure_installation
PHP
chmod +x /etc/rc.d/rc.php-fpm/etc/rc.d/rc.php-fpm startStarting php-fpm Created directory: /var/lib/net-snmp/mib_indexesdone
Edit/etc/nginx/nginx.conf,
and index.php to the standard location:
location / {root /var/www/unixmen;indexindex.php index.html index.htm;}
Uncomment the php section.
location ~ /.php$ { root /var/www/unixmen; fastcgi_pass 127.0.0.1:9000; fastcgi_indexindex.php; fastcgi_paramSCRIPT_FILENAME$document_root$fastcgi_script_name; include fastcgi_params;}
Make phpinfo page.
vi/var/www/unixmen/info.php
<?phpphpinfo (); ?>
Restart apache
/etc/rc.d/rc.nginx restartShutdown Nginx gracefully...Starting Nginx server daemon...root@slack1:/usr/share/mysql#
checkhttp://ip/info.php.
phpMyadmin
Download the source and slackbuild fromhttp://slackbuilds.org/repository/14.1/network/phpmyadmin/.
Edit phpmyadmin.SlackBuild
DOCROOT=/var/www/ngdocs# you change it to your root web directory PHPGROUP=root =change to othe ownerorleaveit like this
makethe build ready ./phpmyadmin.SlackBuildSlackware package /tmp/phpmyadmin-4.1.8-noarch-1_SBo.tgz created.Install Now root@slack1:~/Install/phpmy/phpmyadmin# installpkg /tmp/phpmyadmin-4.1.8-noarch-1_SBo.tgzVerifying package phpmyadmin-4.1.8-noarch-1_SBo.tgz.Installing package phpmyadmin-4.1.8-noarch-1_SBo.tgz:PACKAGE DESCRIPTION:# phpmyadmin (MySQL administration over the web)## phpMyAdmin is a free software tool written in PHP intended# to handle the administration of MySQL over the web.# phpMyAdmin supports a wide range of operations with MySQL# and also includes ability to run SQL statements directly.## Homepage: http://www.phpmyadmin.net/#Package phpmyadmin-4.1.8-noarch-1_SBo.tgz installed.root@slack1:~/Install/phpmy/phpmyadmin#cd /var/www/unixmen/phpmyadmincp config.sample.inc.phpconfig.inc.phpchmod 0755/var/www/unixmen/phpmyadmin/
Restart apache
Load the page http://ip/phpmyadmin.
Enjoy!
For questions please refer to our Q/A forum at :http://ask.unixmen.com/
Share this Article:0
000
0
00

mysqlviewshavelimitations:1)他们不使用Supportallsqloperations,限制DatamanipulationThroughViewSwithJoinSorsubqueries.2)他们canimpactperformance,尤其是withcomplexcomplexclexeriesorlargedatasets.3)

porthusermanagementInmysqliscialforenhancingsEcurityAndsingsmenting效率databaseoperation.1)usecReateusertoAddusers,指定connectionsourcewith@'localhost'or@'%'。

mysqldoes notimposeahardlimitontriggers,butacticalfactorsdeterminetheireffactective:1)serverConfiguration impactactStriggerGermanagement; 2)复杂的TriggerSincreaseSySystemsystem load; 3)largertablesslowtriggerperfermance; 4)highConconcConcrencerCancancancancanceTigrignecentign; 5); 5)

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

通过PHP网页界面添加MySQL用户可以使用MySQLi扩展。步骤如下:1.连接MySQL数据库,使用MySQLi扩展。2.创建用户,使用CREATEUSER语句,并使用PASSWORD()函数加密密码。3.防止SQL注入,使用mysqli_real_escape_string()函数处理用户输入。4.为新用户分配权限,使用GRANT语句。

mysql'sblobissuitableForStoringBinaryDataWithInareLationalDatabase,而alenosqloptionslikemongodb,redis和calablesolutionsoluntionsoluntionsoluntionsolundortionsolunsolunsstructureddata.blobobobsimplobissimplobisslowderperformandperformanceperformancewithlararengelitiate;

toaddauserinmysql,使用:createUser'username'@'host'Indessify'password'; there'showtodoitsecurely:1)choosethehostcarecarefullytocon trolaccess.2)setResourcelimitswithoptionslikemax_queries_per_hour.3)usestrong,iniquepasswords.4)Enforcessl/tlsconnectionswith

toAvoidCommonMistakeswithStringDatatatPesInMysQl,CloseStringTypenuances,chosethirtightType,andManageEngencodingAndCollationsEttingsefectery.1)usecharforfixed lengengters lengengtings,varchar forbariaible lengength,varchariable length,andtext/blobforlabforlargerdata.2 seterters seterters seterters seterters


热AI工具

Undresser.AI Undress
人工智能驱动的应用程序,用于创建逼真的裸体照片

AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool
免费脱衣服图片

Clothoff.io
AI脱衣机

Video Face Swap
使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸!

热门文章

热工具

适用于 Eclipse 的 SAP NetWeaver 服务器适配器
将Eclipse与SAP NetWeaver应用服务器集成。

SublimeText3 英文版
推荐:为Win版本,支持代码提示!

SecLists
SecLists是最终安全测试人员的伙伴。它是一个包含各种类型列表的集合,这些列表在安全评估过程中经常使用,都在一个地方。SecLists通过方便地提供安全测试人员可能需要的所有列表,帮助提高安全测试的效率和生产力。列表类型包括用户名、密码、URL、模糊测试有效载荷、敏感数据模式、Web shell等等。测试人员只需将此存储库拉到新的测试机上,他就可以访问到所需的每种类型的列表。

SublimeText3 Mac版
神级代码编辑软件(SublimeText3)

安全考试浏览器
Safe Exam Browser是一个安全的浏览器环境,用于安全地进行在线考试。该软件将任何计算机变成一个安全的工作站。它控制对任何实用工具的访问,并防止学生使用未经授权的资源。