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