一：編譯mysql

????useradd -M -s /sbin/nologin mysql????????????????#創建mysql用戶

????yum -y install cmake????????????????????????????#安裝cmake

????tar zxvf mysql-5.5.22.tar.gz????????????????????#解壓mysql源碼包

????cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -????????????DDEFAULT_CHARSET=utf8 ?-DDEFAULT_COLLATION=utf8_general_ci ?-DWITH_EXTRA_CHARSETS=all????????????#配置mysql編譯參數

????make?????????????????????????????????#編譯?

????make install ????????????????????????#安裝mysql

二：初始化mysql

????chown ?-R ?mysql:mysql ?/usr/local/mysql????????????#修改mysql目錄屬主

????ln -s /usr/local/mysql/bin/* /usr/local/bin????????????#創建命令鏈接

????cp ?/usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf????#復制配置文件

????cp ?/usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld????????#復制啟動腳本

????chmod +x /etc/init.d/mysqld????????????#賦予執行權限

????/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data????????????????#初始化

????????初始化參數說明：

????????????--user：指定mysql的程序用戶

????????????--basedi：指定mysql的主目錄

????????????--datadir：指定mysql的數據庫目錄

????service mysqld start????????#啟動mysql

三：常用編譯參數

????-DCMAKE_INSTALL_PREFIX=/usr/local/mysql ????? ?#指定安裝目錄?

????-DMYSQL_DATADIR=/usr/local/mysql/data? ?????#指定數據庫存放目錄

????-DSYSCONFDIR=/etc? ????????#指定mysql配置文件

????-DDEFAULT_CHARSET=utf8 ?? #使用utf8字符?

????-DDEFAULT_COLLATION=utf8_general_ci? #校驗字符?

????-DEXTRA_CHARSETS=all ? #安裝額外的編碼集

????-DWITH_MYISAM_STORAGE_ENGINE=1? #安裝 myisam 存儲引擎?

????-DWITH_INNOBASE_STORAGE_ENGINE=1? #安裝 innodb 存儲引擎?

????-DWITH_ARCHIVE_STORAGE_ENGINE=1? #安裝 archive存儲引擎?

????-DWITH_BLACKHOLE_STORAGE_ENGINE=1? #安裝 blackhole存儲引擎?

????-DENABLED_LOCAL_INFILE=1? #允許從本地導入數據?

?????-DMYSQL_TCP_PORT=3306? #MySQL 監聽端口?

????-DMYSQL_USER=mysql? #MySQL 用戶名 ?

????-DWITH_SSL=yes? #SSL?

????-DWITH_MEMORY_STORAGE_ENGINE=1? #安裝 memory 存儲引擎?

????-DWITH_FEDERATED_STORAGE_ENGINE=1? #安裝 frderated 存儲引擎?

????-DINSTALL_PLUGINDIR=/usr/local/mysql/plugin #插件文件及配置路徑

本文轉自 ?紅塵世間 ?51CTO博客，原文鏈接:http://blog.51cto.com/hongchen99/1931761

總結

以上是生活随笔為你收集整理的mysql基础（一） 编译安装mysql5.5的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。