安装mysql

一、实验环境
在Linux系统中安装mysql

二、操作脚本

1.光盘挂载

cd /mnt

ls

mount /dev/cdrom /mnt

2.建立yum仓库

cd /etc/yum.repos.d/

vim aaa.repo

> [aaa]

> name=test

> baseurl=file:///mnt

> enabled=1

> gpgcheck=0

ls

rm -rf rhel-source.repo

yum list

3.共享挂载

mkdir /opt/lamp

smbclient -L //192.168.119.2/

mount.cifs //192.168.119.2/john /opt/lamp

4.文件的解压缩

cd /opt/lamp

tar zxvf mysql-5.5.24.tar.gz -C /opt

5.安装环境包

yum install gcc gcc-c++ make cmake -y

rpm -ivh /mnt/Packages/ncurses-devel-5.7-3.20090208.el6.x86_64.rpm

rpm -ivh /mnt/Packages/bison-2.4.1-5.el6.x86_64.rpm

rpm -ivh /mnt/Packages/libaio-devel-0.3.107-10.el6.x86_64.rpm

6.添加mysql用户并加入到mysql组

useradd -s /sbin/nologin mysql

mkdir -p /usr/local/mysql

7.编译安装

cd /opt/mysql-5.5.24

cmake -DCMAKE_INSTALL_preFIX=/usr/local/mysql
-DMYSQL_UNIX_ADDR=/home/mysql/mysql.sock
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_EXTRA_CHARSETS=all
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_READLINE=1
-DENABLED_LOCAL_INFILE=1
-DMYSQL_DATADIR=/home/mysql
-DMYSQL_USER=mysql
-DMYSQL_TCP_PORT=3306

make && make install

8.递归复制

chown -R mysql.mysql /usr/local/mysql

9.开机时刷新

export PATH=$PATH:/usr/local/mysql/bin/

10.复制配置文件

cp support-files/my-medium.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld

11.增加文件执行权限

chmod 755 /etc/init.d/mysqld

12.添加并启动mysqld服务

chkconfig --add /etc/init.d/mysqld

chkconfig mysqld --level 35 on

13.初始化数据库

/usr/local/mysql/scripts/mysql_install_db \
--user=mysql \
--ldata=/var/lib/mysql \
--basedir=/usr/local/mysql \
--datadir=/home/mysql

14.建立软链接

ln -s /var/lib/mysql/mysql.sock /home/mysql/mysql.sock

15.修改配置文件

vim /etc/init.d/mysqld

> basedir=/usr/local/mysql

> datadir=/home/mysql

16.开启mysqld服务并验证

service mysqld start

netstat -tnl 3306

cd /opt/mysql-5.5.24

mysql

show databases;

三、实验步骤示图

四、实验结果

结果表明：mysql安装成功，如下图