LAMP(Linux,Apache,MySQL,PHP简称)。

1.进入/usr/local/src/目录下载免编译二进制安装包mysql-5.1.49-linux-i686-glibc23.tar.gz:

[root@CentOS6 ~]# cd /usr/local/src

[root@CentOS6 src]# ls

mysql-5.1.49-linux-i686-glibc23.tar.gz

2.解压下载的安装包:

[root@CentOS6 src]# tar zxvf mysql-5.1.49-linux-i686-glibc23.tar.gz

3.创建mysql用户,-s不允许登录,-M不创建家目录

[root@CentOS6 src]# useradd -s /sbin/nologin -M mysql

4.将解压后的目录移动到/usr/local/下并重命名为mysql

[root@CentOS6 src]# mv mysql-5.1.49-linux-i686-glibc23 /usr/local/mysql

5.进入安装目录 /usr/local/mysql/

[root@CentOS6 src]# cd /usr/local/mysql/

[root@CentOS6 mysql]#

6.创建一个目录存放mysql的数据,并更改其权限

[root@CentOS6 mysql]# mkdir -p /data/mysql

[root@CentOS6 mysql]# chown -R mysql /data/mysql

7.初始化库,出现两个OK证明初始化成功,也可以使用命令echo $?查看是否成功

[root@CentOS6 mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql

……

Installing MySQL system tables...

OK

Filling help tables...

OK

……

[root@CentOS6 src]# echo $?

0

8.将配置文件support-files/my-large.cnf拷贝到/etc目录下并重命名my.cnf,如果已存在请覆盖

[root@CentOS6 mysql]# cd support-files/

[root@CentOS6 support-files]# ls

binary-configure   my-huge.cnf             mysqld_multi.server

config.huge.ini    my-innodb-heavy-4G.cnf  mysql-log-rotate

config.medium.ini  my-large.cnf            mysql.server

config.small.ini   my-medium.cnf           ndb-config-2-node.ini

magic              my-small.cnf

[root@CentOS6 support-files]# cp my-large.cnf /etc/my.cnf

cp:是否覆盖"/etc/my.cnf"? y

9.编辑配置文件

[root@CentOS6 mysql]# vim /etc/my.cnf

10.注释掉其中的三行,暂时用不到

……

# Replication Master Server (default)

# binary logging is required for replication

#log-bin=mysql-bin

# binary logging format - mixed recommended

#binlog_format=mixed

# required unique id between 1 and 2^32 - 1

# defaults to 1 if master-host is not set

# but will not function as a master if omitted

#server-id      = 1

……

11.拷贝启动脚本到指定目录并重命名,打开编辑内容

[root@CentOS6 support-files]# cp mysql.server /etc/init.d/mysqld

[root@CentOS6 support-files]# vim /etc/init.d/mysqld

12.编辑内容保存退出

……

basedir=/usr/local/mysql

datadir=/data/mysql

……

13.加入到启动列表并设为开机启动

[root@CentOS6 support-files]# chkconfig --add mysqld

[root@CentOS6 support-files]# chkconfig mysqld on

14.将MySQL加入环境变量

[root@CentOS6 support-files]# vim /etc/profile.d/path.sh

#!/bin/bash

export PATH=$PATH:/etc/init.d/:/usr/local/mysql/bin/

[root@CentOS6 support-files]# source /etc/profile.d/path.sh

15.启动MySQL

[root@CentOS6 support-files]# mysqld start

Starting MySQL.. SUCCESS!

16.查看MySQL进程

[root@CentOS6 support-files]# ps aux |grep mysql

root      1299  0.0  0.0   6680  1320 pts/0    S    06:42   0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/CentOS6.5two.pid

mysql     1399  0.9  2.3 392140 45040 pts/0    Sl   06:42   0:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --user=mysql --log-error=/data/mysql/CentOS6.5two.err --pid-file=/data/mysql/CentOS6.5two.pid --socket=/tmp/mysql.sock --port=3306

root      1418  0.0  0.0   5980   748 pts/0    S+   06:44   0:00 grep mysqld