CentOS5 + apache + mysql + php configuration

1. Install Mysql
1. Create an msyql User Group
[Root @ localhost ~] # Grep mysql/etc/group
# Check whether the user group mysql exists in the query system. If no user group exists, add it.
[Root @ localhost ~] # Groupadd mysql
# Add a user group named mysql
2. Create a mysql user
[Root @ localhost ~] # Grep mysql/etc/passwd
# Check whether the user mysql exists in the query system. If the user does not exist, add the user.
[Root @ localhost ~] # Useradd mysql-g mysql-M-s/sbin/nologin
# Add a user named mysql.
-G: Specifies the user group to which the new user belongs)
-M: do not create a root directory
-S: defines the shell it uses./sbin/nologin indicates that the user cannot log on to the system.
3. decompress: mysql
[Root @ localhost ~] # Cd/usr/local/src/
[Root @ localhost src] # tar-zxvf mysql-5.0.27.tar.gz
#...... (Omitted information )......
# Decompress
3. Set compiler compilation Parameters
[Root @ localhost src] # cd/usr/local/src/mysql-5.0.27
[Root @ localhost mysql-5.0.27] #. /configure -- prefix =/usr/local/mysql -- with-unix-socket-path =/tmp/mysql. sock -- localstatedir =/usr/local/mysql/data -- with-charset = gbk -- without-debug -- enable-handler er -- without-isam -- with-client-ldflags =-all- static -- with-mysqld-ldflags =-all-static
# These settings tell the compiler how to compile apache:
-Prefix =/usr/local/mysql
Specify the msyql installation directory
-With-unix-socket-path =/tmp/mysql. sock
This specifies the location and file name of the online socket file after the mysql server is started.
-Localstatedir =/usr/local/mysql/data
Specify the mysql database directory
-With-charset = gbk
Added support for gbk Chinese Characters
-Without-debug
Remove debug mode
-Enable-Cycler
Use the assembly version of some character Functions
-Without-isam
Removed the isam table type support and is rarely used now. The isam table is a platform-dependent table.
-With-client-ldflags =-all-static
-With-mysqld-ldflags =-all-static
4. Compile and install
[Root @ localhost mysql-5.0.27] # make
# The "make" command compiles the source file into executable binary files.
[Root @ localhost mysql-5.0.27] # make install
# "Make install" install binary files and configuration files in the appropriate directory
6. initialize the system library
[Root @ localhost mysql-5.0.27] #./scripts/mysql_install_db
7. other settings
[Root @ localhost mysql-5.0.27] # cp support-files/my-medium.cnf/etc/my. cnf-fv
# Note:
-F: delete a file or directory with the same name in the target without any prompt.
# There are some other my. cnf configuration files. Suitable for different application scales. The type is my-*. cnf. Cp according to your needs.
[Root @ localhost mysql-5.0.27] # cp support-files/mysql. server/etc/init. d/mysqld
# Add to startup script
[Root @ localhost mysql-5.0.27] # chmod 700/etc/init. d/mysqld
[Root @ localhost mysql-5.0.27] # cd/usr/local
[Root @ localhost local] # chmod 750 mysql-R
# Note:
-R recursively changes the permissions of directories and their contents.
[Root @ localhost local] # chown-R mysql. mysql/usr/local/mysql
# Set the owner. mysql runs as a mysql user during startup, which improves system security.
[Root @ localhost local] # chown-R mysql. mysql/usr/local/mysql/data
[Root @ localhost local] # cd/usr/local/mysql/libexec
[Root @ localhost libexec] # cp mysqld. old
[Root @ localhost libexec] # strip mysqld
[Root @ localhost libexec] # chkconfig-add mysqld
# Add a service. You can also manually add the service.
[Root @ localhost libexec] # chkconfig-level 345 mysqld on
# Set start at startup
[Root @ localhost libexec] # service mysqld start
# Start the mysql Service
[Root @ localhost libexec] # ln-s/usr/local/mysql/bin/mysql/sbin/mysql
[Root @ localhost libexec] # ln-s/usr/local/mysql/bin/mysqladmin/sbin/mysqladmin
[Root @ localhost libexec] # ln-s/usr/local/mysql/bin/mysqldump/sbin/mysqldump
[Root @ localhost libexec] # mysqladmin-uroot password "youpassword"
# Set the password for the root account
[Root @ localhost libexec] # mysql-uroot-p
# Enter your password
Mysql> use mysql;
Mysql> delete from user where password = "";
# Delete an empty password account used for anonymous connection to the Local Machine
Mysql> flush privileges;
Mysql> show databases;
+ ---- +
| Database |
+ ---- +
| Mysql |
| Test |
+ ---- +
2 rows in set (0.08 sec)
# Display the database and test whether mysql is installed normally.
Mysql> quit

If you forget your password, you can:
My system is linux. The newly installed mysql always has an error prompt when it comes to the mysql tool:
# Mysql-uroot-p
Enter password:
ERROR 1045 (28000): Access denied for user [email =] root @ localhost [/email] (using password: NO)
Use the methods described on the Internet to change the password of the root user:
# Mysqladmin-uroot-p password newpassword
Enter password:
Mysqladmin: connect to server at localhost failed
Error: Access denied for user [email =] root @ localhost [/email] (using password: YES)
Now I have found the solution as follows (Please test method 3 first, thank you !) :
Method 1:
#/Etc/init. d/mysql stop
# Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking &
# Mysql-u root mysql
Mysql> UPDATE user SET Password = PASSWORD (newpassword) where USER = root;
Mysql> flush privileges;
Mysql> quit
#/Etc/init. d/mysql restart
# Mysql-uroot-p
Enter password: <Enter the new password newpassword>

Ii. install Apache
1. Download: apache
[Root @ localhost src] # chmod + x httpd-2.2.8.tar.gz
[Root @ localhost src] # tar-zxvf httpd-2.2.8.tar.gz
3) set compiler compilation Parameters
[Root @ localhost src] # cd httpd-2.2.8
[Root @ localhost httpd-2.2.8] #./configure-prefix =/usr/local/apache2-enable-module = so
4) Compilation and installation:
[Root @ localhost httpd-2.2.8] # make; make install
# If no error occurs, Apache is installed in the/usr/local/apache2 directory.
3. Start the service:
[Root @ localhost httpd-2.2.8] #/usr/local/apache2/bin/apachectl start
4. Confirm the startup status:
[Root @ localhost apache2] # netstat-utl
Tcp 0 0 *: http *: * LISTEN
# If you see this line, your Apache has been started.
# Access It works in a browser !, It indicates that apache has been installed successfully. Congratulations!

3. install PHP
1. Prepare the directory:
Mkdir/usr/local/modules
# Jpeg directory
Mkdir/usr/local/modules 6
Mkdir/usr/local/modules 6/bin
Mkdir/usr/local/modules 6/lib
Mkdir/usr/local/modules 6/include
Mkdir/usr/local/modules 6/man
Mkdir/usr/local/modules 6/man/man1
2. Install zlib
# Tar xzvf zlib-1.2.3.tar.gz
# Music zlib-1.2.3/usr/local/src/
# Cd/usr/local/src/zlib-1.2.3
Do not use -- prefix to customize the installation directory, which affects gd installation.
#./Configure
# Make & make install
3. Install freetype
# Tar xzvf freetype-2.3.5.tar.bz2
# Music freetype-2.3.5/usr/local/src/
# Cd/usr/local/src/freetype-2.3.5
#./Configure -- prefix =/usr/local/modules/freetype
# Make & make install
4. Install libpng
# Tar jxvf libpng-1.2.20.tar.bz2
Do not use -- prefix to customize the installation directory, which affects gd installation.
# Music libpng-1.2.20/usr/local/src/
# Cd/usr/local/src/libpng-1.2.5
# Cp scripts/makefile. std makefile
# Make test
# Make install
5. Install jpeg
# Tar xzvf restart src.v6b.tar.gz
# Music jpeg-6b/usr/local/src/
# Cd/usr/local/src/jpeg-6b
#./Configure -- prefix =/usr/local/modules 6 -- enable-shared -- enable-static
# Ma