LAMP搭建1：MySQL安装
LAMP（Linux，Apache，MySQL，PHP简称）。1.进入/usr/local/src/目录下载免编译二进制安装包mysql-5.1.49-linux-i686-glibc23.tar.gz：
# cd /usr/local/src
# ls
mysql-5.1.49-linux-i686-glibc23.tar.gz
2.解压下载的安装包：
# tar zxvf mysql-5.1.49-linux-i686-glibc23.tar.gz
3.创建mysql用户，-s不允许登录，-M不创建家目录
# useradd -s /sbin/nologin -M mysql
4.将解压后的目录移动到/usr/local/下并重命名为mysql
# mv mysql-5.1.49-linux-i686-glibc23 /usr/local/mysql
5.进入安装目录 /usr/local/mysql/
# cd /usr/local/mysql/
#
6.创建一个目录存放mysql的数据，并更改其权限
# mkdir -p /data/mysql
# chown -R mysql /data/mysql
7.初始化库，出现两个OK证明初始化成功，也可以使用命令echo $?查看是否成功
# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
……
Installing MySQL system tables...
OK
Filling help tables...
OK
……
# echo $?
0
8.将配置文件support-files/my-large.cnf拷贝到/etc目录下并重命名my.cnf，如果已存在请覆盖
# cd support-files/
# ls
binary-configure my-huge.cnf mysqld_multi.server
config.huge.ini my-innodb-heavy-4G.cnfmysql-log-rotate
config.medium.inimy-large.cnf mysql.server
config.small.ini my-medium.cnf ndb-config-2-node.ini
magic my-small.cnf
# cp my-large.cnf /etc/my.cnf
cp：是否覆盖"/etc/my.cnf"？ y
9.编辑配置文件
# 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> # defaults to 1 if master-host is not set
# but will not function as a master if omitted
#server-id = 1
……
11.拷贝启动脚本到指定目录并重命名，打开编辑内容
# cp mysql.server /etc/init.d/mysqld
# vim /etc/init.d/mysqld
12.编辑内容保存退出
……
basedir=/usr/local/mysql
datadir=/data/mysql
……
13.加入到启动列表并设为开机启动
# chkconfig --add mysqld
# chkconfig mysqld on
14.将MySQL加入环境变量
# vim /etc/profile.d/path.sh
#!/bin/bash
export PATH=$PATH:/etc/init.d/:/usr/local/mysql/bin/
# source /etc/profile.d/path.sh
15.启动MySQL
# mysqld start
Starting MySQL.. SUCCESS!
16.查看MySQL进程
# ps aux |grep mysql
root 12990.00.0 66801320 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 13990.92.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 14180.00.0 5980 748 pts/0 S+ 06:44 0:00 grep mysqld
页:
[1]