Linux下MySQL的幾種安裝方式

標籤：mysql安裝、編譯、cmake、源碼、linux

   閑來有空，整理下Linux下Mysql的幾種安裝方式，分別使用yum/rpm、常規方式編譯安裝、cmake方式編譯安裝以及使用二進位方式免編譯安裝MySQL

Linux系統內容：

CentOS release 6.5 (Final) x86_64

MySQL版本：5.5.45

安裝前關閉了iptables、selinux為disabled

預先安裝以下包：

yum groupinstall "debugging Tools" "Dial-up Networking Support" -y

yum groupinstall "Compatibility libraries" "Base" "Development tools" -y

yum install tree nmap sysstat lrzsz dos2unix -y  (一些常用的工具包)

yum install ncurses-devel -y

一.yum方式安裝

二.rpm方式安裝

三.常規方式編譯安裝

四.cmake方式編譯安裝

下載cmake包和mysql源碼包

[[email protected] ~] wget http://www.cmake.org/files/v2.8/cmake-2.8.8.tar.gz

[[email protected] ~] wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.45.tar.gz

添加mysql使用者以及組

[[email protected] soft]# groupadd mysql

[[email protected] soft]# useradd mysql -s /sbin/nologin -M -g mysql

[[email protected] soft]# tar -zxvf cmake-2.8.8.tar.gz 

[[email protected] soft]# cd cmake-2.8.8

[[email protected] cmake-2.8.8]# ./configure 

[[email protected] cmake-2.8.8]# gmake

查看是否成功

[[email protected] cmake-2.8.8]# echo $?

0

[[email protected] cmake-2.8.8]# gmake install

[[email protected] cmake-2.8.8]# echo $?

0

[[email protected] cmake-2.8.8]# cd ..

[[email protected] soft]# cd mysql-5.5.45

[[email protected] ~]# mkdir /app

[[email protected] soft]# tar -zxvf mysql-5.5.45.tar.gz 

[[email protected] soft]# cd mysql-5.5.45

cmake編譯，詳細參數見xxx

[[email protected] mysql-5.5.45]# cmake . -DCMAKE_INSTALL_PREFIX=/app/mysql-5.5.45 \

-DMYSQL_DATADIR=/app/mysql-5.5.45/data \

-DMYSQL_UNIX_ADDR=/app/mysql-5.5.45/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DEFAULT_CHARSET=gbk,gb2312,utf8,ascii \

-DENABLED_LOCAL_INFILE=ON \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \

-DWITH_FAST_MUTEXES=1 \

-DWITH_ZLIB=bundled \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_READLINE=1 \

-DWITH_EMBEDDED_SERVER=1 \

-SWITH_DEBUG=0

[[email protected] mysql-5.5.45]# echo $?

0

[[email protected] mysql-5.5.45]# make && make install

[[email protected] mysql-5.5.45]# echo $?

0

建立軟串連

[[email protected] mysql-5.5.45]# ln -s /app/mysql-5.5.45/ /app/mysql

拷貝設定檔到/etc下

[[email protected] mysql-5.5.45]# cp support-files/my-small.cnf /etc/my.cnf

添加環境變數到/etc/profile

[[email protected] mysql-5.5.45]# echo ‘export PATH=/app/mysql-5.5.45/bin:$PATH‘ >> /etc/profile

[[email protected] mysql-5.5.45]# source /etc/profile

[[email protected] mysql-5.5.45]# echo $PATH

修改資料目錄屬屬組

[[email protected] mysql-5.5.45]# chown -R mysql.mysql /app/mysql/data/

[[email protected] mysql-5.5.45]# chmod -R 1777 /tmp/

初始化資料庫，資料庫的初始化就是生產mysql的一些基本表，類似oracle的基表...

[[email protected] mysql-5.5.45]# cd /app/mysql/scripts/

[[email protected] scripts]# ./mysql_install_db --basedir=/app/mysql/ --datadir=/app/mysql/data/ --user=mysql

拷貝開機檔案到init.d下，並且添加可執行許可權

[[email protected] ~]# cd /soft/mysql-5.5.45/support-files

[[email protected] support-files]# cp mysql.server /etc/init.d/mysqld

[[email protected] support-files]# chmod +x /etc/init.d/mysqld

啟動資料庫

[[email protected] ~]# /etc/init.d/mysqld start

Starting MySQL... SUCCESS! 

[[email protected] ~]# netstat -lntup |grep 3306

給資料庫添加密碼並驗證

[[email protected] ~]# /app/mysql//bin/mysqladmin -u root password ‘rootroot‘

[[email protected] ~]# mysql -uroot -prootroot

mysql> show databases ;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test               |

+--------------------+

五.二進位方式免編譯安裝

未完待續...

本文出自 “相守姑娘說” 部落格，請務必保留此出處http://sugarlovecxq.blog.51cto.com/6707742/1695750

Linux下MySQL的幾種安裝方式