LAMP搭建1：MySQL安装

34212131

                      LAMP（Linux，Apache，MySQL，PHP简称）。
1.进入/usr/local/src/目录下载免编译二进制安装包mysql-5.1.49-linux-i686-glibc23.tar.gz：
[iyunv@CentOS6 ~]# cd /usr/local/src
[iyunv@CentOS6 src]# ls
mysql-5.1.49-linux-i686-glibc23.tar.gz
2.解压下载的安装包：
[iyunv@CentOS6 src]# tar zxvf mysql-5.1.49-linux-i686-glibc23.tar.gz
3.创建mysql用户，-s不允许登录，-M不创建家目录
[iyunv@CentOS6 src]# useradd -s /sbin/nologin -M mysql
4.将解压后的目录移动到/usr/local/下并重命名为mysql
[iyunv@CentOS6 src]# mv mysql-5.1.49-linux-i686-glibc23 /usr/local/mysql
5.进入安装目录 /usr/local/mysql/
[iyunv@CentOS6 src]# cd /usr/local/mysql/
[iyunv@CentOS6 mysql]#
6.创建一个目录存放mysql的数据，并更改其权限
[iyunv@CentOS6 mysql]# mkdir -p /data/mysql
[iyunv@CentOS6 mysql]# chown -R mysql /data/mysql
7.初始化库，出现两个OK证明初始化成功，也可以使用命令echo $?查看是否成功
[iyunv@CentOS6 mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
……
Installing MySQL system tables...
OK
Filling help tables...
OK
……
[iyunv@CentOS6 src]# echo $?
0
8.将配置文件support-files/my-large.cnf拷贝到/etc目录下并重命名my.cnf，如果已存在请覆盖
[iyunv@CentOS6 mysql]# cd support-files/
[iyunv@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
[iyunv@CentOS6 support-files]# cp my-large.cnf /etc/my.cnf
cp：是否覆盖"/etc/my.cnf"？ y
9.编辑配置文件
[iyunv@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.拷贝启动脚本到指定目录并重命名，打开编辑内容
[iyunv@CentOS6 support-files]# cp mysql.server /etc/init.d/mysqld
[iyunv@CentOS6 support-files]# vim /etc/init.d/mysqld
12.编辑内容保存退出
……
basedir=/usr/local/mysql
datadir=/data/mysql
……
13.加入到启动列表并设为开机启动
[iyunv@CentOS6 support-files]# chkconfig --add mysqld
[iyunv@CentOS6 support-files]# chkconfig mysqld on
14.将MySQL加入环境变量
[iyunv@CentOS6 support-files]# vim /etc/profile.d/path.sh
#!/bin/bash
export PATH=$PATH:/etc/init.d/:/usr/local/mysql/bin/
[iyunv@CentOS6 support-files]# source /etc/profile.d/path.sh
15.启动MySQL
[iyunv@CentOS6 support-files]# mysqld start
Starting MySQL.. SUCCESS!
16.查看MySQL进程
[iyunv@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