Guide to installing mysql+apache+php under Linux_PHP tutorial
.mysql tutorial
Download the mysql for linux rpm package on the following page
http://www.mysql.com/downloads/down...3.52-1.i386.rpm
http://www.mysql.com/downloads/down...3.52-1.i386.rpm
Save to /home/tmp directory
Command list:
cd /home/tmp
rpm -ivh mysql-3.23.52-1.i386.rpm //#Install mysql server
rpm -ivh mysql-client-3.23.52-1.i386.rpm //#Install mysql client
/usr/mysql/safe_mysqld & //#Start mysql server
mysql //#Run the mysql client and open the root user’s remote access permissions for debugging
use mysql
update user set host = '%' where user = 'root' and host <> 'localhost';
flush privileges;
quit //MySQL installation is now complete
2.apache
Download the source code package of apache for linux on the following page
http://www.apache.org/dist/httpd/apache_1.3.26.tar.gz
Save to /home/tmp directory
Command list:
cd /home/tmp
tar -zxvf apache_1.3.26.tar.gz
mv apache_1.3.26.tar.gz apache
cd apache
./configure --prefix=/usr/local/apache --enable-module=so
make
make install install apache to /usr/local/apache //and configure apache to support dso mode
3.php tutorial
Download the source code package of php for linux on the following page
http://www.php.net/get_download.php?df=php-4.2.3.tar.gz
Save to /home/tmp directory
Command list:
cd /home/tmp
tar -zxvf php-4.2.3.tar.gz
mv php-4.2.3.tar.gz php
cdphp
./configure --prefix=/usr/local/php --with-apxs=/usr/local/apache/bin/apxs --with-config-file-path=/usr/local/lib --enable-track -vars --with-xml --with-mysql
make
make install
cp php.ini-dist /usr/local/lib/php.ini
Install php to /usr/local/php in dso mode. Set the configuration file directory to /usr/local/lib and enable mysql and xml support
4. Configuration
vi /usr/local/apache/conf/httpd.conf
Configure apache as follows
#Change the ServerAdmin q3boy@younet.com line to your email address
#DocumentRoot "/home/httpd/html/" This is the home directory of html files
# Same as above
#Options FollowSymLinks MultiViews For safety reasons, remove "Indexes"
#
# DirectoryIndex default.php default.phtml default.php3 default.html default.htm
#
#Set apache’s default file name order
#AddType application/x-httpd-php .php .phtml .php3 .inc
#AddType application/x-httpd-php-source .phps tutorial
#Set php file suffix
Save and exit
vi /usr/local/lib/php.ini
#register-golbals = On //Save and exit
5. Start the service
/usr/local/apache/bin/apachectl start
6. Remarks
The default maximum number of processes for Apache under Linux is 256. No matter how you modify httpd.conf, you cannot exceed this limit. If you want to increase this limit, edit /home/tmp/apache/src/include/httpd.h before compiling apache, and change the line #define HARD_SERVER_LIMIT 256 to #define HARD_SERVER_LIMIT 2048 before compiling apache,
mod_so seems to be no longer the default module in apache 1.3.26. You need to add --enable-module=so when compiling. I did not add this parameter when compiling for the first time. As a result, apxs
cannot be found when PHP is compiled.The default configuration file path seems to have changed in php 4.2.3. You need to add the --with-config-file-path=/usr/local/lib parameter when compiling. I compiled php.ini for the first time and put it in n places to no avail. As a last resort. Only this parameter can be added.
p.s. There is no guarantee that the steps described in this article will apply to other versions
Attachment: Related file download address
php: http://www.php.net/get_download.php?df=php-4.2.3.tar.gz
apache: http://www.apache.org/dist/httpd/apache_1.3.26.tar.gz
mysql server: http://www.mysql.com/downloads/down...3.52-1.i386.rpm
mysql client: http://www.mysql.com/downloads/down...3.52-1.i386.rpm

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

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.

SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.

MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

Handling high DPI display in C can be achieved through the following steps: 1) Understand DPI and scaling, use the operating system API to obtain DPI information and adjust the graphics output; 2) Handle cross-platform compatibility, use cross-platform graphics libraries such as SDL or Qt; 3) Perform performance optimization, improve performance through cache, hardware acceleration, and dynamic adjustment of the details level; 4) Solve common problems, such as blurred text and interface elements are too small, and solve by correctly applying DPI scaling.

DMA in C refers to DirectMemoryAccess, a direct memory access technology, allowing hardware devices to directly transmit data to memory without CPU intervention. 1) DMA operation is highly dependent on hardware devices and drivers, and the implementation method varies from system to system. 2) Direct access to memory may bring security risks, and the correctness and security of the code must be ensured. 3) DMA can improve performance, but improper use may lead to degradation of system performance. Through practice and learning, we can master the skills of using DMA and maximize its effectiveness in scenarios such as high-speed data transmission and real-time signal processing.

macOSandLinuxbothofferuniquestrengths:macOSprovidesauser-friendlyexperiencewithexcellenthardwareintegration,whileLinuxexcelsinflexibilityandcommunitysupport.macOS,developedbyApple,isknownforitssleekinterfaceandecosystemintegration,whereasLinux,beingo

In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.
