Mysql之单实例安装&PHP安装

1.安装准备
下载好软件
2.建立MySql帐号

[root@xiaoyu ~]# groupadd mysql 创建用户组
[root@xiaoyu ~]# useradd mysql -g mysql -M -s /sbin/nologin 创建用户，-g 属于mysql组，-M 不创建家目录，-s /sbin/nologin 不登陆

3.解压

[root@xiaoyu ~]# tar zxvf soft/mysql-5.1.72.tar.gz 

4.安装配置

./configure \
--prefix=/application/mysql5.1.72 \
--with-unix-socket-path=/application/mysql5.1.72/tmp/mysql.sock \
--localstatedir=/application/mysql5.1.72/data \
--enable-assembler \
--enable-thread-safe-client \
--with-mysqld-user=mysql \
--with-big-tables \
--without-debug \
--with-pthread \
--enable-assembler \
--with-extra-charsets=complex \
--with-readline \
--with-ssl \
--with-embedded-server \
--enable-local-infile \
--with-plugins=partition,innobase \
--with-mysqld-ldflags=-all-static \
--with-client-ldflags=-all-static 
上述内容保存成mysql.log文件
cat /root/mysql.log | bash

5.安装 make;make install
6.初始化数据库

[root@xiaoyu support-files]# ls -al *.cnf
-rw-r--r--. 1 root root  4746 Jun 17 07:59 my-huge.cnf
-rw-r--r--. 1 root root 19779 Jun 17 07:59 my-innodb-heavy-4G.cnf
-rw-r--r--. 1 root root  4720 Jun 17 07:59 my-large.cnf
-rw-r--r--. 1 root root  4731 Jun 17 07:59 my-medium.cnf
-rw-r--r--. 1 root root  2499 Jun 17 07:59 my-small.cnf
[root@xiaoyu support-files]# cp my-small.cnf /etc/my.cnf   初始化配置文件
[root@xiaoyu support-files]# mkdir  /application/mysql/data -p 创建数据存放目录
[root@xiaoyu support-files]# chown -R mysql.mysql /application/mysql/ 更改权限
初始化：
[root@xiaoyu support-files]# /application/mysql/bin/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data/ --user=mysql
WARNING: The host 'xiaoyu' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
170617  8:56:44 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
OK
Filling help tables...
170617  8:56:44 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/application/mysql/bin/mysqladmin -u root password 'new-password'
/application/mysql/bin/mysqladmin -u root -h xiaoyu password 'new-password'

Alternatively you can run:
/application/mysql/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /application/mysql ; /application/mysql/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /application/mysql/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /application/mysql/scripts/mysqlbug script!

7.复制启动脚本到启动目录

[root@xiaoyu mysql-5.1.72]# cp  support-files/mysql.server.sh /etc/init.d/mysqld 
[root@xiaoyu init.d]# chkconfig --add mysqld  设置开机启动
[root@xiaoyu init.d]# chkconfig mysqld on

直接启动：
添加PATH="/application/mysql/bin/:$PATH"

[root@xiaoyu init.d]# vim /etc/profile
[root@xiaoyu init.d]# source /etc/profile

8.修改init.d/mysqld ，让该启动方式生效

basedir=/application/mysql/
datadir=/application/mysql/data

9.为PHP安装做准备

yum install zlib libxml libjpeg freetype libpng gd  curl libiconv  zlib-devel libxml2-devel libjpeg-devel freetype-devel libpng-devel gd-devel curl-devel -y 安装php用到的库
配置php
./configure --prefix=/application/php5.3.27 --with-apxs2=/application/apache/bin/apxs --with-mysql=/application/mysql --with-xmlrpc --with-openssl \
> --with-zlib --with-freetype-dir --with-gd --with-jpeg-dir \
> --enable-short-tags --enable-sockets --enable-zend-multibyte --enable-soap \
> --enable-mbstring --enable-static --enable-gd-native-ttf \
> --with-curl --with-xsl --enable-ftp --with-libxml-dir

表示配置成功

+--------------------------------------------------------------------+
| License:                                                           |
| This software is subject to the PHP License, available in this     |
| distribution in the file LICENSE.  By continuing this installation |
| process, you are bound by the terms of this license agreement.     |
| If you do not agree with the terms of this license, you must abort |
| the installation process at this point.                            |
+--------------------------------------------------------------------+

Thank you for using PHP.
make&make install