Shulou(Shulou.com)06/01 Report--

1. Download the binary Mysql installation package from http://www.mysql.com / / this MYSQL is binary and does not need to be compiled [@ more@]

2. # chmod 755 mysql-standard-5.0.15-linux-gnu-i686-glibc23.tar.gz

/ /

3. # tar xfz mysql-standard-5.0.15-linux-gnu-i686-glibc23.tar.gz / / copy the extracted directory to / usr/local/ and rename it to mysql

4. # groupadd mysql / / establish a mysql group

# useradd mysql-g mysql / / establish a mysql user and join the mysql group

5. # cp / usr/local/mysql/support-files/my-medium.cnf / etc/my.cnf

There are four template files in the support-files directory. We select one of the seat Mysql configuration files and overwrite / etc/my.cnf (the default configuration of the system, which sets performance parameters and some path parameters of Mysql).

6. # cd / usr/local/mysql / / enter the mysql directory

#. / scripts/mysql_install_db-- user=mysql / / debug the table and specify access by mysql users. After initializing the table, you start to set access rights for mysql and root users.

7. # chown-R root. / / set root to access / usr/local/mysql

8. # chown-R mysql data / / set mysql users to access / usr/local/mysql/data, which contains mysql database files. This directory is configured in / etc/my.cnf and is generated during mysql_install_db.

9. # chown-R mysql data/. / / set mysql users to access all files under / usr/local/mysql/data/mysql

10. # chgrp-R mysql. / / set the mysql group to access / usr/local/mysql

11. # / usr/local/mysql/bin/mysqld_safe-user=mysql &

Run mysql

If there is no problem, there should be a prompt like this:

[1] 42264

# Starting mysqld daemon with databases from / usr/local/mysql/var

If there is a statement like mysql ended, which means that Mysql is not starting properly, you can find the problem in log. The Log file is usually configured in / etc/my.cnf. Most of the problems are caused by incorrect permission settings.

twelve。 Change the MYSQL password with the following command

# / usr/local/mysql/bin/mysqladmin-u root password yourpassword / / the default installation password is empty, which you must modify immediately for security.

13. # cp support-files/mysql.server / etc/rc.d/init.d/mysqld

# chmod 700 / etc/init.d/mysqld

# chkconfig-add mysqld

# chkconfig-- A script in the level 345 mysqld on / / copy compilation directory

/ / set mysql to run automatically every time it starts

14. # service mysqld start / / start the mysqld service

# netstat-atln / / check whether port 3306 is open. Note that the port is open in the firewall.

two。 What I am talking about here is to use DSO dynamic compilation method to compile Apache.

As for the compilation method of apache, you can refer to my previous article "Application of static / dynamic compilation of apache in apache+php+mysql" http://www.5ilinux.com/apache01.html

Software acquisition: http://httpd.apache.org/

Tar zvxf apache_1.3.29.tar.gz

Cd apache_1.3.29

Modify src/include/httpd.h to increase the maximum number of threads

# define HARD_SERVER_LIMIT 256

Change to

# define HARD_SERVER_LIMIT 2560

Save exit compile apache

. / configure-prefix=/usr/local/apache4-enable-module=so-enable-module=rewrite-enable-shared=max

Make & &

Make install

# here we tell the setup script through the enable-module parameter that we need to start the so and rewrite modules. The so module is used to mention the apache core module supported by DSO, while the rewrite module is intended to implement address rewriting. Because the rewrite module needs DBM support, if it is not compiled into apache during the initial installation, you need to recompile the entire apache later when you need it. For this reason, unless you are sure that the rewrite module will not be used in the future, it is recommended that you compile the rewrite module the first time you compile.

When compiling apache with the function of the parameter enable-shared=max, all standard modules of apache except so are compiled into DSO modules. Instead of compiling into the apache core.

All right, it's easy to install apache. Start apache.

-s

/ usr/local/apache/bin/apachectl start

Then use ie to see http:// your server address. You should be able to see the familiar apache feather logo.

Vi / usr/local/apache/conf/httpd.conf

Find

Add in this range

AddType application/x-httpd-php .php

AddType application/x-httpd-php-source .phps

/ configure-- prefix=/usr/local/php-- with-apxs2=/usr/local/apache4/bin/apxs-- with-mysql=/usr/local/mysql-- enable-track-vars-- with-xml-- with-MySQL

Make

Make install

# because the server needs to use the GD library, I have added some compilation parameters that support GD. GD directly uses the GD library that comes with redhat. If you do not install it, you can install it from the installation disk. Note that in addition to installing GD, you also need to install libjpeg,libpng and other library files. In addition-- with-mysql=/usr/local/mysql points to the path where you installed mysql. -- the path that with-apxs points to apache's apxs file.

But the configuration file of CPOPY PHP

Cp.. / php4.3.4/php.ini.dist / usr/local/php/lib/php.ini

Modify the php.ini file

Register_globals = On

Ok! Restart the apache server

/ usr/local/apache/bin/apachectl restart

Then write a php test page info.php: the content is as follows

Normally, you should be able to see the message of php. Congratulations on your successful Apche+Mysql+PHP installation.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.