源碼編譯安裝mysql 添加mysql組和mysql用戶(hù) ? [root@centos mysql]# groupadd mysql?
[root@centos mysql]# useradd -g mysql mysql ? 編譯與安裝 ? tar -zxvf mysql-5.1.35.tar.gz ./configure \?
--prefix=/usr/local/mysql \?
--localstatedir=/data/mysql/data \????mysql數(shù)據(jù)目錄
--enable-assembler????\?
--with-mysqld-ldflags=-rdynamic \?
--with-client-ldflags=-all-static?\?
--with-plugins=innobase,partition \?
--with-extra-charsets=none \?
--enable-thread-safe-client \ --with-client-ldflags=-all-static?\?以純靜態(tài)方式編譯客戶(hù)端
--with-mysqld-ldflags=-all-static? 以純靜態(tài)方式編譯服務(wù)端 make && make install ? --enable-thread-safe-client?\以線(xiàn)程方式編譯客戶(hù)端
mysql目錄權(quán)限設(shè)置 ? mkdir /usr/local/mysql/var mkdir /var/run/mysqld chmod +w /usr/local/mysql/?
chown -R mysql:mysql /usr/local/mysql/ chown -R mysql:mysql /var/run/mysqld cp /usr/local/mysql/share/mysql/my-innodb-heavy-4G.cnf /etc/my.cnf ? ? 以mysql用戶(hù)初始化數(shù)據(jù)庫(kù)表 ? /usr/local/mysql/bin/mysql_install_db --basedir=/usr/local/mysql --datadir=/data/mysql/data --user=mysql --datadir=/data/mysql/data? 定義mysql數(shù)據(jù)存放目錄 ? 注意:如果把數(shù)據(jù)目錄定義到其它目錄里,得先修改/etc/my.cnf文件,加上以下二行 ? [mysqld] # generic configuration options
port??????????? = 3306
socket????????? = /tmp/mysql.sock # wb config basedir = /usr/local/mysql????????????字義mysql程序目錄
datadir = /data1/mysql/data???????? 定義數(shù)據(jù)目錄 ? 在對(duì)數(shù)據(jù)庫(kù)進(jìn)行初始化表,不然mysql數(shù)據(jù)庫(kù)啟動(dòng)會(huì)報(bào)錯(cuò). ? 啟動(dòng)mysql服務(wù) /usr/local/mysql/bin/mysqld_safe? --user=mysql --datadir=/data/mysql/data? (指定數(shù)據(jù)庫(kù)目錄) ? /usr/local/mysql/bin/mysqld_safe --user=mysql 2>&1 > /dev/null?& posted on 2011-07-10 01:57 Jesuca 閱讀(...) 評(píng)論(...) 編輯 收藏

轉(zhuǎn)載于:https://www.cnblogs.com/Jesuca/archive/2011/07/10/2102098.html

與50位技術(shù)專(zhuān)家面對(duì)面20年技術(shù)見(jiàn)證，附贈(zèng)技術(shù)全景圖

總結(jié)

以上是生活随笔為你收集整理的源码编译安装mysql的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。