mysql 5.5安裝

標籤：mysql5.5   cmake

1、安裝mysql5.5及5.5以上版本需要安裝cmake

  1）下載cmake

         wget --no-check-certificate http://www.cmake.org/files/v2.8/cmake-2.8.7.tar.gz

  2）解壓編譯安裝

         先安裝所依賴的包：

         yum -y install gcc*

         tar zvxf cmake-2.8.7.tar.gz

         cd cmake-2.8.7

         ./configure

         make && make install

2、安裝mysql

  1）下載mysql

         wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.47.tar.gz

  2）建立mysql使用者與使用者組

         groupadd mysql

         useradd -g mysql mysql

  3）解壓安裝

         tar zvxf mysql-5.5.47.tar.gz

          cd mysql-5.5.47

         使用cmake編譯：

         cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

         -DMYSQL_DATADIR=/mysql/data \

         -DDEFAULT_CHARSET=utf8 \

         -DDEFAULT_COLLATION=utf8_general_ci \

         -DWITH_EXTRA_CHARSETS:STRING=all \

         -DWITH_DEBUG=0 \

         -DWITH_SSL=yes \

         -DWITH_READLINE=1 \

         -DENABLED_LOCAL_INFILE=1

         make && make install

  4）產生新的mysql許可權表

         mkdir -p /mysql/data

         ./scripts/mysql_install_db --user=mysql  -datadir=/mysql/data

         #此處如不指定datadir，到啟動時會報錯

  5)使用權限設定

         cd /usr/local/mysql

         chown -R mysql:mysql  /usr/local/mysql

         chown -R root .

         chown -R mysql data

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

         /usr/local/mysql/bin/mysqld_safe --user=mysql &

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

         chmod +x /etc/init.d/mysqld

         /etc/init.d/mysqld start

  6)驗證

         /usr/local/mysql/bin/mysql

         Select @@version

本文出自 “Linux” 部落格，請務必保留此出處http://syklinux.blog.51cto.com/9631548/1759080

mysql 5.5安裝