安裝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安裝成功，如下圖